APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_US_PAYROLL_UTILS

Line 47: pay_us_payroll_utils.get_parameter instead.

43: function check_if_assignment_paid.
44: 3.Changed query for range_cursor for better
45: performance.
46: 4.Removed function get_parameter and used function
47: pay_us_payroll_utils.get_parameter instead.
48: 5.Added function get_payroll_action which returns
49: payroll_action data.
50: 04-AUG-2004 schauhan 115.3 3512116 Added assignment_set_id in the return list of
51: procedure get_payroll_action.

Line 68: pay_us_payroll_utils.get_parameter()

64: 06-JUN-2005 rsethupa 115.11 4406538 Changed cursor c_paid_actions in
65: archive_action_creation procedure to use the
66: exact names TRANSFER_CONSOLIDATION_SET_ID and
67: TRANSFER_PAYROLL_ID while calling
68: pay_us_payroll_utils.get_parameter()
69: 29-Sep-2005 sackumar 115.12 4631914 Modified the payroll_id join condition in c_paid_actions
70: query in action_creation procedure
71: 06-Oct-2005 sackumar 115.13 4636646 Modified the c_paid_actions cursor query in
72: action_creation procedure for Zero Pay assignment.

Line 137: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(

133: ld_deposit_start_date,
134: ld_deposit_end_date;
135: close c_get_payroll_action;
136:
137: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(
138: 'ASG_SET_ID',
139: lv_legislative_parameters);
140: ln_payroll_id := pay_us_payroll_utils.get_parameter(
141: 'PAYROLL_ID',

Line 140: ln_payroll_id := pay_us_payroll_utils.get_parameter(

136:
137: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(
138: 'ASG_SET_ID',
139: lv_legislative_parameters);
140: ln_payroll_id := pay_us_payroll_utils.get_parameter(
141: 'PAYROLL_ID',
142: lv_legislative_parameters);
143: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
144: 'CONSOLIDATION_SET_ID',

Line 143: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(

139: lv_legislative_parameters);
140: ln_payroll_id := pay_us_payroll_utils.get_parameter(
141: 'PAYROLL_ID',
142: lv_legislative_parameters);
143: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
144: 'CONSOLIDATION_SET_ID',
145: lv_legislative_parameters);
146:
147: p_deposit_start_date := ld_deposit_start_date;

Line 197: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(

193: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));
194:
195: close c_get_payroll_action;
196:
197: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(
198: 'ASSIGNMENT_SET_ID',
199: lv_legislative_parameters);
200: ln_payroll_id := pay_us_payroll_utils.get_parameter(
201: 'PAYROLL_ID',

Line 200: ln_payroll_id := pay_us_payroll_utils.get_parameter(

196:
197: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(
198: 'ASSIGNMENT_SET_ID',
199: lv_legislative_parameters);
200: ln_payroll_id := pay_us_payroll_utils.get_parameter(
201: 'PAYROLL_ID',
202: lv_legislative_parameters);
203: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
204: 'CONSOLIDATION_SET_ID',

Line 203: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(

199: lv_legislative_parameters);
200: ln_payroll_id := pay_us_payroll_utils.get_parameter(
201: 'PAYROLL_ID',
202: lv_legislative_parameters);
203: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
204: 'CONSOLIDATION_SET_ID',
205: lv_legislative_parameters);
206:
207: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);

Line 519: and pay_us_payroll_utils.get_parameter('TRANSFER_CONSOLIDATION_SET_ID',

515: and ppa_xfr.report_category = 'RT'
516: and ppa_xfr.report_qualifier = 'FED'
517: and cp_deposit_end_date between ppa_xfr.start_date
518: and ppa_xfr.effective_date
519: and pay_us_payroll_utils.get_parameter('TRANSFER_CONSOLIDATION_SET_ID',
520: ppa_xfr.legislative_parameters)
521: = cp_consolidation_set_id
522: and paa_xfr.payroll_action_id = ppa_xfr.payroll_action_id
523: -- the statement below will make sure only Pre Payment Archive Actions are picked up

Line 528: pay_us_payroll_utils.get_parameter('TRANSFER_PAYROLL_ID',

524: and substr(paa_xfr.serial_number,1,1) not in ('V', 'B')
525: and pai_pre.locking_Action_id = paa_xfr.assignment_action_id
526: and (cp_payroll_id is null
527: or
528: pay_us_payroll_utils.get_parameter('TRANSFER_PAYROLL_ID',
529: ppa_xfr.legislative_parameters)
530: = cp_payroll_id
531: )
532: and paa_xfr.assignment_id between cp_start_person and cp_end_person