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_JP_IWHT_ARCH_PKG dependencies on PAY_ACTION_INFORMATION

Line 467: FROM pay_action_information PAI

463: IS
464: SELECT PAI.object_version_number
465: ,PAI.action_information_id
466: ,PAC.assignment_action_id
467: FROM pay_action_information PAI
468: ,pay_assignment_actions PAC
469: ,pay_payroll_actions PPA
470: WHERE PAI.action_context_id = PAC.assignment_action_id
471: AND PAC.assignment_id = p_assignment_id

Line 493: pay_action_information_api.delete_action_information

489: -----------------------------------------------------------
490: --
491: FOR lr_emp_assignment_det in lcu_action_information_id(p_assignment_id)
492: LOOP
493: pay_action_information_api.delete_action_information
494: ( p_validate => FALSE
495: ,p_action_information_id => lr_emp_assignment_det.action_information_id
496: ,p_object_version_number => lr_emp_assignment_det.object_version_number);
497: END LOOP;

Line 589: -- in pay_Action_information with context 'AU_ARCHIVE_ASG_DETAILS'

585: -- This procedure gets the parameters given by user and restricts
586: -- the assignments to be archived
587: -- it then calls hr_nonrun.insact to create an assignment action id
588: -- it then archives Payroll Run assignment action id details
589: -- in pay_Action_information with context 'AU_ARCHIVE_ASG_DETAILS'
590: -- for each assignment.
591: -- There are different cursors for choosing the assignment ids.
592: -- Depending on the parameters passed,the appropriate cursor is used.
593: --

Line 735: ln_action_info_id pay_action_information.action_information_id%TYPE;

731: lc_archive_exists VARCHAR2(1) := 'N';
732: lc_previous_month VARCHAR2(10);
733: lc_include_flag VARCHAR2(1) := 'N';
734: --
735: ln_action_info_id pay_action_information.action_information_id%TYPE;
736: ln_obj_version_num pay_action_information.object_version_number%TYPE;
737: ln_master_pact_id NUMBER;
738: ln_next_assignment_action_id NUMBER;
739: ln_org_pact_id NUMBER;

Line 736: ln_obj_version_num pay_action_information.object_version_number%TYPE;

732: lc_previous_month VARCHAR2(10);
733: lc_include_flag VARCHAR2(1) := 'N';
734: --
735: ln_action_info_id pay_action_information.action_information_id%TYPE;
736: ln_obj_version_num pay_action_information.object_version_number%TYPE;
737: ln_master_pact_id NUMBER;
738: ln_next_assignment_action_id NUMBER;
739: ln_org_pact_id NUMBER;
740: --

Line 919: -- details in pay_Action_information with context 'JP_EMPOYEE_DETAILS'

915: -- ARCHIVE_CODE
916: --
917: -- DESCRIPTION
918: -- If employee details not previously archived,proc archives employee
919: -- details in pay_Action_information with context 'JP_EMPOYEE_DETAILS'
920: --
921: -- ACCESS
922: -- PUBLIC
923: --

Line 1120: FROM pay_action_information PAI

1116: --
1117: CURSOR lcu_prev_archive (p_assignment_id per_all_assignments_f.assignment_id%TYPE)
1118: IS
1119: SELECT 'Y'
1120: FROM pay_action_information PAI
1121: ,pay_assignment_actions PAC
1122: ,pay_payroll_actions PPA
1123: WHERE PAI.action_context_id = PAC.assignment_action_id
1124: AND PAC.assignment_id = p_assignment_id

Line 1135: lc_description1 pay_action_information.action_information23%TYPE;

1131: lc_swot_address_line2 VARCHAR2(150);
1132: lc_swot_address_line3 VARCHAR2(150);
1133: lc_swot_phone_number VARCHAR2(150);
1134: lc_swot_employer VARCHAR2(150);
1135: lc_description1 pay_action_information.action_information23%TYPE;
1136: lc_description2 pay_action_information.action_information24%TYPE;
1137: lc_descfield pay_action_information.action_information23%TYPE;
1138: lc_descfield2 pay_action_information.action_information23%TYPE;
1139: lc_descfield3 pay_action_information.action_information23%TYPE;

