416: IS
417: --
418: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
419: IS
420: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',legislative_parameters)) payroll_action_id
421: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',legislative_parameters)) assignment_set_id
422: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
423: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
417: --
418: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
419: IS
420: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',legislative_parameters)) payroll_action_id
421: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',legislative_parameters)) assignment_set_id
422: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
423: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
418: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
419: IS
420: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',legislative_parameters)) payroll_action_id
421: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',legislative_parameters)) assignment_set_id
422: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
423: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
419: IS
420: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',legislative_parameters)) payroll_action_id
421: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',legislative_parameters)) assignment_set_id
422: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
423: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
420: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',legislative_parameters)) payroll_action_id
421: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',legislative_parameters)) assignment_set_id
422: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
423: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
421: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',legislative_parameters)) assignment_set_id
422: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
423: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
422: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
423: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
423: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
431: ,pay_core_utils.get_parameter('S1',legislative_parameters) sort_order_1
424: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
431: ,pay_core_utils.get_parameter('S1',legislative_parameters) sort_order_1
432: ,pay_core_utils.get_parameter('S2',legislative_parameters) sort_order_2
425: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
431: ,pay_core_utils.get_parameter('S1',legislative_parameters) sort_order_1
432: ,pay_core_utils.get_parameter('S2',legislative_parameters) sort_order_2
433: ,pay_core_utils.get_parameter('S3',legislative_parameters) sort_order_3
426: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
431: ,pay_core_utils.get_parameter('S1',legislative_parameters) sort_order_1
432: ,pay_core_utils.get_parameter('S2',legislative_parameters) sort_order_2
433: ,pay_core_utils.get_parameter('S3',legislative_parameters) sort_order_3
434: FROM pay_payroll_actions PPA
427: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
431: ,pay_core_utils.get_parameter('S1',legislative_parameters) sort_order_1
432: ,pay_core_utils.get_parameter('S2',legislative_parameters) sort_order_2
433: ,pay_core_utils.get_parameter('S3',legislative_parameters) sort_order_3
434: FROM pay_payroll_actions PPA
435: WHERE PPA.payroll_action_id = p_payroll_action_id;
428: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_date_from
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
431: ,pay_core_utils.get_parameter('S1',legislative_parameters) sort_order_1
432: ,pay_core_utils.get_parameter('S2',legislative_parameters) sort_order_2
433: ,pay_core_utils.get_parameter('S3',legislative_parameters) sort_order_3
434: FROM pay_payroll_actions PPA
435: WHERE PPA.payroll_action_id = p_payroll_action_id;
436: --
429: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
431: ,pay_core_utils.get_parameter('S1',legislative_parameters) sort_order_1
432: ,pay_core_utils.get_parameter('S2',legislative_parameters) sort_order_2
433: ,pay_core_utils.get_parameter('S3',legislative_parameters) sort_order_3
434: FROM pay_payroll_actions PPA
435: WHERE PPA.payroll_action_id = p_payroll_action_id;
436: --
437: -- Local Variables
449: OPEN lcr_params(p_payroll_action_id);
450: FETCH lcr_params into gr_parameters;
451: CLOSE lcr_params;
452:
453: SELECT TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD')
454: INTO gr_parameters.effective_date
455: FROM pay_payroll_actions PPA
456: WHERE PPA.payroll_action_id = gr_parameters.payroll_action_id;
457:
962: INTO lc_legislative_parameters
963: FROM pay_payroll_actions
964: WHERE payroll_action_id = p_payroll_action_id;
965: --
966: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',lc_legislative_parameters));
967: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',lc_legislative_parameters));
968: --
969: g_mag_payroll_action_id := p_payroll_action_id;
970: --
963: FROM pay_payroll_actions
964: WHERE payroll_action_id = p_payroll_action_id;
965: --
966: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',lc_legislative_parameters));
967: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',lc_legislative_parameters));
968: --
969: g_mag_payroll_action_id := p_payroll_action_id;
970: --
971: IF gb_debug THEN
1978: INTO lc_legislative_parameters
1979: FROM pay_payroll_actions
1980: WHERE payroll_action_id = ln_cur_pact;
1981: --
1982: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',lc_legislative_parameters));
1983: --
1984: SELECT PAA1.assignment_action_id
1985: INTO ln_old_assact_id
1986: FROM pay_assignment_actions PAA