eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PYAURECP_XMLP_PKG dependencies on PAY_AU_RECON_SUMMARY

Line 108: X := PAY_AU_RECON_SUMMARY.POPULATE_BAL_IDS('Y'

104: where request_id= FND_GLOBAL.conc_request_id;
105: P_ASSIGNMENT_ID:=LP_ASSIGNMENT_ID;
106:
107: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
108: X := PAY_AU_RECON_SUMMARY.POPULATE_BAL_IDS('Y'
109: ,LP_BUSINESS_GROUP_ID
110: ,LP_LST_YR_TERM);
111: -- WHERECLAUSE := NULL;
112: WHERECLAUSE := ' ';

Line 254: L_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;

250: ,EMP_TYPE IN VARCHAR2
251: ,TERM_DATE IN DATE
252: ,DATE_EARNED IN DATE
253: ,ASSIGNMENT_ACTION_ID IN NUMBER) RETURN NUMBER IS
254: L_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
255: L_TERM_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
256: L_DISPLAY_FLAG VARCHAR2(5);
257: L_MESSAGE VARCHAR2(100);
258: L_FBT_VALUE NUMBER;

Line 255: L_TERM_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;

251: ,TERM_DATE IN DATE
252: ,DATE_EARNED IN DATE
253: ,ASSIGNMENT_ACTION_ID IN NUMBER) RETURN NUMBER IS
254: L_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
255: L_TERM_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
256: L_DISPLAY_FLAG VARCHAR2(5);
257: L_MESSAGE VARCHAR2(100);
258: L_FBT_VALUE NUMBER;
259: X NUMBER;

Line 294: L_FBT_VALUE := PAY_AU_RECON_SUMMARY.GET_TOTAL_FBT(CP_FIN_YR_START

290: IF EMP_TYPE = 'T' THEN
291: IF ((LP_LST_YR_TERM = 'Y' AND TERM_DATE > CP_FBT_YR_START) OR (LP_LST_YR_TERM = 'N' AND TERM_DATE > CP_LST_YR_START)) AND TERM_DATE < CP_FIN_YR_START AND DATE_EARNED < CP_FIN_YR_START THEN
292: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
293: CP_TOTAL_TERMINATED_EMPLOYEES := CP_TOTAL_TERMINATED_EMPLOYEES + 1;
294: L_FBT_VALUE := PAY_AU_RECON_SUMMARY.GET_TOTAL_FBT(CP_FIN_YR_START
295: ,ASSIGNMENT_ID
296: ,TAX_UNIT_ID
297: ,CP_FBT_GLOBAL
298: ,CP_ML_GLOBAL

Line 301: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID

297: ,CP_FBT_GLOBAL
298: ,CP_ML_GLOBAL
299: ,'PRV_TERM');
300: CP_TOTAL_RFB := CP_TOTAL_RFB + L_FBT_VALUE;
301: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
302: ,CP_FINANCIAL_YEAR
303: ,CP_FIN_YR_END
304: ,TAX_UNIT_ID);
305: IF MANUAL_PS_ISSUED = 'Y' THEN

Line 317: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START

313: IF (LP_EMPLOYEE_TYPE = '%' AND CP_DIMENSION < '_ASG_LE_YTD') THEN
314: L_DISPLAY_FLAG := 'YES';
315: IF (EMP_TYPE = 'T') THEN
316: IF (TERM_DATE < CP_FIN_YR_START) THEN
317: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
318: ,CP_FIN_YR_END
319: ,ASSIGNMENT_ID
320: ,CP_FBT_GLOBAL
321: ,CP_ML_GLOBAL

Line 338: PAY_AU_RECON_SUMMARY.GET_ASSGT_CURR_TERM_VALUES_BBR(P_YEAR_START => CP_FIN_YR_START

334: END IF;
335: END IF;
336: IF L_DISPLAY_FLAG = 'YES' THEN
337: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
338: PAY_AU_RECON_SUMMARY.GET_ASSGT_CURR_TERM_VALUES_BBR(P_YEAR_START => CP_FIN_YR_START
339: ,P_YEAR_END => CP_FIN_YR_END
340: ,P_ASSIGNMENT_ID => ASSIGNMENT_ID
341: ,P_FBT_RATE => CP_FBT_GLOBAL
342: ,P_ML_RATE => CP_ML_GLOBAL

Line 370: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID

366: CP_TOTAL_ETP_TID := CP_TOTAL_ETP_TID + L_TERM_OUTPUT_TAB(8).BALANCE_VALUE;
367: CP_TOTAL_ASSESSABLE_INCOME := CP_TOTAL_ASSESSABLE_INCOME + L_TERM_OUTPUT_TAB(9).BALANCE_VALUE;
368: END IF;
369: END IF;
370: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
371: ,CP_FINANCIAL_YEAR
372: ,CP_FIN_YR_END
373: ,TAX_UNIT_ID);
374: END IF;

Line 376: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START

372: ,CP_FIN_YR_END
373: ,TAX_UNIT_ID);
374: END IF;
375: ELSE
376: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
377: ,CP_FIN_YR_END
378: ,ASSIGNMENT_ID
379: ,CP_FBT_GLOBAL
380: ,CP_ML_GLOBAL

