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_CA_T4_CANCEL_MAG dependencies on FF_ARCHIVE_ITEMS

Line 144: lv_fed_amend_flag ff_archive_items.value%TYPE;

140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
142: lv_report_type pay_payroll_actions.report_type%TYPE ;
143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
144: lv_fed_amend_flag ff_archive_items.value%TYPE;
145: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
146: lv_flag_count NUMBER := 0;
147: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
148: l_payroll_act NUMBER;

Line 278: l_trans_no ff_archive_items.value%TYPE;

274: l_trans_gre hr_all_organization_units.organization_id%TYPE;
275: l_year VARCHAR2(10);
276: l_gre hr_all_organization_units.organization_id%TYPE;
277: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
278: l_trans_no ff_archive_items.value%TYPE;
279: l_tech_name ff_archive_items.value%TYPE;
280: l_tech_area ff_archive_items.value%TYPE;
281: l_tech_phno ff_archive_items.value%TYPE;
282: l_tech_email ff_archive_items.value%TYPE;

Line 279: l_tech_name ff_archive_items.value%TYPE;

275: l_year VARCHAR2(10);
276: l_gre hr_all_organization_units.organization_id%TYPE;
277: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
278: l_trans_no ff_archive_items.value%TYPE;
279: l_tech_name ff_archive_items.value%TYPE;
280: l_tech_area ff_archive_items.value%TYPE;
281: l_tech_phno ff_archive_items.value%TYPE;
282: l_tech_email ff_archive_items.value%TYPE;
283: l_lang ff_archive_items.value%TYPE;

Line 280: l_tech_area ff_archive_items.value%TYPE;

276: l_gre hr_all_organization_units.organization_id%TYPE;
277: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
278: l_trans_no ff_archive_items.value%TYPE;
279: l_tech_name ff_archive_items.value%TYPE;
280: l_tech_area ff_archive_items.value%TYPE;
281: l_tech_phno ff_archive_items.value%TYPE;
282: l_tech_email ff_archive_items.value%TYPE;
283: l_lang ff_archive_items.value%TYPE;
284: l_acc_name ff_archive_items.value%TYPE;

Line 281: l_tech_phno ff_archive_items.value%TYPE;

277: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
278: l_trans_no ff_archive_items.value%TYPE;
279: l_tech_name ff_archive_items.value%TYPE;
280: l_tech_area ff_archive_items.value%TYPE;
281: l_tech_phno ff_archive_items.value%TYPE;
282: l_tech_email ff_archive_items.value%TYPE;
283: l_lang ff_archive_items.value%TYPE;
284: l_acc_name ff_archive_items.value%TYPE;
285: l_acc_area ff_archive_items.value%TYPE;

Line 282: l_tech_email ff_archive_items.value%TYPE;

278: l_trans_no ff_archive_items.value%TYPE;
279: l_tech_name ff_archive_items.value%TYPE;
280: l_tech_area ff_archive_items.value%TYPE;
281: l_tech_phno ff_archive_items.value%TYPE;
282: l_tech_email ff_archive_items.value%TYPE;
283: l_lang ff_archive_items.value%TYPE;
284: l_acc_name ff_archive_items.value%TYPE;
285: l_acc_area ff_archive_items.value%TYPE;
286: l_acc_phno ff_archive_items.value%TYPE;

Line 283: l_lang ff_archive_items.value%TYPE;

279: l_tech_name ff_archive_items.value%TYPE;
280: l_tech_area ff_archive_items.value%TYPE;
281: l_tech_phno ff_archive_items.value%TYPE;
282: l_tech_email ff_archive_items.value%TYPE;
283: l_lang ff_archive_items.value%TYPE;
284: l_acc_name ff_archive_items.value%TYPE;
285: l_acc_area ff_archive_items.value%TYPE;
286: l_acc_phno ff_archive_items.value%TYPE;
287: l_trans_bus_no ff_archive_items.value%TYPE;

Line 284: l_acc_name ff_archive_items.value%TYPE;

280: l_tech_area ff_archive_items.value%TYPE;
281: l_tech_phno ff_archive_items.value%TYPE;
282: l_tech_email ff_archive_items.value%TYPE;
283: l_lang ff_archive_items.value%TYPE;
284: l_acc_name ff_archive_items.value%TYPE;
285: l_acc_area ff_archive_items.value%TYPE;
286: l_acc_phno ff_archive_items.value%TYPE;
287: l_trans_bus_no ff_archive_items.value%TYPE;
288: l_bus_no ff_archive_items.value%TYPE;

Line 285: l_acc_area ff_archive_items.value%TYPE;

281: l_tech_phno ff_archive_items.value%TYPE;
282: l_tech_email ff_archive_items.value%TYPE;
283: l_lang ff_archive_items.value%TYPE;
284: l_acc_name ff_archive_items.value%TYPE;
285: l_acc_area ff_archive_items.value%TYPE;
286: l_acc_phno ff_archive_items.value%TYPE;
287: l_trans_bus_no ff_archive_items.value%TYPE;
288: l_bus_no ff_archive_items.value%TYPE;
289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

Line 286: l_acc_phno ff_archive_items.value%TYPE;

282: l_tech_email ff_archive_items.value%TYPE;
283: l_lang ff_archive_items.value%TYPE;
284: l_acc_name ff_archive_items.value%TYPE;
285: l_acc_area ff_archive_items.value%TYPE;
286: l_acc_phno ff_archive_items.value%TYPE;
287: l_trans_bus_no ff_archive_items.value%TYPE;
288: l_bus_no ff_archive_items.value%TYPE;
289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

Line 287: l_trans_bus_no ff_archive_items.value%TYPE;

283: l_lang ff_archive_items.value%TYPE;
284: l_acc_name ff_archive_items.value%TYPE;
285: l_acc_area ff_archive_items.value%TYPE;
286: l_acc_phno ff_archive_items.value%TYPE;
287: l_trans_bus_no ff_archive_items.value%TYPE;
288: l_bus_no ff_archive_items.value%TYPE;
289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;

Line 288: l_bus_no ff_archive_items.value%TYPE;

284: l_acc_name ff_archive_items.value%TYPE;
285: l_acc_area ff_archive_items.value%TYPE;
286: l_acc_phno ff_archive_items.value%TYPE;
287: l_trans_bus_no ff_archive_items.value%TYPE;
288: l_bus_no ff_archive_items.value%TYPE;
289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 294: l_trans_name ff_archive_items.value%TYPE;

290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
293: l_acc_info_flag CHAR(1);
294: l_trans_name ff_archive_items.value%TYPE;
295: l_gre_name ff_archive_items.value%TYPE;
296: l_bg_id pay_payroll_actions.business_group_id%TYPE;
297:
298: BEGIN

Line 295: l_gre_name ff_archive_items.value%TYPE;

291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
293: l_acc_info_flag CHAR(1);
294: l_trans_name ff_archive_items.value%TYPE;
295: l_gre_name ff_archive_items.value%TYPE;
296: l_bg_id pay_payroll_actions.business_group_id%TYPE;
297:
298: BEGIN
299: /* Fetching the Payroll Action Id for Trasnmitter GRE */

Line 463: FROM ff_archive_items fai,

459:
460: CURSOR cur_archive (b_context_id IN NUMBER,
461: b_user_name VARCHAR2) IS
462: SELECT fai.value
463: FROM ff_archive_items fai,
464: ff_database_items fdi
465: WHERE fai.user_entity_id = fdi.user_entity_id
466: AND fai.context1 = b_context_id
467: AND fdi.user_name = b_user_name;

Line 469: l_return ff_archive_items.value%TYPE;

465: WHERE fai.user_entity_id = fdi.user_entity_id
466: AND fai.context1 = b_context_id
467: AND fdi.user_name = b_user_name;
468:
469: l_return ff_archive_items.value%TYPE;
470:
471: BEGIN
472: OPEN cur_archive(p_context_id,p_user_name);
473: FETCH cur_archive INTO l_return;

Line 660: l_context1 ff_archive_items.context1%TYPE;

656: BEGIN
657: DECLARE
658:
659: l_final_xml VARCHAR2(32000);
660: l_context1 ff_archive_items.context1%TYPE;
661: EOL VARCHAR2(5) := fnd_global.local_chr(13)
662: || fnd_global.local_chr(10);
663: l_return ff_archive_items.value%TYPE;
664: l_status BOOLEAN := TRUE;

Line 663: l_return ff_archive_items.value%TYPE;

659: l_final_xml VARCHAR2(32000);
660: l_context1 ff_archive_items.context1%TYPE;
661: EOL VARCHAR2(5) := fnd_global.local_chr(13)
662: || fnd_global.local_chr(10);
663: l_return ff_archive_items.value%TYPE;
664: l_status BOOLEAN := TRUE;
665: l_field_name VARCHAR2(250);
666:
667: TYPE transmitter_info IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

