APPS.PAY_PAYJPNUI_XMLP_PKG dependencies on PAY_JP_REPORT_PKG

Line 14: L_UI_NUMBER := PAY_JP_REPORT_PKG.SUBSTRB2(PAY_JP_BALANCE_PKG.GET_ENTRY_VALUE_CHAR(G_UI_NUMBER_IV_ID

10: L_DATE_DAY NUMBER;
11: L_DUMMY NUMBER;
12: L_UI_NUMBER VARCHAR2(11);
13: BEGIN
14: L_UI_NUMBER := PAY_JP_REPORT_PKG.SUBSTRB2(PAY_JP_BALANCE_PKG.GET_ENTRY_VALUE_CHAR(G_UI_NUMBER_IV_ID
15: ,ASSIGNMENT_ID
16: ,EFFECTIVE_DATE)
17: ,1
18: ,11);

Line 20: CP_UI_NUMBER := PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER

16: ,EFFECTIVE_DATE)
17: ,1
18: ,11);
19: IF L_UI_NUMBER IS NOT NULL THEN
20: CP_UI_NUMBER := PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER
21: ,1
22: ,4) || '-' || PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER
23: ,5
24: ,6) || '-' || PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER

Line 22: ,4) || '-' || PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER

18: ,11);
19: IF L_UI_NUMBER IS NOT NULL THEN
20: CP_UI_NUMBER := PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER
21: ,1
22: ,4) || '-' || PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER
23: ,5
24: ,6) || '-' || PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER
25: ,11
26: ,1);

Line 24: ,6) || '-' || PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER

20: CP_UI_NUMBER := PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER
21: ,1
22: ,4) || '-' || PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER
23: ,5
24: ,6) || '-' || PAY_JP_REPORT_PKG.SUBSTRB2(L_UI_NUMBER
25: ,11
26: ,1);
27: ELSE
28: CP_UI_NUMBER := L_UI_NUMBER;

Line 30: PAY_JP_REPORT_PKG.TO_ERA(TARGET_DATE

26: ,1);
27: ELSE
28: CP_UI_NUMBER := L_UI_NUMBER;
29: END IF;
30: PAY_JP_REPORT_PKG.TO_ERA(TARGET_DATE
31: ,L_DATE_ERA_CODE
32: ,L_DATE_YEAR
33: ,L_DATE_MONTH
34: ,L_DATE_DAY);

Line 44: PAY_JP_REPORT_PKG.TO_ERA(DATE_OF_BIRTH

40: ,2
41: ,'0') || LPAD(TO_CHAR(L_DATE_DAY)
42: ,2
43: ,'0');
44: PAY_JP_REPORT_PKG.TO_ERA(DATE_OF_BIRTH
45: ,L_DATE_ERA_CODE
46: ,L_DATE_YEAR
47: ,L_DATE_MONTH
48: ,L_DATE_DAY);

Line 59: PAY_JP_REPORT_PKG.TO_ERA(PAY_JP_BALANCE_PKG.GET_ENTRY_VALUE_DATE(G_QUALIFIED_DATE_IV_ID

55: ,'0') || LPAD(TO_CHAR(L_DATE_DAY)
56: ,2
57: ,'0');
58: IF P_REPORT_TYPE = '3' THEN
59: PAY_JP_REPORT_PKG.TO_ERA(PAY_JP_BALANCE_PKG.GET_ENTRY_VALUE_DATE(G_QUALIFIED_DATE_IV_ID
60: ,ASSIGNMENT_ID
61: ,TARGET_DATE)
62: ,L_DATE_ERA_CODE
63: ,L_DATE_YEAR

Line 84: L_WHERE_CLAUSE_FOR_ASSID := PAY_JP_REPORT_PKG.GET_CONCATENATED_NUMBERS(TO_NUMBER(P_ASSIGNMENT_ID1)

80:
81: FUNCTION AFTERPFORM RETURN BOOLEAN IS
82: L_WHERE_CLAUSE_FOR_ASSID VARCHAR2(150);
83: BEGIN
84: L_WHERE_CLAUSE_FOR_ASSID := PAY_JP_REPORT_PKG.GET_CONCATENATED_NUMBERS(TO_NUMBER(P_ASSIGNMENT_ID1)
85: ,TO_NUMBER(P_ASSIGNMENT_ID2)
86: ,TO_NUMBER(P_ASSIGNMENT_ID3)
87: ,TO_NUMBER(P_ASSIGNMENT_ID4)
88: ,TO_NUMBER(P_ASSIGNMENT_ID5)

Line 110: PAY_JP_REPORT_PKG.TO_ERA(SYSDATE

106: L_DATE_DAY NUMBER;
107: L_LEGISLATION_CODE PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
108: BEGIN
109: -- HR_STANDARD.EVENT('BEFORE REPORT');
110: PAY_JP_REPORT_PKG.TO_ERA(SYSDATE
111: ,L_DATE_ERA_CODE
112: ,L_DATE_YEAR
113: ,L_DATE_MONTH
114: ,L_DATE_DAY);

Line 117: CP_OUTPUT_DATE_GLOBAL := PAY_JP_REPORT_PKG.SUBSTRB2(NVL(HR_GENERAL.DECODE_LOOKUP('JP_ERA'

113: ,L_DATE_MONTH
114: ,L_DATE_DAY);
115: L_DATE_YEAR := L_DATE_YEAR - TRUNC(L_DATE_YEAR
116: ,-2);
117: CP_OUTPUT_DATE_GLOBAL := PAY_JP_REPORT_PKG.SUBSTRB2(NVL(HR_GENERAL.DECODE_LOOKUP('JP_ERA'
118: ,TO_CHAR(L_DATE_ERA_CODE))
119: ,' ') || LPAD(NVL(TO_CHAR(L_DATE_YEAR)
120: ,' ')
121: ,2