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_FI_ARCHIVE_LTFA dependencies on PAY_BALANCE_PKG

Line 368: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

364: g_pension_provider := rg_Legal_Emp_Details.ORG_INFORMATION4 ;
365:
366: --fnd_file.put_line(fnd_file.log,'Range Code 4');
367: BEGIN
368: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
372: pay_balance_pkg.set_context('SOURCE_ID',NULL);

Line 369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);

365:
366: --fnd_file.put_line(fnd_file.log,'Range Code 4');
367: BEGIN
368: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
372: pay_balance_pkg.set_context('SOURCE_ID',NULL);
373: pay_balance_pkg.set_context('TAX_GROUP',NULL);

Line 370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));

366: --fnd_file.put_line(fnd_file.log,'Range Code 4');
367: BEGIN
368: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
372: pay_balance_pkg.set_context('SOURCE_ID',NULL);
373: pay_balance_pkg.set_context('TAX_GROUP',NULL);
374: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);

Line 371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);

367: BEGIN
368: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
372: pay_balance_pkg.set_context('SOURCE_ID',NULL);
373: pay_balance_pkg.set_context('TAX_GROUP',NULL);
374: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);
375: END;

Line 372: pay_balance_pkg.set_context('SOURCE_ID',NULL);

368: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
372: pay_balance_pkg.set_context('SOURCE_ID',NULL);
373: pay_balance_pkg.set_context('TAX_GROUP',NULL);
374: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);
375: END;
376:

Line 373: pay_balance_pkg.set_context('TAX_GROUP',NULL);

369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
372: pay_balance_pkg.set_context('SOURCE_ID',NULL);
373: pay_balance_pkg.set_context('TAX_GROUP',NULL);
374: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);
375: END;
376:
377:

Line 374: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);

370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
371: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
372: pay_balance_pkg.set_context('SOURCE_ID',NULL);
373: pay_balance_pkg.set_context('TAX_GROUP',NULL);
374: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);
375: END;
376:
377:
378:

Line 744: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

740: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 2');
741:
742:
743: BEGIN
744: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
745: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
748: pay_balance_pkg.set_context('SOURCE_ID',NULL);

Line 745: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);

741:
742:
743: BEGIN
744: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
745: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
748: pay_balance_pkg.set_context('SOURCE_ID',NULL);
749: pay_balance_pkg.set_context('TAX_GROUP',NULL);

Line 746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));

742:
743: BEGIN
744: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
745: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
748: pay_balance_pkg.set_context('SOURCE_ID',NULL);
749: pay_balance_pkg.set_context('TAX_GROUP',NULL);
750: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);

Line 747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);

743: BEGIN
744: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
745: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
748: pay_balance_pkg.set_context('SOURCE_ID',NULL);
749: pay_balance_pkg.set_context('TAX_GROUP',NULL);
750: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);
751: END;

Line 748: pay_balance_pkg.set_context('SOURCE_ID',NULL);

744: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
745: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
748: pay_balance_pkg.set_context('SOURCE_ID',NULL);
749: pay_balance_pkg.set_context('TAX_GROUP',NULL);
750: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);
751: END;
752:

Line 749: pay_balance_pkg.set_context('TAX_GROUP',NULL);

745: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
748: pay_balance_pkg.set_context('SOURCE_ID',NULL);
749: pay_balance_pkg.set_context('TAX_GROUP',NULL);
750: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);
751: END;
752:
753: l_canonical_start_date := TO_DATE(l_month||l_year,'MMYYYY');

Line 750: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);

746: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
747: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
748: pay_balance_pkg.set_context('SOURCE_ID',NULL);
749: pay_balance_pkg.set_context('TAX_GROUP',NULL);
750: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider);
751: END;
752:
753: l_canonical_start_date := TO_DATE(l_month||l_year,'MMYYYY');
754: l_canonical_end_date := LAST_DAY(TO_DATE(l_month||l_year,'MMYYYY'));

Line 933: pay_balance_pkg.set_context('ASSIGNMENT_ID',rg_get_person_details.assignment_id);