Line 924: l_context1 ff_archive_items.context1%TYPE;

920: PROCEDURE t4_cancel_employer_record is
921: BEGIN
922: DECLARE
923: l_final_xml_string VARCHAR2(32000);
924: l_context1 ff_archive_items.context1%TYPE;
925: l_return ff_archive_items.value%TYPE;
926: EOL VARCHAR2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
927: l_transfer_pact_id VARCHAR2(15);
928: l_transfer_tax_unit_id VARCHAR2(15);

Line 925: l_return ff_archive_items.value%TYPE;

921: BEGIN
922: DECLARE
923: l_final_xml_string VARCHAR2(32000);
924: l_context1 ff_archive_items.context1%TYPE;
925: l_return ff_archive_items.value%TYPE;
926: EOL VARCHAR2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
927: l_transfer_pact_id VARCHAR2(15);
928: l_transfer_tax_unit_id VARCHAR2(15);
929: l_transfer_ei_er_rate VARCHAR2(15);

Line 1149: l_jurisdiction_code ff_archive_items.value%TYPE;

1145: transfer_ppip_max NUMBER :=0;
1146: lv_ei_display_flag NUMBER :=1;
1147: l_payroll_actid NUMBER;
1148: l_mag_asg_action_id NUMBER;
1149: l_jurisdiction_code ff_archive_items.value%TYPE;
1150: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1151: || fnd_global.local_chr(10);
1152: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1153: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

Line 1166: l_return ff_archive_items.value%TYPE;

1162: l_postal_code per_addresses.postal_code%TYPE;
1163: l_country VARCHAR2(60);
1164: l_emp_province per_addresses.region_1%TYPE;
1165:
1166: l_return ff_archive_items.value%TYPE;
1167: l_return1 ff_archive_items.value%TYPE;
1168: l_return2 ff_archive_items.value%TYPE;
1169: l_return_xml VARCHAR2(500);
1170: l_status BOOLEAN := TRUE;

Line 1167: l_return1 ff_archive_items.value%TYPE;

1163: l_country VARCHAR2(60);
1164: l_emp_province per_addresses.region_1%TYPE;
1165:
1166: l_return ff_archive_items.value%TYPE;
1167: l_return1 ff_archive_items.value%TYPE;
1168: l_return2 ff_archive_items.value%TYPE;
1169: l_return_xml VARCHAR2(500);
1170: l_status BOOLEAN := TRUE;
1171: l_name_status BOOLEAN := TRUE;

Line 1168: l_return2 ff_archive_items.value%TYPE;

1164: l_emp_province per_addresses.region_1%TYPE;
1165:
1166: l_return ff_archive_items.value%TYPE;
1167: l_return1 ff_archive_items.value%TYPE;
1168: l_return2 ff_archive_items.value%TYPE;
1169: l_return_xml VARCHAR2(500);
1170: l_status BOOLEAN := TRUE;
1171: l_name_status BOOLEAN := TRUE;
1172: l_error_message VARCHAR2(500);

Line 1257: ff_archive_items fai,

1253: CURSOR c_get_t4_ei_earn_display(p_aa_id IN NUMBER) IS
1254: SELECT
1255: count(1)
1256: FROM
1257: ff_archive_items fai,
1258: ff_database_items fdi
1259: WHERE fai.context1 = p_aa_id
1260: AND fai.user_entity_id = fdi.user_entity_id
1261: AND fdi.user_name='CAEOY_PROVINCE_OF_EMPLOYMENT';

Line 1298: ff_archive_items fai,

1294: CURSOR c_cancel_mag_jurisdictions(p_arch_action_id IN NUMBER) IS
1295: SELECT
1296: fai.value
1297: FROM
1298: ff_archive_items fai,
1299: ff_database_items fdi
1300: WHERE fai.context1 = p_arch_action_id
1301: AND fai.user_entity_id = fdi.user_entity_id
1302: AND fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';

Line 1308: ff_archive_items fai,

1304: CURSOR c_cancel_amend_jurisdictions(p_arch_action_id IN NUMBER) IS
1305: SELECT
1306: fac.context
1307: FROM
1308: ff_archive_items fai,
1309: ff_database_items fdi,
1310: ff_archive_item_contexts fac,
1311: ff_contexts ffc
1312: WHERE fai.context1 = p_arch_action_id