Line 1136: lc_description2 pay_action_information.action_information24%TYPE;

1132: lc_swot_address_line3 VARCHAR2(150);
1133: lc_swot_phone_number VARCHAR2(150);
1134: lc_swot_employer VARCHAR2(150);
1135: lc_description1 pay_action_information.action_information23%TYPE;
1136: lc_description2 pay_action_information.action_information24%TYPE;
1137: lc_descfield pay_action_information.action_information23%TYPE;
1138: lc_descfield2 pay_action_information.action_information23%TYPE;
1139: lc_descfield3 pay_action_information.action_information23%TYPE;
1140: lc_descfield4 pay_action_information.action_information24%TYPE;

Line 1137: lc_descfield pay_action_information.action_information23%TYPE;

1133: lc_swot_phone_number VARCHAR2(150);
1134: lc_swot_employer VARCHAR2(150);
1135: lc_description1 pay_action_information.action_information23%TYPE;
1136: lc_description2 pay_action_information.action_information24%TYPE;
1137: lc_descfield pay_action_information.action_information23%TYPE;
1138: lc_descfield2 pay_action_information.action_information23%TYPE;
1139: lc_descfield3 pay_action_information.action_information23%TYPE;
1140: lc_descfield4 pay_action_information.action_information24%TYPE;
1141: lc_descfield5 pay_action_information.action_information24%TYPE;

Line 1138: lc_descfield2 pay_action_information.action_information23%TYPE;

1134: lc_swot_employer VARCHAR2(150);
1135: lc_description1 pay_action_information.action_information23%TYPE;
1136: lc_description2 pay_action_information.action_information24%TYPE;
1137: lc_descfield pay_action_information.action_information23%TYPE;
1138: lc_descfield2 pay_action_information.action_information23%TYPE;
1139: lc_descfield3 pay_action_information.action_information23%TYPE;
1140: lc_descfield4 pay_action_information.action_information24%TYPE;
1141: lc_descfield5 pay_action_information.action_information24%TYPE;
1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;

Line 1139: lc_descfield3 pay_action_information.action_information23%TYPE;

1135: lc_description1 pay_action_information.action_information23%TYPE;
1136: lc_description2 pay_action_information.action_information24%TYPE;
1137: lc_descfield pay_action_information.action_information23%TYPE;
1138: lc_descfield2 pay_action_information.action_information23%TYPE;
1139: lc_descfield3 pay_action_information.action_information23%TYPE;
1140: lc_descfield4 pay_action_information.action_information24%TYPE;
1141: lc_descfield5 pay_action_information.action_information24%TYPE;
1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;
1143: lc_1st_jan_address_line1 per_addresses.address_line1%TYPE;

Line 1140: lc_descfield4 pay_action_information.action_information24%TYPE;

1136: lc_description2 pay_action_information.action_information24%TYPE;
1137: lc_descfield pay_action_information.action_information23%TYPE;
1138: lc_descfield2 pay_action_information.action_information23%TYPE;
1139: lc_descfield3 pay_action_information.action_information23%TYPE;
1140: lc_descfield4 pay_action_information.action_information24%TYPE;
1141: lc_descfield5 pay_action_information.action_information24%TYPE;
1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;
1143: lc_1st_jan_address_line1 per_addresses.address_line1%TYPE;
1144: lc_1st_jan_address_line2 per_addresses.address_line2%TYPE;

Line 1141: lc_descfield5 pay_action_information.action_information24%TYPE;

1137: lc_descfield pay_action_information.action_information23%TYPE;
1138: lc_descfield2 pay_action_information.action_information23%TYPE;
1139: lc_descfield3 pay_action_information.action_information23%TYPE;
1140: lc_descfield4 pay_action_information.action_information24%TYPE;
1141: lc_descfield5 pay_action_information.action_information24%TYPE;
1142: lc_1st_jan_district_code per_addresses.town_or_city%TYPE;
1143: lc_1st_jan_address_line1 per_addresses.address_line1%TYPE;
1144: lc_1st_jan_address_line2 per_addresses.address_line2%TYPE;
1145: lc_1st_jan_address_line3 per_addresses.address_line3%TYPE;