Line 420: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID

416: CP_TOTAL_GROSS_ETP := CP_TOTAL_GROSS_ETP + L_OUTPUT_TAB(15).BALANCE_VALUE;
417: CP_TOTAL_ETP_TID := CP_TOTAL_ETP_TID + L_OUTPUT_TAB(16).BALANCE_VALUE;
418: CP_TOTAL_ASSESSABLE_INCOME := CP_TOTAL_ASSESSABLE_INCOME + L_OUTPUT_TAB(17).BALANCE_VALUE;
419: END IF;
420: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
421: ,CP_FINANCIAL_YEAR
422: ,CP_FIN_YR_END
423: ,TAX_UNIT_ID);
424: END IF;

Line 428: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START

424: END IF;
425: END IF;
426: IF MANUAL_PS_ISSUED = 'Y' THEN
427: IF (LP_EMPLOYEE_TYPE = '%' AND CP_DIMENSION < '_ASG_LE_YTD') THEN
428: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
429: ,CP_FIN_YR_END
430: ,ASSIGNMENT_ID
431: ,CP_FBT_GLOBAL
432: ,CP_ML_GLOBAL

Line 510: L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;

506: AND PAA.ACTION_STATUS = 'C'
507: AND PPA.ACTION_STATUS = 'C'
508: AND PPA.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' );
509: L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;
510: L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
511: L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
512: BEGIN
513: L_GROUP_OUTPUT_TAB.DELETE;
514: CP_ASSGT_COUNTER := CP_ASSGT_COUNTER + 1;

Line 511: L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;

507: AND PPA.ACTION_STATUS = 'C'
508: AND PPA.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' );
509: L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;
510: L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
511: L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
512: BEGIN
513: L_GROUP_OUTPUT_TAB.DELETE;
514: CP_ASSGT_COUNTER := CP_ASSGT_COUNTER + 1;
515: IF (CP_ASSGT_COUNTER = CP_ASSGT_TOTAL AND LP_EMPLOYEE_TYPE = '%' AND CP_DIMENSION < '_ASG_LE_YTD') THEN

Line 521: PAY_AU_RECON_SUMMARY.POPULATE_GROUP_DEF_BAL_IDS(P_DIMENSION_NAME => CP_DIMENSION);

517: FETCH CSR_MAX_ASSGT_ACTION
518: INTO
519: L_ASSIGNMENT_ACTION_ID;
520: CLOSE CSR_MAX_ASSGT_ACTION;
521: PAY_AU_RECON_SUMMARY.POPULATE_GROUP_DEF_BAL_IDS(P_DIMENSION_NAME => CP_DIMENSION);
522: PAY_AU_RECON_SUMMARY.GET_GROUP_VALUES_BBR(P_ASSIGNMENT_ACTION_ID => L_ASSIGNMENT_ACTION_ID
523: ,P_DATE_EARNED => CP_FIN_YR_END
524: ,P_TAX_UNIT_ID => LP_REGISTERED_EMPLOYER
525: ,P_GROUP_OUTPUT_TAB => L_GROUP_OUTPUT_TAB);

Line 522: PAY_AU_RECON_SUMMARY.GET_GROUP_VALUES_BBR(P_ASSIGNMENT_ACTION_ID => L_ASSIGNMENT_ACTION_ID

518: INTO
519: L_ASSIGNMENT_ACTION_ID;
520: CLOSE CSR_MAX_ASSGT_ACTION;
521: PAY_AU_RECON_SUMMARY.POPULATE_GROUP_DEF_BAL_IDS(P_DIMENSION_NAME => CP_DIMENSION);
522: PAY_AU_RECON_SUMMARY.GET_GROUP_VALUES_BBR(P_ASSIGNMENT_ACTION_ID => L_ASSIGNMENT_ACTION_ID
523: ,P_DATE_EARNED => CP_FIN_YR_END
524: ,P_TAX_UNIT_ID => LP_REGISTERED_EMPLOYER
525: ,P_GROUP_OUTPUT_TAB => L_GROUP_OUTPUT_TAB);
526: CP_TOTAL_LUMPSUM_A_PAY := L_GROUP_OUTPUT_TAB(1).BALANCE_VALUE;