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

Line 32: FROM ff_archive_items fai1,

28: FROM ff_database_items
29: WHERE user_name='CAEOY_PERSON_ID';
30: --
31: p_sqlstr := 'SELECT DISTINCT to_number(fai1.value)
32: FROM ff_archive_items fai1,
33: ff_archive_items fai2,
34: pay_assignment_actions paa,
35: pay_payroll_actions ppa,
36: pay_payroll_actions ppa1

Line 33: ff_archive_items fai2,

29: WHERE user_name='CAEOY_PERSON_ID';
30: --
31: p_sqlstr := 'SELECT DISTINCT to_number(fai1.value)
32: FROM ff_archive_items fai1,
33: ff_archive_items fai2,
34: pay_assignment_actions paa,
35: pay_payroll_actions ppa,
36: pay_payroll_actions ppa1
37: WHERE ppa1.payroll_action_id = :p_pactid

Line 159: FROM ff_archive_items

155: -----
156: CURSOR c_get_fed_amend_flag(cp_asg_act_id IN NUMBER
157: ,cp_uid_t4amend_flag IN NUMBER) IS
158: SELECT value
159: FROM ff_archive_items
160: WHERE context1 = cp_asg_act_id
161: AND user_entity_id = cp_uid_t4amend_flag;
162: -----
163: CURSOR c_get_ue_id(cp_user_name IN VARCHAR2) IS

Line 184: lv_fed_amend_flag ff_archive_items.value%TYPE;

180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
182: lv_report_type pay_payroll_actions.report_type%TYPE ;
183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
184: lv_fed_amend_flag ff_archive_items.value%TYPE;
185: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
186: lv_flag_count NUMBER := 0;
187: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
188:

Line 350: l_trans_no ff_archive_items.value%TYPE;

346: l_trans_gre hr_all_organization_units.organization_id%TYPE;
347: l_year VARCHAR2(10);
348: l_gre hr_all_organization_units.organization_id%TYPE;
349: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
350: l_trans_no ff_archive_items.value%TYPE;
351: l_tech_name ff_archive_items.value%TYPE;
352: l_tech_area ff_archive_items.value%TYPE;
353: l_tech_phno ff_archive_items.value%TYPE;
354: l_tech_email ff_archive_items.value%TYPE;

Line 351: l_tech_name ff_archive_items.value%TYPE;

347: l_year VARCHAR2(10);
348: l_gre hr_all_organization_units.organization_id%TYPE;
349: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
350: l_trans_no ff_archive_items.value%TYPE;
351: l_tech_name ff_archive_items.value%TYPE;
352: l_tech_area ff_archive_items.value%TYPE;
353: l_tech_phno ff_archive_items.value%TYPE;
354: l_tech_email ff_archive_items.value%TYPE;
355: l_lang ff_archive_items.value%TYPE;

Line 352: l_tech_area ff_archive_items.value%TYPE;

348: l_gre hr_all_organization_units.organization_id%TYPE;
349: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
350: l_trans_no ff_archive_items.value%TYPE;
351: l_tech_name ff_archive_items.value%TYPE;
352: l_tech_area ff_archive_items.value%TYPE;
353: l_tech_phno ff_archive_items.value%TYPE;
354: l_tech_email ff_archive_items.value%TYPE;
355: l_lang ff_archive_items.value%TYPE;
356: l_acc_name ff_archive_items.value%TYPE;

Line 353: l_tech_phno ff_archive_items.value%TYPE;

349: l_bus_grp hr_all_organization_units.business_group_id%TYPE;
350: l_trans_no ff_archive_items.value%TYPE;
351: l_tech_name ff_archive_items.value%TYPE;
352: l_tech_area ff_archive_items.value%TYPE;
353: l_tech_phno ff_archive_items.value%TYPE;
354: l_tech_email ff_archive_items.value%TYPE;
355: l_lang ff_archive_items.value%TYPE;
356: l_acc_name ff_archive_items.value%TYPE;
357: l_acc_area ff_archive_items.value%TYPE;

Line 354: l_tech_email ff_archive_items.value%TYPE;

350: l_trans_no ff_archive_items.value%TYPE;
351: l_tech_name ff_archive_items.value%TYPE;
352: l_tech_area ff_archive_items.value%TYPE;
353: l_tech_phno ff_archive_items.value%TYPE;
354: l_tech_email ff_archive_items.value%TYPE;
355: l_lang ff_archive_items.value%TYPE;
356: l_acc_name ff_archive_items.value%TYPE;
357: l_acc_area ff_archive_items.value%TYPE;
358: l_acc_phno ff_archive_items.value%TYPE;

Line 355: l_lang ff_archive_items.value%TYPE;

351: l_tech_name ff_archive_items.value%TYPE;
352: l_tech_area ff_archive_items.value%TYPE;
353: l_tech_phno ff_archive_items.value%TYPE;
354: l_tech_email ff_archive_items.value%TYPE;
355: l_lang ff_archive_items.value%TYPE;
356: l_acc_name ff_archive_items.value%TYPE;
357: l_acc_area ff_archive_items.value%TYPE;
358: l_acc_phno ff_archive_items.value%TYPE;
359: l_trans_bus_no ff_archive_items.value%TYPE;

Line 356: l_acc_name ff_archive_items.value%TYPE;

352: l_tech_area ff_archive_items.value%TYPE;
353: l_tech_phno ff_archive_items.value%TYPE;
354: l_tech_email ff_archive_items.value%TYPE;
355: l_lang ff_archive_items.value%TYPE;
356: l_acc_name ff_archive_items.value%TYPE;
357: l_acc_area ff_archive_items.value%TYPE;
358: l_acc_phno ff_archive_items.value%TYPE;
359: l_trans_bus_no ff_archive_items.value%TYPE;
360: l_bus_no ff_archive_items.value%TYPE;

Line 357: l_acc_area ff_archive_items.value%TYPE;

353: l_tech_phno ff_archive_items.value%TYPE;
354: l_tech_email ff_archive_items.value%TYPE;
355: l_lang ff_archive_items.value%TYPE;
356: l_acc_name ff_archive_items.value%TYPE;
357: l_acc_area ff_archive_items.value%TYPE;
358: l_acc_phno ff_archive_items.value%TYPE;
359: l_trans_bus_no ff_archive_items.value%TYPE;
360: l_bus_no ff_archive_items.value%TYPE;
361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

Line 358: l_acc_phno ff_archive_items.value%TYPE;

354: l_tech_email ff_archive_items.value%TYPE;
355: l_lang ff_archive_items.value%TYPE;
356: l_acc_name ff_archive_items.value%TYPE;
357: l_acc_area ff_archive_items.value%TYPE;
358: l_acc_phno ff_archive_items.value%TYPE;
359: l_trans_bus_no ff_archive_items.value%TYPE;
360: l_bus_no ff_archive_items.value%TYPE;
361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

Line 359: l_trans_bus_no ff_archive_items.value%TYPE;

355: l_lang ff_archive_items.value%TYPE;
356: l_acc_name ff_archive_items.value%TYPE;
357: l_acc_area ff_archive_items.value%TYPE;
358: l_acc_phno ff_archive_items.value%TYPE;
359: l_trans_bus_no ff_archive_items.value%TYPE;
360: l_bus_no ff_archive_items.value%TYPE;
361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;

Line 360: l_bus_no ff_archive_items.value%TYPE;

356: l_acc_name ff_archive_items.value%TYPE;
357: l_acc_area ff_archive_items.value%TYPE;
358: l_acc_phno ff_archive_items.value%TYPE;
359: l_trans_bus_no ff_archive_items.value%TYPE;
360: l_bus_no ff_archive_items.value%TYPE;
361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 366: l_trans_name ff_archive_items.value%TYPE;

362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
365: l_acc_info_flag CHAR(1);
366: l_trans_name ff_archive_items.value%TYPE;
367: l_gre_name ff_archive_items.value%TYPE;
368: l_bg_id pay_payroll_actions.business_group_id%TYPE;
369:
370: BEGIN

Line 367: l_gre_name ff_archive_items.value%TYPE;

363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
365: l_acc_info_flag CHAR(1);
366: l_trans_name ff_archive_items.value%TYPE;
367: l_gre_name ff_archive_items.value%TYPE;
368: l_bg_id pay_payroll_actions.business_group_id%TYPE;
369:
370: BEGIN
371: /* Fetching the Payroll Action Id for Trasnmitter GRE */

Line 535: FROM ff_archive_items fai,

531:
532: CURSOR cur_archive (b_context_id IN NUMBER,
533: b_user_name VARCHAR2) IS
534: SELECT fai.value
535: FROM ff_archive_items fai,
536: ff_database_items fdi
537: WHERE fai.user_entity_id = fdi.user_entity_id
538: AND fai.context1 = b_context_id
539: AND fdi.user_name = b_user_name;

Line 541: l_return ff_archive_items.value%TYPE;

537: WHERE fai.user_entity_id = fdi.user_entity_id
538: AND fai.context1 = b_context_id
539: AND fdi.user_name = b_user_name;
540:
541: l_return ff_archive_items.value%TYPE;
542:
543: BEGIN
544: OPEN cur_archive(p_context_id,p_user_name);
545: FETCH cur_archive INTO l_return;

Line 732: l_context1 ff_archive_items.context1%TYPE;

