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 PAY_ASSIGNMENT_ACTIONS

Line 134: g_assignment_id pay_assignment_actions.assignment_id%TYPE;

130: -- 18 Dec 2008 dduvvuri 7635388 Added cursor ir56f_report_date to fetch last run date of IR56F report.
131: -- 29 Jul 2009 jalin 8338664 Modified employer_name to extract 60 characters
132:
133: --* GLobal variables (populated in archive_code procedure)
134: g_assignment_id pay_assignment_actions.assignment_id%TYPE;
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;

Line 135: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

131: -- 29 Jul 2009 jalin 8338664 Modified employer_name to extract 60 characters
132:
133: --* GLobal variables (populated in archive_code procedure)
134: g_assignment_id pay_assignment_actions.assignment_id%TYPE;
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

Line 197: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;

193: p_start_person_id in per_all_people_f.person_id%TYPE,
194: p_end_person_id in per_all_people_f.person_id%TYPE,
195: p_chunk in number)
196: IS
197: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
198: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
199:
200: /* Following variables introduced for Bug No : 2740270 */
201: v_fin_start_date date;

Line 198: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;

194: p_end_person_id in per_all_people_f.person_id%TYPE,
195: p_chunk in number)
196: IS
197: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
198: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
199:
200: /* Following variables introduced for Bug No : 2740270 */
201: v_fin_start_date date;
202: v_fin_end_date date;

Line 216: SELECT pay_assignment_actions_s.NEXTVAL

212: asglist t_assignment_list;
213:
214:
215: CURSOR next_action_id is
216: SELECT pay_assignment_actions_s.NEXTVAL
217: FROM dual;
218:
219: /* Introduced the following cursor get_params for Bug No : 2740270 */
220:

Line 244: pay_assignment_actions pac

240: IS
241: SELECT distinct pac.assignment_id
242: FROM pay_payroll_actions ppa,
243: pay_payrolls_f pay, /* Added for Bug 3916743 - performance fix. */
244: pay_assignment_actions pac
245: WHERE ppa.action_type in ('R','B','I','Q')
246: AND ppa.payroll_action_id = pac.payroll_action_id
247: AND ppa.business_group_id = c_business_group_id
248: AND pac.tax_unit_id = c_legal_entity_id

Line 297: pay_assignment_actions paa

293: (SELECT NULL
294: FROM pay_action_interlocks pai,
295: pay_payroll_actions ppai,
296: pay_payroll_actions ppaa,
297: pay_assignment_actions paa
298: WHERE paa.assignment_id = a.assignment_id
299: AND ppaa.action_type='X'
300: AND ppaa.report_type = 'HK_IR56B_ARCHIVE'
301: AND ppai.action_type='X'

Line 406: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,

402:
403: /* Bug No : 2829320 - Included substr function for address_lines column so that 240 characters are only fetched */
404: /*Bug 2942797 - Removed column chineese_full_name*/
405: CURSOR ir56_Employee_info
406: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
407: c_reporting_year Varchar2 )
408: IS
409: SELECT DISTINCT
410: papf.national_identifier hk_id_card_no,

Line 490: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,

486:
487: /* 7210187 */
488:
489: CURSOR ir56_Report_info
490: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
491: c_reporting_year Varchar2 )
492: IS
493: SELECT DISTINCT
494: substr(paei.aei_information2,1,10) last_run_date,

Line 509: (c_assignment_id pay_assignment_actions.assignment_id%TYPE)

505: /* 7210187 */
506:
507: /* 7635388 - Cursor ir56f_report_date created to fetch the last run date of IR56F report */
508: CURSOR ir56f_report_date
509: (c_assignment_id pay_assignment_actions.assignment_id%TYPE)
510: IS
511: SELECT TO_CHAR(to_date(paei.aei_information2,'yyyy/mm/dd hh24:mi:ss'),'yyyy/mm/dd')
512: FROM per_assignment_extra_info paei,
513: per_assignment_info_types pait

