This page (revision-4) was last changed on 26-Nov-2021 10:22 by khiggs

This page was created on 26-Nov-2021 10:22 by khiggs

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 5 KB khiggs to previous
3 26-Nov-2021 10:22 4 KB khiggs to previous | to last
2 26-Nov-2021 10:22 7 KB khiggs to previous | to last
1 26-Nov-2021 10:22 7 KB khiggs to last

Page References

Incoming links Outgoing links
PTS_CHCK_ROUTINE(System_Preference)
PTS_CHCK_ROUTINE(System_Preference)

Version management

Difference between version and

At line 37 changed 14 lines
create or replace
FUNCTION ACME_PADAYS (p_eem_id IN NUMBER) RETURN NUMBER AS
v_return number(18,6);
BEGIN
select AMOUNT
into v_return
from P2K_HR_STATISTICS
where eem_id = p_eem_id
and dsc_id = (select ID from p2k_cm_statistic_components
where stat_code = 'STAT-PA-DAYS');
return v_return;
EXCEPTION
WHEN OTHERS then return NULL;
END ACME_PADAYS;
CREATE OR REPLACE
FUNCTION ACME_PTS_SCHED_HOURS(P_PTS_ID IN NUMBER)
RETURN VARCHAR2 AS
--Return system message 0001 if the TS total is less than 40.
v_return VARCHAR2(60);
v_pts_id NUMBER(10):=P_PTS_ID;
v_total_hrs NUMBER(10,2);
BEGIN
SELECT SUM(TIME_OR_AMOUNT)
INTO v_total_hrs
FROM p2k_PR_TIME_SHEET_ENTRIES
WHERE TIME_SHEET_ENTRY_SOURCE <> '05'
AND PTS_ID = v_pts_id
AND DTC_ID IN
(SELECT DTCD.DTC_ID
FROM P2K_CM_TIME_CODE_SETS DTCS, P2K_CM_TIME_CODE_SET_DETAILS DTCD
WHERE DTCS.TIME_CODE_SET_CODE = 'TIME_SHEET_TOTALS'
AND DTCS.ID = DTCD.DTCS_ID);
IF v_total_hrs > 40
THEN v_return:='0001';
END IF;
RETURN v_return;
EXCEPTION
WHEN OTHERS THEN
RETURN '0000';
END ACME_PTS_SCHED_HOURS;
At line 57 changed 2 lines
create public synonym ACME_PADAYS for ACME_PADAYS;
grant execute on ACME_PADAYS to P2K_USER;
create public synonym ACME_PTS_SCHED_HOURSfor ACME_PTS_SCHED_HOURS;
grant execute on ACME_PTS_SCHED_HOURSto P2K_USER;
This page (revision-4) was last changed on 26-Nov-2021 10:22 by khiggsTop