728: BEGIN
729: DECLARE
730:
731: l_final_xml VARCHAR2(32000);
732: l_context1 ff_archive_items.context1%TYPE;
733: EOL VARCHAR2(5) := fnd_global.local_chr(13)
734: || fnd_global.local_chr(10);
735: l_return ff_archive_items.value%TYPE;
736: l_status BOOLEAN := TRUE;

Line 735: l_return ff_archive_items.value%TYPE;

731: l_final_xml VARCHAR2(32000);
732: l_context1 ff_archive_items.context1%TYPE;
733: EOL VARCHAR2(5) := fnd_global.local_chr(13)
734: || fnd_global.local_chr(10);
735: l_return ff_archive_items.value%TYPE;
736: l_status BOOLEAN := TRUE;
737: l_field_name VARCHAR2(50);
738:
739: TYPE transmitter_info IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

Line 979: l_context1 ff_archive_items.context1%TYPE;

975: PROCEDURE t4_amend_employer_record is
976: BEGIN
977: DECLARE
978: l_final_xml_string VARCHAR2(32000);
979: l_context1 ff_archive_items.context1%TYPE;
980: l_return ff_archive_items.value%TYPE;
981: EOL VARCHAR2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
982: l_transfer_pact_id VARCHAR2(15);
983: l_transfer_tax_unit_id VARCHAR2(15);

Line 980: l_return ff_archive_items.value%TYPE;

976: BEGIN
977: DECLARE
978: l_final_xml_string VARCHAR2(32000);
979: l_context1 ff_archive_items.context1%TYPE;
980: l_return ff_archive_items.value%TYPE;
981: EOL VARCHAR2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
982: l_transfer_pact_id VARCHAR2(15);
983: l_transfer_tax_unit_id VARCHAR2(15);
984: l_transfer_ei_er_rate VARCHAR2(15);

Line 1204: l_jurisdiction_code ff_archive_items.value%TYPE;

1200: transfer_ppip_max NUMBER :=0;
1201: lv_ei_display_flag NUMBER :=1;
1202: l_payroll_actid NUMBER;
1203: l_mag_asg_action_id NUMBER;
1204: l_jurisdiction_code ff_archive_items.value%TYPE;
1205: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1206: || fnd_global.local_chr(10);
1207: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1208: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

Line 1220: l_return ff_archive_items.value%TYPE;

1216: l_postal_code per_addresses.postal_code%TYPE;
1217: l_country VARCHAR2(60);
1218: l_emp_province per_addresses.region_1%TYPE;
1219:
1220: l_return ff_archive_items.value%TYPE;
1221: l_return1 ff_archive_items.value%TYPE;
1222: l_return2 ff_archive_items.value%TYPE;
1223: l_return_xml VARCHAR2(500);
1224: l_status BOOLEAN := TRUE;

Line 1221: l_return1 ff_archive_items.value%TYPE;

1217: l_country VARCHAR2(60);
1218: l_emp_province per_addresses.region_1%TYPE;
1219:
1220: l_return ff_archive_items.value%TYPE;
1221: l_return1 ff_archive_items.value%TYPE;
1222: l_return2 ff_archive_items.value%TYPE;
1223: l_return_xml VARCHAR2(500);
1224: l_status BOOLEAN := TRUE;
1225: l_name_status BOOLEAN := TRUE;

Line 1222: l_return2 ff_archive_items.value%TYPE;

1218: l_emp_province per_addresses.region_1%TYPE;
1219:
1220: l_return ff_archive_items.value%TYPE;
1221: l_return1 ff_archive_items.value%TYPE;
1222: l_return2 ff_archive_items.value%TYPE;
1223: l_return_xml VARCHAR2(500);
1224: l_status BOOLEAN := TRUE;
1225: l_name_status BOOLEAN := TRUE;
1226: l_error_message VARCHAR2(500);

Line 1309: ff_archive_items fai,

1305: CURSOR c_get_t4_ei_earn_display(p_aa_id IN NUMBER) IS
1306: SELECT
1307: count(1)
1308: FROM
1309: ff_archive_items fai,
1310: ff_database_items fdi
1311: WHERE fai.context1 = p_aa_id
1312: AND fai.user_entity_id = fdi.user_entity_id
1313: AND fdi.user_name='CAEOY_PROVINCE_OF_EMPLOYMENT';

Line 1341: ff_archive_items fai,

1337: CURSOR c_get_amended_jurisdictions(p_arch_action_id IN NUMBER) IS
1338: SELECT
1339: fac.context
1340: FROM
1341: ff_archive_items fai,
1342: ff_database_items fdi,
1343: ff_archive_item_contexts fac,
1344: ff_contexts ffc
1345: WHERE fai.context1 = p_arch_action_id