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_HK_IR56_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 137: g_business_group_id hr_organization_units.business_group_id%TYPE; -- for submitting the PAYHKCTL report

133: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
134: g_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE;
135: g_archive_message ff_archive_items.value%TYPE := NULL;
136: g_error_in_quarter BOOLEAN := FALSE;
137: g_business_group_id hr_organization_units.business_group_id%TYPE; -- for submitting the PAYHKCTL report
138:
139: --* Bug 2189137
140: g_employee_number per_all_people_f.employee_number%TYPE;
141:

Line 202: v_legal_entity_id hr_organization_units.organization_id%TYPE;

198: /* Following variables introduced for Bug No : 2740270 */
199: v_fin_start_date date;
200: v_fin_end_date date;
201: v_business_group_id pay_payroll_actions.business_group_id%TYPE;
202: v_legal_entity_id hr_organization_units.organization_id%TYPE;
203: v_reporting_year NUMBER;
204:
205: l_counter number:=1;
206: counter number:=1;

Line 235: c_legal_entity_id hr_organization_units.organization_id%TYPE,

231: /* Bug No : 2740270 - Cursor to get all the assignments in the basis year
232: for whom R,B,I,Q is run */
233: CURSOR check_run
234: ( c_business_group_id pay_payroll_actions.business_group_id%TYPE,
235: c_legal_entity_id hr_organization_units.organization_id%TYPE,
236: c_fin_start_date date,
237: c_fin_end_date date )
238: IS
239: SELECT distinct pac.assignment_id

Line 274: c_legal_entity_id hr_organization_units.organization_id%TYPE,

270: c_end_person_id in per_all_people_f.person_id%TYPE,
271: c_fin_start_date in date,
272: c_fin_end_date in date,
273: c_business_group_id pay_payroll_actions.business_group_id%TYPE,
274: c_legal_entity_id hr_organization_units.organization_id%TYPE,
275: c_reporting_year NUMBER)
276: IS
277: SELECT DISTINCT a.assignment_id assignment_id
278: FROM per_assignments_f a,

Line 389: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

385: -- [ Archive Employee details ]
386: ---------------------------------
387:
388: PROCEDURE Archive_Employee_details(
389: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
390: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
391: p_reporting_year IN Varchar2)
392: IS
393: v_loop_cnt number := 0;

Line 390: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

386: ---------------------------------
387:
388: PROCEDURE Archive_Employee_details(
389: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
390: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
391: p_reporting_year IN Varchar2)
392: IS
393: v_loop_cnt number := 0;
394:

Line 764: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

760: ---------------------------------
761: -- [ Archive Employer details ]
762: ---------------------------------
763: PROCEDURE Archive_Employer_details (
764: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
765: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
766: p_reporting_year IN Varchar2)
767: IS
768: v_loop_cnt number := 0;

Line 765: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

761: -- [ Archive Employer details ]
762: ---------------------------------
763: PROCEDURE Archive_Employer_details (
764: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
765: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
766: p_reporting_year IN Varchar2)
767: IS
768: v_loop_cnt number := 0;
769:

Line 774: (c_legal_entity_id hr_organization_units.organization_id%TYPE,

770: -----------------------------------------
771: --* get employer records to archive
772: -----------------------------------------
773: CURSOR ir56_Employer_info
774: (c_legal_entity_id hr_organization_units.organization_id%TYPE,
775: c_reporting_year Varchar2 )
776: IS
777: SELECT DISTINCT
778: hou.name employer_name,

Line 786: hr_organization_units hou

782: hoi.org_information3 contact_name,
783: p_reporting_year reporting_year,
784: TO_CHAR(SYSDATE,'YYYYMMDD') issue_date
785: FROM hr_organization_information hoi,
786: hr_organization_units hou
787: WHERE hoi.org_information_context = 'HK_LEGAL_EMPLOYER'
788: AND hoi.organization_id = hou.organization_id
789: AND hoi.organization_id = c_legal_entity_id ;
790:

Line 876: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

872: ---------------------------------
873: -- [ Archive Balance details ]
874: ---------------------------------
875: PROCEDURE Archive_Balance_details(
876: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
877: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
878: p_reporting_year IN Varchar2)
879: IS
880:

Line 877: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

873: -- [ Archive Balance details ]
874: ---------------------------------
875: PROCEDURE Archive_Balance_details(
876: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
877: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
878: p_reporting_year IN Varchar2)
879: IS
880:
881: CURSOR max_assign_action_id(c_assignment_id pay_assignment_actions.assignment_id%TYPE,

Line 952: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

948: ---------------------------------
949: -- [ Archive Quarter details ]
950: ---------------------------------
951: PROCEDURE Archive_Quarter_details(
952: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
953: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
954: p_reporting_year IN Varchar2)
955: IS
956: v_loop_cnt number := 0;

Line 953: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

949: -- [ Archive Quarter details ]
950: ---------------------------------
951: PROCEDURE Archive_Quarter_details(
952: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
953: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
954: p_reporting_year IN Varchar2)
955: IS
956: v_loop_cnt number := 0;
957:

Line 1182: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

1178: -- [ Archive Overseas details ]
1179: ---------------------------------
1180:
1181: PROCEDURE Archive_Overseas_Details(
1182: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1183: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1184: p_reporting_year IN Varchar2)
1185: IS
1186: v_loop_cnt number := 0;

Line 1183: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

1179: ---------------------------------
1180:
1181: PROCEDURE Archive_Overseas_Details(
1182: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1183: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1184: p_reporting_year IN Varchar2)
1185: IS
1186: v_loop_cnt number := 0;
1187:

Line 1239: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

1235: RAISE;
1236: End Archive_Overseas_Details;
1237:
1238: Procedure Archive_Excep_Error_dtls(
1239: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1240: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1241: p_reporting_year IN Varchar2)
1242: IS
1243: CURSOR ir56_Employer_info

Line 1240: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

1236: End Archive_Overseas_Details;
1237:
1238: Procedure Archive_Excep_Error_dtls(
1239: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1240: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1241: p_reporting_year IN Varchar2)
1242: IS
1243: CURSOR ir56_Employer_info
1244: (c_legal_entity_id hr_organization_units.organization_id%TYPE,

Line 1244: (c_legal_entity_id hr_organization_units.organization_id%TYPE,

1240: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1241: p_reporting_year IN Varchar2)
1242: IS
1243: CURSOR ir56_Employer_info
1244: (c_legal_entity_id hr_organization_units.organization_id%TYPE,
1245: c_reporting_year Varchar2 )
1246: IS
1247: SELECT DISTINCT
1248: hou.name employer_name,

Line 1252: hr_organization_units hou

1248: hou.name employer_name,
1249: hoi.org_information1 employer_tfn,
1250: p_reporting_year reporting_year
1251: FROM hr_organization_information hoi,
1252: hr_organization_units hou
1253: WHERE hoi.org_information_context = 'HK_LEGAL_EMPLOYER'
1254: AND hoi.organization_id = hou.organization_id
1255: AND hoi.organization_id = c_legal_entity_id ;
1256:

Line 1416: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

1412:
1413:
1414: PROCEDURE Archive_Info
1415: (
1416: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1417: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1418: p_reporting_year IN Varchar2)
1419: IS
1420: res Number;

Line 1417: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

1413:
1414: PROCEDURE Archive_Info
1415: (
1416: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1417: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1418: p_reporting_year IN Varchar2)
1419: IS
1420: res Number;
1421: Begin

Line 1490: v_business_group_id hr_organization_units.business_group_id%TYPE;

1486: p_effective_date in date)
1487: IS
1488: v_person_id per_all_people_f.person_id%TYPE;
1489: v_assignment_id per_all_assignments_f.assignment_id%TYPE;
1490: v_business_group_id hr_organization_units.business_group_id%TYPE;
1491: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;
1492: v_reporting_year varchar2(4);
1493: v_archive_date pay_payroll_actions.effective_date%TYPE;
1494: