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.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 24: Affiliation records in pay_action_information table.

20: Name : per_mx_ssaffl_archive
21:
22: Description : This package is used by the Social Security Affiliation
23: Archive process to archive the Hire/Rehire, Termination
24: Affiliation records in pay_action_information table.
25:
26: Change List
27: -----------
28: Date Name Vers Bug No Description

Line 1090: -- call the api to insert the record in pay_action_information

1086: msg('Worker ID : ' || lv_worker_id );
1087: msg('Leaving Reason : ' || lv_leaving_reason );
1088: msg('Layout Identifier : ' || lv_layout_identifier);
1089:
1090: -- call the api to insert the record in pay_action_information
1091: pay_action_information_api.create_action_information(
1092: p_action_information_id => ln_action_information_id
1093: ,p_object_version_number => ln_object_version_number
1094: ,p_action_information_category => 'MX SS SEPARATION DETAILS'

Line 1091: pay_action_information_api.create_action_information(

1087: msg('Leaving Reason : ' || lv_leaving_reason );
1088: msg('Layout Identifier : ' || lv_layout_identifier);
1089:
1090: -- call the api to insert the record in pay_action_information
1091: pay_action_information_api.create_action_information(
1092: p_action_information_id => ln_action_information_id
1093: ,p_object_version_number => ln_object_version_number
1094: ,p_action_information_category => 'MX SS SEPARATION DETAILS'
1095: ,p_action_context_id => p_assignment_action_id

Line 1369: dbg('call api to insert the record in pay action information with parameters' );

1365: ln_idw := round(ln_idw,2) ;
1366:
1367: dbg('IDW with 2 decimal '||to_char(ln_idw) );
1368:
1369: dbg('call api to insert the record in pay action information with parameters' );
1370: msg('Action_information_category : ' || 'MX SS HIRE DETAILS' );
1371: msg('Action Context Id : ' || to_char(p_assignment_action_id) );
1372: msg('ER SS Number is : ' || lv_er_ss_number );
1373: msg('EE SS Number is : ' || lv_emp_ss_number );

Line 1390: -- call the api to insert the record in pay_action_information

1386: msg('CURP : ' || lv_curp );
1387: msg('Layout Identifier : ' || lv_layout_identifier );
1388:
1389:
1390: -- call the api to insert the record in pay_action_information
1391: pay_action_information_api.create_action_information(
1392: p_action_information_id => ln_action_information_id
1393: ,p_object_version_number => ln_object_version_number
1394: ,p_action_information_category => 'MX SS HIRE DETAILS'

Line 1391: pay_action_information_api.create_action_information(

1387: msg('Layout Identifier : ' || lv_layout_identifier );
1388:
1389:
1390: -- call the api to insert the record in pay_action_information
1391: pay_action_information_api.create_action_information(
1392: p_action_information_id => ln_action_information_id
1393: ,p_object_version_number => ln_object_version_number
1394: ,p_action_information_category => 'MX SS HIRE DETAILS'
1395: ,p_action_context_id => p_assignment_action_id

Line 1522: -- call the archive_hire_details to insert into pay_action_information table

1518: msg('Archiving Hire details for assignment number ' || p_assignment_number );
1519: msg('GRE : ' || lv_gre_name );
1520: msg('Assignment Id : ' || to_char(p_assignment_id) ) ;
1521: msg('GRE Id : ' || to_char(p_gre_id) ) ;
1522: -- call the archive_hire_details to insert into pay_action_information table
1523: archive_hire_details( p_assignment_action_id => p_assignment_action_id
1524: ,p_assignment_id => p_assignment_id
1525: ,p_effective_date => p_effective_date
1526: ,p_tax_unit_id => p_gre_id

Line 1535: -- call the archive_sep_details to insert into pay_action_information table

1531: msg('Archiving Separation details for assignment number ' || p_assignment_number );
1532: msg('GRE : ' || lv_gre_name );
1533: msg('Assignment Id : ' || to_char(p_assignment_id ) ) ;
1534: msg('GRE Id : ' || to_char(p_gre_id ) ) ;
1535: -- call the archive_sep_details to insert into pay_action_information table
1536: archive_sep_details( p_assignment_action_id => p_assignment_action_id
1537: ,p_assignment_id => p_assignment_id
1538: ,p_effective_date => p_effective_date
1539: ,p_tax_unit_id => p_gre_id

Line 1549: -- call the archive_hire_details to insert into pay_action_information table

1545: msg('Archiving Reverse Terminataion Rehire details for assignment number ' || p_assignment_number );
1546: msg('GRE : ' || lv_gre_name );
1547: msg('Assignment Id : ' || to_char(p_assignment_id) ) ;
1548: msg('GRE Id : ' || to_char(p_gre_id) ) ;
1549: -- call the archive_hire_details to insert into pay_action_information table
1550: archive_hire_details( p_assignment_action_id => p_assignment_action_id
1551: ,p_assignment_id => p_assignment_id
1552: ,p_effective_date => p_effective_date
1553: ,p_tax_unit_id => p_gre_id

Line 1593: from pay_action_information pai,

1589: cp_effective_date date,
1590: cp_action_info_category varchar2 )
1591: is
1592: select 'Y'
1593: from pay_action_information pai,
1594: per_all_assignments_f paf
1595: where pai.action_context_type ='AAP'
1596: and pai.action_information_category = cp_action_info_category
1597: and pai.tax_unit_id = cp_gre_id

Line 1834: from pay_action_information pai,

1830: cp_effective_date date,
1831: cp_action_info_category varchar2 )
1832: is
1833: select 'Y'
1834: from pay_action_information pai,
1835: per_all_assignments_f paf
1836: where pai.action_context_type ='AAP'
1837: and pai.action_information_category = cp_action_info_category
1838: and pai.tax_unit_id = cp_gre_id

Line 2161: from pay_action_information pai,

2157: cp_effective_date date,
2158: cp_action_info_category varchar2 )
2159: is
2160: select 'Y'
2161: from pay_action_information pai,
2162: per_all_assignments_f paf
2163: where pai.action_context_type ='AAP'
2164: and pai.action_information_category = cp_action_info_category
2165: and pai.tax_unit_id = cp_gre_id

Line 2467: from pay_action_information pai

2463: cp_effective_date date,
2464: cp_action_info_category varchar2 )
2465: is
2466: select 'Y'
2467: from pay_action_information pai
2468: where pai.action_context_type ='AAP'
2469: and pai.action_information_category = cp_action_info_category
2470: and pai.assignment_id = cp_assignment_id
2471: and trunc(pai.effective_date) = trunc(cp_effective_date) ;