APPS.PAY_MAG_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 405: FROM pay_payroll_actions ppa

401: p_state in VARCHAR2 ) IS
402: --
403: CURSOR csr_payroll_action IS
404: SELECT payroll_action_id
405: FROM pay_payroll_actions ppa
406: WHERE ppa.business_group_id = p_business_group_id
407: AND ppa.effective_date = p_period_end
408: AND ppa.legislative_parameters like
409: 'USMAGTAPE'|| '-' ||

Line 456: UPDATE pay_payroll_actions pa

452: -- Set the payroll action status to Error if report has failed.
453: --
454: hr_utility.set_location('pay_mag_utils.error_payroll_action',1);
455: --
456: UPDATE pay_payroll_actions pa
457: SET pa.action_status = 'E'
458: WHERE pa.payroll_action_id = p_payroll_action_id;
459: --
460: COMMIT;

Line 490: UPDATE pay_payroll_actions pa

486: -- Sets the payroll action to a status of 'C'omplete.
487: --
488: hr_utility.set_location('pay_mag_utils.update_action_status',1);
489: --
490: UPDATE pay_payroll_actions pa
491: SET pa.action_status = 'C'
492: WHERE pa.payroll_action_id = p_payroll_action_id;
493: --
494: -- Sets all successfully processed assignment actions to 'C'omplete.

Line 531: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

527: p_period_end IN DATE,
528: p_param_text IN VARCHAR2
529: DEFAULT NULL ) RETURN NUMBER IS
530: --
531: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
532: --
533:
534: l_legislative_parms VARCHAR2(240);
535: BEGIN

Line 541: select pay_payroll_actions_s.nextval

537: -- Get the next payroll_action_id value from the sequence.
538: --
539: hr_utility.set_location('pay_mag_utils.create_payroll_action',1);
540: --
541: select pay_payroll_actions_s.nextval
542: into l_payroll_action_id
543: from sys.dual;
544: --
545: -- Create a payroll action dated as of the end of the period being reported

Line 563: INSERT INTO pay_payroll_actions

559: lpad(p_trans_legal_co_id, 5);
560: end if;
561: --
562: --
563: INSERT INTO pay_payroll_actions
564: (payroll_action_id,
565: action_type,
566: business_group_id,
567: action_population_status,