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 271: L_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;

267: END BEFOREREPORT;
268:
269: FUNCTION CF_CALC_TOTALSFORMULA(ASSIGNMENT_ID IN NUMBER,TAX_UNIT_ID IN NUMBER,EMP_TYPE IN VARCHAR2,TERM_DATE IN DATE) RETURN NUMBER IS
270:
271: L_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
272: L_TERM_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
273: L_DISPLAY_FLAG VARCHAR2(5);
274: L_FBT_VALUE NUMBER;
275: X NUMBER;

Line 272: L_TERM_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;

268:
269: FUNCTION CF_CALC_TOTALSFORMULA(ASSIGNMENT_ID IN NUMBER,TAX_UNIT_ID IN NUMBER,EMP_TYPE IN VARCHAR2,TERM_DATE IN DATE) RETURN NUMBER IS
270:
271: L_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
272: L_TERM_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
273: L_DISPLAY_FLAG VARCHAR2(5);
274: L_FBT_VALUE NUMBER;
275: X NUMBER;
276: L_MANUAL_PS_YEAR VARCHAR2(80);

Line 352: L_FBT_VALUE := PAY_AU_RECON_SUMMARY.GET_TOTAL_FBT(CP_FIN_YR_START

348: IF EMP_TYPE = 'T' THEN
349: 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
350: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
351: CP_TOTAL_TERMINATED_EMPLOYEES := CP_TOTAL_TERMINATED_EMPLOYEES + 1;
352: L_FBT_VALUE := PAY_AU_RECON_SUMMARY.GET_TOTAL_FBT(CP_FIN_YR_START
353: ,ASSIGNMENT_ID
354: ,TAX_UNIT_ID
355: ,CP_FBT_GLOBAL
356: ,CP_ML_GLOBAL

Line 359: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID

355: ,CP_FBT_GLOBAL
356: ,CP_ML_GLOBAL
357: ,'PRV_TERM');
358: CP_TOTAL_RFB := CP_TOTAL_RFB + L_FBT_VALUE;
359: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
360: ,CP_FINANCIAL_YEAR
361: ,CP_FIN_YR_END
362: ,TAX_UNIT_ID);
363: IF MANUAL_PS_ISSUED = 'Y' THEN

Line 375: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START

371: IF (LP_EMPLOYEE_TYPE = '%' AND CP_DIMENSION < '_ASG_LE_YTD') THEN
372: L_DISPLAY_FLAG := 'YES';
373: IF (EMP_TYPE = 'T') THEN
374: IF (TERM_DATE < CP_FIN_YR_START) THEN
375: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
376: ,CP_FIN_YR_END
377: ,ASSIGNMENT_ID
378: ,CP_FBT_GLOBAL
379: ,CP_ML_GLOBAL

Line 392: PAY_AU_RECON_SUMMARY.GET_ASSGT_CURR_TERM_VALUES_BBR(P_YEAR_START => CP_FIN_YR_START

388:
389: END IF;
390: IF L_DISPLAY_FLAG = 'YES' THEN
391: CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
392: PAY_AU_RECON_SUMMARY.GET_ASSGT_CURR_TERM_VALUES_BBR(P_YEAR_START => CP_FIN_YR_START
393: ,P_YEAR_END => CP_FIN_YR_END
394: ,P_ASSIGNMENT_ID => ASSIGNMENT_ID
395: ,P_FBT_RATE => CP_FBT_GLOBAL
396: ,P_ML_RATE => CP_ML_GLOBAL

Line 422: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID

418: CP_TOTAL_TAXABLE_COMP := CP_TOTAL_TAXABLE_COMP + L_TERM_OUTPUT_TAB(4).BALANCE_VALUE;
419:
420: END IF;
421: END IF;
422: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
423: ,CP_FINANCIAL_YEAR
424: ,CP_FIN_YR_END
425: ,TAX_UNIT_ID);
426: END IF;

Line 428: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START

424: ,CP_FIN_YR_END
425: ,TAX_UNIT_ID);
426: END IF;
427: ELSE
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 477: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID

473: CP_TOTAL_TAX_FREE_COMP := CP_TOTAL_TAX_FREE_COMP + L_OUTPUT_TAB(12).BALANCE_VALUE + L_OUTPUT_TAB(14).BALANCE_VALUE;
474: CP_TOTAL_TAXABLE_COMP := CP_TOTAL_TAXABLE_COMP + L_OUTPUT_TAB(13).BALANCE_VALUE;
475:
476: END IF;
477: X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
478: ,CP_FINANCIAL_YEAR
479: ,CP_FIN_YR_END
480: ,TAX_UNIT_ID);
481: END IF;

Line 485: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START

481: END IF;
482: END IF;
483: IF MANUAL_PS_ISSUED = 'Y' THEN
484: IF (LP_EMPLOYEE_TYPE = '%' AND CP_DIMENSION < '_ASG_LE_YTD') THEN
485: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
486: ,CP_FIN_YR_END
487: ,ASSIGNMENT_ID
488: ,CP_FBT_GLOBAL
489: ,CP_ML_GLOBAL

Line 538: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START

534: IF (FOREIGN_PS_EXISTS = 'Y')
535: THEN
536: IF (LP_EMPLOYEE_TYPE= '%' AND CP_DIMENSION <> '_ASG_LE_YTD' AND MANUAL_PS_ISSUED <> 'Y')
537: THEN
538: PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
539: ,CP_FIN_YR_END
540: ,ASSIGNMENT_ID
541: ,CP_FBT_GLOBAL
542: ,CP_ML_GLOBAL

Line 614: L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;

610: AND PPA.ACTION_STATUS = 'C'
611: AND PPA.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' );
612:
613: L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;
614: L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
615: L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
616:
617: BEGIN
618: L_GROUP_OUTPUT_TAB.DELETE;

Line 615: L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;

611: AND PPA.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' );
612:
613: L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;
614: L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
615: L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
616:
617: BEGIN
618: L_GROUP_OUTPUT_TAB.DELETE;
619: CP_ASSGT_COUNTER := CP_ASSGT_COUNTER + 1;

Line 625: PAY_AU_RECON_SUMMARY.POPULATE_GROUP_DEF_BAL_IDS(P_DIMENSION_NAME => CP_DIMENSION

621: OPEN CSR_MAX_ASSGT_ACTION;
622: FETCH CSR_MAX_ASSGT_ACTION
623: INTO L_ASSIGNMENT_ACTION_ID;
624: CLOSE CSR_MAX_ASSGT_ACTION;
625: PAY_AU_RECON_SUMMARY.POPULATE_GROUP_DEF_BAL_IDS(P_DIMENSION_NAME => CP_DIMENSION
626: ,p_business_group_id => LP_BUSINESS_GROUP_ID); -- added for bug 7571001
627: PAY_AU_RECON_SUMMARY.GET_GROUP_VALUES_BBR(p_year_start => CP_FIN_YR_START -- added for bug 7571001
628: , p_year_end => CP_FIN_YR_END -- added for bug 7571001
629: ,P_ASSIGNMENT_ACTION_ID => L_ASSIGNMENT_ACTION_ID

Line 627: PAY_AU_RECON_SUMMARY.GET_GROUP_VALUES_BBR(p_year_start => CP_FIN_YR_START -- added for bug 7571001

623: INTO L_ASSIGNMENT_ACTION_ID;
624: CLOSE CSR_MAX_ASSGT_ACTION;
625: PAY_AU_RECON_SUMMARY.POPULATE_GROUP_DEF_BAL_IDS(P_DIMENSION_NAME => CP_DIMENSION
626: ,p_business_group_id => LP_BUSINESS_GROUP_ID); -- added for bug 7571001
627: PAY_AU_RECON_SUMMARY.GET_GROUP_VALUES_BBR(p_year_start => CP_FIN_YR_START -- added for bug 7571001
628: , p_year_end => CP_FIN_YR_END -- added for bug 7571001
629: ,P_ASSIGNMENT_ACTION_ID => L_ASSIGNMENT_ACTION_ID
630: ,P_DATE_EARNED => CP_FIN_YR_END
631: ,P_TAX_UNIT_ID => LP_REGISTERED_EMPLOYER