Line 950: CURSOR max_assign_action_id(c_assignment_id pay_assignment_actions.assignment_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,
951: c_reporting_year Varchar2 )
952: IS
953: SELECT paa.assignment_action_id
954: FROM pay_assignment_actions paa

Line 954: FROM pay_assignment_actions paa

950: CURSOR max_assign_action_id(c_assignment_id pay_assignment_actions.assignment_id%TYPE,
951: c_reporting_year Varchar2 )
952: IS
953: SELECT paa.assignment_action_id
954: FROM pay_assignment_actions paa
955: WHERE paa.assignment_id = c_assignment_id
956: and paa.action_sequence = (select max(paa2.action_sequence)
957: from pay_assignment_actions paa2,
958: pay_payroll_actions ppa

Line 957: from pay_assignment_actions paa2,

953: SELECT paa.assignment_action_id
954: FROM pay_assignment_actions paa
955: WHERE paa.assignment_id = c_assignment_id
956: and paa.action_sequence = (select max(paa2.action_sequence)
957: from pay_assignment_actions paa2,
958: pay_payroll_actions ppa
959: where paa2.assignment_id = c_assignment_id
960: and ppa.payroll_action_id = paa2.payroll_action_id
961: and paa2.action_status = 'C'

Line 1059: (c_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

1055:
1056: /* Bug 7184102 Added ORDER BY clause into cursor quarters_info */
1057:
1058: CURSOR quarters_info
1059: (c_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1060: c_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
1061: IS
1062: SELECT b.assignment_id assignment_id,
1063: b.SOURCE_ID source_id,

Line 1060: c_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

1056: /* Bug 7184102 Added ORDER BY clause into cursor quarters_info */
1057:
1058: CURSOR quarters_info
1059: (c_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1060: c_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
1061: IS
1062: SELECT b.assignment_id assignment_id,
1063: b.SOURCE_ID source_id,
1064: b.QUARTERS_ADDRESS quarters_address,

Line 1257: CURSOR os_info (c_assignment_id in pay_assignment_actions.assignment_id%TYPE)

1253: p_reporting_year IN Varchar2)
1254: IS
1255: v_loop_cnt number := 0;
1256:
1257: CURSOR os_info (c_assignment_id in pay_assignment_actions.assignment_id%TYPE)
1258: IS
1259: SELECT *
1260: FROM pay_hk_ir56_overseas_concern_v
1261: WHERE assignment_id = c_assignment_id

Line 1329: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,

1325:
1326: employer_rec ir56_employer_info%ROWTYPE;
1327:
1328: CURSOR ir56_Employee_info
1329: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
1330: c_reporting_year Varchar2 )
1331: IS
1332: SELECT DISTINCT
1333: papf.national_identifier hk_id_card_no,

Line 1554: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,

1550: -- different parameters are required.
1551: ------------------------------------------------------------------------
1552:
1553: PROCEDURE archive_code
1554: (p_assignment_action_id in pay_assignment_actions.assignment_action_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;

Line 1560: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;

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:
1564: CURSOR archive_parameters

Line 1565: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

1561: v_reporting_year varchar2(4);
1562: v_archive_date pay_payroll_actions.effective_date%TYPE;
1563:
1564: CURSOR archive_parameters
1565: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1566: IS
1567: SELECT paa.person_id,
1568: pac.assignment_id,
1569: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

Line 1574: pay_assignment_actions pac,

1570: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1571: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1572: effective_date
1573: FROM pay_payroll_actions ppa,
1574: pay_assignment_actions pac,
1575: per_assignments_f paa
1576: WHERE pac.assignment_action_id = c_assignment_action_id
1577: AND ppa.payroll_action_id = pac.payroll_action_id
1578: AND paa.assignment_id = pac.assignment_id;

Line 1634: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

1630: ---------------------------------------------------------------------------
1631:
1632: PROCEDURE archive_item
1633: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE,
1634: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1635: p_archive_value IN ff_archive_items.value%TYPE)
1636: IS
1637: v_user_entity_id ff_user_entities.user_entity_id%TYPE;
1638: v_archive_item_id ff_archive_items.archive_item_id%TYPE;