929:
930: -- Pick up the defined balance id belonging to
931:
932: BEGIN
933: pay_balance_pkg.set_context('ASSIGNMENT_ID',rg_get_person_details.assignment_id);
934: END;
935:
936: l_assignment_id:=rg_get_person_details.assignment_id;
937: --fnd_file.put_line(fnd_file.log,'Archive Code 2');

Line 946: l_Sal_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;

942: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
943: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
944: CLOSE csr_Get_Defined_Balance_Id;
945:
946: l_Sal_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;
947:
948: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
949: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
950: CLOSE csr_Get_Defined_Balance_Id;

Line 952: l_bik_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;

948: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
949: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
950: CLOSE csr_Get_Defined_Balance_Id;
951:
952: l_bik_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;
953:
954: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
955: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
956: CLOSE csr_Get_Defined_Balance_Id;

Line 958: l_tax_exp_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;

954: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
955: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
956: CLOSE csr_Get_Defined_Balance_Id;
957:
958: l_tax_exp_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;
959:
960: /*
961: OPEN csr_Get_Defined_Balance_Id( 'PENSION_PER_PENSION_LU_MONTH');
962: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 965: l_pension :=TO_CHAR(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>g_lu_assignment_action_id ),'999999999D99') * 100;

961: OPEN csr_Get_Defined_Balance_Id( 'PENSION_PER_PENSION_LU_MONTH');
962: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
963: CLOSE csr_Get_Defined_Balance_Id;
964:
965: l_pension :=TO_CHAR(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>g_lu_assignment_action_id ),'999999999D99') * 100;
966:
967: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_PENSION_PER_PENSION_LU_MONTH');
968: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
969: CLOSE csr_Get_Defined_Balance_Id;

Line 971: l_emp_pension :=TO_CHAR(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>g_lu_assignment_action_id ),'999999999D99') *100;

967: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_PENSION_PER_PENSION_LU_MONTH');
968: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
969: CLOSE csr_Get_Defined_Balance_Id;
970:
971: l_emp_pension :=TO_CHAR(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>g_lu_assignment_action_id ),'999999999D99') *100;
972: */
973:
974: --fnd_file.put_line(fnd_file.log,'Archive Code 4');
975:

Line 982: l_Sal_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;

978: --fnd_file.put_line(fnd_file.log,'Archive Code 5');
979: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
980: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
981: CLOSE csr_Get_Defined_Balance_Id;
982: l_Sal_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;
983:
984: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
985: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
986: CLOSE csr_Get_Defined_Balance_Id;

Line 987: l_bik_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;

983:
984: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
985: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
986: CLOSE csr_Get_Defined_Balance_Id;
987: l_bik_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;
988:
989: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
990: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
991: CLOSE csr_Get_Defined_Balance_Id;

Line 992: l_tax_exp_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;

988:
989: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
990: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
991: CLOSE csr_Get_Defined_Balance_Id;
992: l_tax_exp_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;
993:
994: /*
995: OPEN csr_Get_Defined_Balance_Id( 'PENSION_PER_PENSION_LE_MONTH');
996: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 998: l_pension := TO_CHAR(pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, g_legal_employer_id, NULL, NULL, NULL, g_effective_date ),'999999999D99') * 100;

994: /*
995: OPEN csr_Get_Defined_Balance_Id( 'PENSION_PER_PENSION_LE_MONTH');
996: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
997: CLOSE csr_Get_Defined_Balance_Id;
998: l_pension := TO_CHAR(pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, g_legal_employer_id, NULL, NULL, NULL, g_effective_date ),'999999999D99') * 100;
999:
1000: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_PENSION_PER_PENSION_LE_MONTH');
1001: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1002: CLOSE csr_Get_Defined_Balance_Id;

Line 1003: l_emp_pension := TO_CHAR(pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, g_legal_employer_id, NULL, NULL, NULL, g_effective_date ),'999999999D99') *100;

999:
1000: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_PENSION_PER_PENSION_LE_MONTH');
1001: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1002: CLOSE csr_Get_Defined_Balance_Id;
1003: l_emp_pension := TO_CHAR(pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, g_legal_employer_id, NULL, NULL, NULL, g_effective_date ),'999999999D99') *100;
1004: */
1005: --fnd_file.put_line(fnd_file.log,'Archive Code 6');
1006: END IF;
1007: