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';
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);
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';
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);
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';
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
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);
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: --
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';
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';
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;
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:
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
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);
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;