DBA Data[Home] [Help]

APPS.PAY_KR_NPA_PKG dependencies on PAY_ARCHIVE

Line 313: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';

309: if g_debug then
310: hr_utility.set_location(l_proc_name, 20);
311: end if;
312:
313: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
314: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
315: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';

Line 314: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);

310: hr_utility.set_location(l_proc_name, 20);
311: end if;
312:
313: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
314: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
315: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);

Line 315: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';

311: end if;
312:
313: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
314: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
315: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';

Line 316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);

312:
313: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
314: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
315: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);

Line 317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';

313: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
314: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
315: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';

Line 318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);

314: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
315: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);

Line 319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';

315: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';

Line 320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);

316: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);

Line 321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';

317: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';

Line 322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);

318: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172

Line 323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';

319: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172
327: pay_archive.g_context_values.sz := 7;

Line 324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);

320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172
327: pay_archive.g_context_values.sz := 7;
328:

Line 325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';

321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172
327: pay_archive.g_context_values.sz := 7;
328:
329: if g_debug then

Line 326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172

322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172
327: pay_archive.g_context_values.sz := 7;
328:
329: if g_debug then
330: hr_utility.set_location(l_proc_name, 30);

Line 327: pay_archive.g_context_values.sz := 7;

323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172
327: pay_archive.g_context_values.sz := 7;
328:
329: if g_debug then
330: hr_utility.set_location(l_proc_name, 30);
331: end if;