Line 1152: lc_description_temp pay_action_information.action_information23%TYPE;

1148: lc_check_flag VARCHAR2(10) DEFAULT 'N';
1149: l_allow_str VARCHAR2(60);
1150: l_yos_str VARCHAR2(60);
1151: l_ovr_yos_str VARCHAR2(60);
1152: lc_description_temp pay_action_information.action_information23%TYPE;
1153:
1154: --
1155: ln_action_info_id pay_action_information.action_information_id%TYPE;
1156: ln_obj_version_num pay_action_information.object_version_number%TYPE;

Line 1155: ln_action_info_id pay_action_information.action_information_id%TYPE;

1151: l_ovr_yos_str VARCHAR2(60);
1152: lc_description_temp pay_action_information.action_information23%TYPE;
1153:
1154: --
1155: ln_action_info_id pay_action_information.action_information_id%TYPE;
1156: ln_obj_version_num pay_action_information.object_version_number%TYPE;
1157: ln_tax_action_info_id pay_action_information.action_information_id%TYPE;
1158: ln_tax_obj_version_num pay_action_information.object_version_number%TYPE;
1159: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 1156: ln_obj_version_num pay_action_information.object_version_number%TYPE;

1152: lc_description_temp pay_action_information.action_information23%TYPE;
1153:
1154: --
1155: ln_action_info_id pay_action_information.action_information_id%TYPE;
1156: ln_obj_version_num pay_action_information.object_version_number%TYPE;
1157: ln_tax_action_info_id pay_action_information.action_information_id%TYPE;
1158: ln_tax_obj_version_num pay_action_information.object_version_number%TYPE;
1159: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
1160: ln_service_years NUMBER;

Line 1157: ln_tax_action_info_id pay_action_information.action_information_id%TYPE;

1153:
1154: --
1155: ln_action_info_id pay_action_information.action_information_id%TYPE;
1156: ln_obj_version_num pay_action_information.object_version_number%TYPE;
1157: ln_tax_action_info_id pay_action_information.action_information_id%TYPE;
1158: ln_tax_obj_version_num pay_action_information.object_version_number%TYPE;
1159: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
1160: ln_service_years NUMBER;
1161: ln_termination_money NUMBER;

Line 1158: ln_tax_obj_version_num pay_action_information.object_version_number%TYPE;

1154: --
1155: ln_action_info_id pay_action_information.action_information_id%TYPE;
1156: ln_obj_version_num pay_action_information.object_version_number%TYPE;
1157: ln_tax_action_info_id pay_action_information.action_information_id%TYPE;
1158: ln_tax_obj_version_num pay_action_information.object_version_number%TYPE;
1159: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
1160: ln_service_years NUMBER;
1161: ln_termination_money NUMBER;
1162: ln_withholidng_tax NUMBER;

Line 1373: pay_action_information_api.create_action_information

1369:
1370: --
1371: --JP_IWHT_EMP Info
1372: --
1373: pay_action_information_api.create_action_information
1374: (
1375: p_validate => FALSE
1376: ,p_action_context_id => p_assignment_action_id
1377: ,p_action_context_type => 'AAP'

Line 1428: pay_action_information_api.create_action_information

1424: ,ln_muncipal_tax
1425: ,ln_prefectural_tax;
1426: CLOSE lcu_tax_details;
1427: --
1428: pay_action_information_api.create_action_information
1429: (
1430: p_validate => FALSE
1431: ,p_action_context_id => p_assignment_action_id
1432: ,p_action_context_type => 'AAP'

Line 1515: FROM pay_action_information PAI

1511: WHERE PAA.payroll_action_id = PPA.payroll_action_id
1512: AND PAA.action_status = 'C'
1513: AND PPA.report_type = gc_report_type
1514: AND NOT EXISTS( SELECT NULL
1515: FROM pay_action_information PAI
1516: WHERE PAI.action_context_id = PAA.assignment_action_id
1517: AND PAI.action_context_type = 'AAP');
1518:
1519: --