DBA Data[Home] [Help]

APPS.PAY_KR_HIA_PKG dependencies on PAY_ARCHIVE

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

398: fetch csr_last_year_asg_action into l_last_year_assignment_action;
399: close csr_last_year_asg_action;
400: -- End of bug 3438946
401: --
402: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
403: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
404: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
405: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';

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

399: close csr_last_year_asg_action;
400: -- End of bug 3438946
401: --
402: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
403: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
404: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
405: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
407: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);

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

400: -- End of bug 3438946
401: --
402: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
403: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
404: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
405: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
407: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
408: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';

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

401: --
402: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
403: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
404: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
405: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
407: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
408: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
409: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);

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

402: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
403: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
404: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
405: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
407: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
408: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
409: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
410: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';

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

403: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);
404: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
405: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
407: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
408: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
409: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
410: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
411: -- Bug 3438946

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

404: pay_archive.g_context_values.name(2) := 'PAYROLL_ID';
405: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
407: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
408: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
409: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
410: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
411: -- Bug 3438946
412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);

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

405: pay_archive.g_context_values.value(2) := to_char(l_payroll_id);
406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
407: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
408: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
409: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
410: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
411: -- Bug 3438946
412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);
413: --

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

406: pay_archive.g_context_values.name(3) := 'PAYROLL_ACTION_ID';
407: pay_archive.g_context_values.value(3) := to_char(g_pact.payroll_action_id);
408: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
409: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
410: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
411: -- Bug 3438946
412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);
413: --
414: pay_archive.g_context_values.name(6) := 'DATE_EARNED';

Line 412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);

408: pay_archive.g_context_values.name(4) := 'ASSIGNMENT_ID';
409: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
410: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
411: -- Bug 3438946
412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);
413: --
414: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
415: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
416: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';

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

410: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
411: -- Bug 3438946
412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);
413: --
414: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
415: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
416: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
417: pay_archive.g_context_values.value(7) := to_char(l_establishment_id); -- 3506171
418: pay_archive.g_context_values.sz := 7;

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

411: -- Bug 3438946
412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);
413: --
414: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
415: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
416: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
417: pay_archive.g_context_values.value(7) := to_char(l_establishment_id); -- 3506171
418: pay_archive.g_context_values.sz := 7;
419:

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

412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);
413: --
414: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
415: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
416: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
417: pay_archive.g_context_values.value(7) := to_char(l_establishment_id); -- 3506171
418: pay_archive.g_context_values.sz := 7;
419:
420: if g_debug then

Line 417: pay_archive.g_context_values.value(7) := to_char(l_establishment_id); -- 3506171

413: --
414: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
415: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
416: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
417: pay_archive.g_context_values.value(7) := to_char(l_establishment_id); -- 3506171
418: pay_archive.g_context_values.sz := 7;
419:
420: if g_debug then
421: hr_utility.set_location(l_proc_name, 30);

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

414: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
415: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
416: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
417: pay_archive.g_context_values.value(7) := to_char(l_establishment_id); -- 3506171
418: pay_archive.g_context_values.sz := 7;
419:
420: if g_debug then
421: hr_utility.set_location(l_proc_name, 30);
422: end if;