DBA Data[Home] [Help]

APPS.PAY_CA_DD_MAGTAPE_PKG dependencies on PAY_MAG_TAPE

Line 31: g_payroll_action_id := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));

27:
28: Begin
29: /* hr_utility.trace_on('Y','TESTCADD'); */
30: p_formula_name := 'DUMMY_DD_FORMULA';
31: g_payroll_action_id := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));
32: --g_payroll_action_id := 7193;
33: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));
34: --
35: -- Select all the relevent information using payroll action id

Line 100: l_ff_formula_id := pay_mag_tape.internal_prm_values(2);

96: begin
97: hr_utility.trace('In not CIBC');
98: pay_magtape_generic.new_formula;
99:
100: l_ff_formula_id := pay_mag_tape.internal_prm_values(2);
101:
102: hr_utility.trace('Formula id is '||l_ff_formula_id);
103: if l_ff_formula_id <> '0'
104: then

Line 234: pay_mag_tape.internal_prm_values(1) := '2';

230: g_request_id,
231: l_success
232: );
233: /* l_ret := pay_xml_magtape_pkg.submit_xml_mag_jcp(7193,1425); */
234: pay_mag_tape.internal_prm_values(1) := '2';
235: pay_mag_tape.internal_prm_values(2) := p_ff_formula_id;
236:
237: if l_success then
238: hr_utility.trace('TRUE ' );

Line 235: pay_mag_tape.internal_prm_values(2) := p_ff_formula_id;

231: l_success
232: );
233: /* l_ret := pay_xml_magtape_pkg.submit_xml_mag_jcp(7193,1425); */
234: pay_mag_tape.internal_prm_values(1) := '2';
235: pay_mag_tape.internal_prm_values(2) := p_ff_formula_id;
236:
237: if l_success then
238: hr_utility.trace('TRUE ' );
239: else

Line 258: l_ff_formula_id := pay_mag_tape.internal_prm_values(2);

254:
255: if g_magtape_report_id in ('CIBC','NOVA_SCOT','TD','CPA') then
256: raise no_data_found;
257: else
258: l_ff_formula_id := pay_mag_tape.internal_prm_values(2);
259:
260: hr_utility.trace('Formula id is '||l_ff_formula_id);
261: begin
262: select formula_name

Line 287: pay_mag_tape.internal_prm_values(2) := p_ff_formula_id;

283: from FF_FORMULAS_F
284: where g_effective_date between EFFECTIVE_START_DATE and
285: EFFECTIVE_END_DATE
286: and FORMULA_NAME = p_formula_name;
287: pay_mag_tape.internal_prm_values(2) := p_ff_formula_id;
288: raise no_data_found;
289: end if;
290: end;
291: end if;