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 139: g_business_group_id hr_organization_units.business_group_id%TYPE; -- for submitting the PAYHKCTL report

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

Line 204: v_legal_entity_id hr_organization_units.organization_id%TYPE;

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

Line 237: c_legal_entity_id hr_organization_units.organization_id%TYPE,

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

Line 276: c_legal_entity_id hr_organization_units.organization_id%TYPE,

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

Line 391: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

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

Line 392: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

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

Line 832: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

828: ---------------------------------
829: -- [ Archive Employer details ]
830: ---------------------------------
831: PROCEDURE Archive_Employer_details (
832: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
833: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
834: p_reporting_year IN Varchar2)
835: IS
836: v_loop_cnt number := 0;

Line 833: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

829: -- [ Archive Employer details ]
830: ---------------------------------
831: PROCEDURE Archive_Employer_details (
832: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
833: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
834: p_reporting_year IN Varchar2)
835: IS
836: v_loop_cnt number := 0;
837:

Line 843: (c_legal_entity_id hr_organization_units.organization_id%TYPE,

839: --* get employer records to archive
840: -- Bug 8338664, extract employer_name 60 characters
841: -----------------------------------------
842: CURSOR ir56_Employer_info
843: (c_legal_entity_id hr_organization_units.organization_id%TYPE,
844: c_reporting_year Varchar2 )
845: IS
846: SELECT DISTINCT
847: substr(hou.name,1,60) employer_name,

Line 855: hr_organization_units hou

851: hoi.org_information3 contact_name,
852: p_reporting_year reporting_year,
853: TO_CHAR(SYSDATE,'YYYYMMDD') issue_date
854: FROM hr_organization_information hoi,
855: hr_organization_units hou
856: WHERE hoi.org_information_context = 'HK_LEGAL_EMPLOYER'
857: AND hoi.organization_id = hou.organization_id
858: AND hoi.organization_id = c_legal_entity_id ;
859:

Line 945: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

941: ---------------------------------
942: -- [ Archive Balance details ]
943: ---------------------------------
944: PROCEDURE Archive_Balance_details(
945: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
946: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
947: p_reporting_year IN Varchar2)
948: IS
949:

Line 946: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

942: -- [ Archive Balance details ]
943: ---------------------------------
944: PROCEDURE Archive_Balance_details(
945: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
946: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
947: p_reporting_year IN Varchar2)
948: IS
949:
950: CURSOR max_assign_action_id(c_assignment_id pay_assignment_actions.assignment_id%TYPE,

Line 1021: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

1017: ---------------------------------
1018: -- [ Archive Quarter details ]
1019: ---------------------------------
1020: PROCEDURE Archive_Quarter_details(
1021: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1022: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1023: p_reporting_year IN Varchar2)
1024: IS
1025: v_loop_cnt number := 0;

Line 1022: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

1018: -- [ Archive Quarter details ]
1019: ---------------------------------
1020: PROCEDURE Archive_Quarter_details(
1021: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1022: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1023: p_reporting_year IN Varchar2)
1024: IS
1025: v_loop_cnt number := 0;
1026:

Line 1251: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

1247: -- [ Archive Overseas details ]
1248: ---------------------------------
1249:
1250: PROCEDURE Archive_Overseas_Details(
1251: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1252: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1253: p_reporting_year IN Varchar2)
1254: IS
1255: v_loop_cnt number := 0;

Line 1252: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

1248: ---------------------------------
1249:
1250: PROCEDURE Archive_Overseas_Details(
1251: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1252: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1253: p_reporting_year IN Varchar2)
1254: IS
1255: v_loop_cnt number := 0;
1256:

Line 1308: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

1304: RAISE;
1305: End Archive_Overseas_Details;
1306:
1307: Procedure Archive_Excep_Error_dtls(
1308: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1309: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1310: p_reporting_year IN Varchar2)
1311: IS
1312: CURSOR ir56_Employer_info

Line 1309: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

1305: End Archive_Overseas_Details;
1306:
1307: Procedure Archive_Excep_Error_dtls(
1308: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1309: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1310: p_reporting_year IN Varchar2)
1311: IS
1312: CURSOR ir56_Employer_info
1313: (c_legal_entity_id hr_organization_units.organization_id%TYPE,

Line 1313: (c_legal_entity_id hr_organization_units.organization_id%TYPE,

1309: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1310: p_reporting_year IN Varchar2)
1311: IS
1312: CURSOR ir56_Employer_info
1313: (c_legal_entity_id hr_organization_units.organization_id%TYPE,
1314: c_reporting_year Varchar2 )
1315: IS
1316: SELECT DISTINCT
1317: hou.name employer_name,

Line 1321: hr_organization_units hou

1317: hou.name employer_name,
1318: hoi.org_information1 employer_tfn,
1319: p_reporting_year reporting_year
1320: FROM hr_organization_information hoi,
1321: hr_organization_units hou
1322: WHERE hoi.org_information_context = 'HK_LEGAL_EMPLOYER'
1323: AND hoi.organization_id = hou.organization_id
1324: AND hoi.organization_id = c_legal_entity_id ;
1325:

Line 1485: p_business_group_id IN hr_organization_units.business_group_id%TYPE,

1481:
1482:
1483: PROCEDURE Archive_Info
1484: (
1485: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1486: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1487: p_reporting_year IN Varchar2)
1488: IS
1489: res Number;

Line 1486: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,

1482:
1483: PROCEDURE Archive_Info
1484: (
1485: p_business_group_id IN hr_organization_units.business_group_id%TYPE,
1486: p_legal_entity_id IN hr_organization_units.organization_id%TYPE,
1487: p_reporting_year IN Varchar2)
1488: IS
1489: res Number;
1490: Begin

Line 1559: v_business_group_id hr_organization_units.business_group_id%TYPE;

1555: p_effective_date in date)
1556: IS
1557: v_person_id per_all_people_f.person_id%TYPE;
1558: v_assignment_id per_all_assignments_f.assignment_id%TYPE;
1559: v_business_group_id hr_organization_units.business_group_id%TYPE;
1560: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;
1561: v_reporting_year varchar2(4);
1562: v_archive_date pay_payroll_actions.effective_date%TYPE;
1563: