APPS.PAY_SE_ARCHIVE_TETA dependencies on PAY_SE_ARCHIVE_TETA

Line 1: PACKAGE BODY PAY_SE_ARCHIVE_TETA AS

1: PACKAGE BODY PAY_SE_ARCHIVE_TETA AS
2: /* $Header: pyseteta.pkb 120.0.12000000.1 2007/07/11 12:30:00 dbehera noship $ */
3:
4: TYPE lock_rec IS RECORD (
5: archive_assact_id NUMBER);

Line 14: g_package VARCHAR2(33) := ' PAY_SE_ARCHIVE_TETA.';

10: g_lock_table lock_table;
11: g_index NUMBER := -1;
12: g_index_assact NUMBER := -1;
13: g_index_bal NUMBER := -1;
14: g_package VARCHAR2(33) := ' PAY_SE_ARCHIVE_TETA.';
15: g_archive VARCHAR2(1);
16: g_effective_date DATE;
17: g_date_report DATE;
18: g_person_id NUMBER ;

Line 84: SELECT PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'PERSON_ID')

80: ,p_archive OUT NOCOPY VARCHAR2
81: ) IS
82:
83: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
84: SELECT PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'PERSON_ID')
85: ,fnd_date.canonical_to_date(PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'DATE_REPORT'))
86: ,PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,effective_date
88: ,business_group_id

Line 85: ,fnd_date.canonical_to_date(PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'DATE_REPORT'))

81: ) IS
82:
83: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
84: SELECT PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'PERSON_ID')
85: ,fnd_date.canonical_to_date(PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'DATE_REPORT'))
86: ,PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,effective_date
88: ,business_group_id
89: FROM pay_payroll_actions

Line 86: ,PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'ARCHIVE')

82:
83: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
84: SELECT PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'PERSON_ID')
85: ,fnd_date.canonical_to_date(PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'DATE_REPORT'))
86: ,PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,effective_date
88: ,business_group_id
89: FROM pay_payroll_actions
90: WHERE payroll_action_id = p_payroll_action_id;

Line 162: PAY_SE_ARCHIVE_TETA.GET_ALL_PARAMETERS(

158: g_payroll_action_id := p_payroll_action_id ;
159:
160: --fnd_file.put_line(fnd_file.log,'InsideRange Code');
161:
162: PAY_SE_ARCHIVE_TETA.GET_ALL_PARAMETERS(
163: p_payroll_action_id
164: ,g_business_group_id
165: ,g_person_id
166: ,g_date_report

Line 297: PAY_SE_ARCHIVE_TETA.GET_ALL_PARAMETERS(

293: END IF;
294:
295: --fnd_file.put_line(fnd_file.log,'Assignment Action Code');
296:
297: PAY_SE_ARCHIVE_TETA.GET_ALL_PARAMETERS(
298: p_payroll_action_id
299: ,g_business_group_id
300: ,g_person_id
301: ,g_date_report

Line 681: PAY_SE_ARCHIVE_TETA.GET_ALL_PARAMETERS(

677: IF g_debug THEN
678: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);
679: END IF;
680:
681: PAY_SE_ARCHIVE_TETA.GET_ALL_PARAMETERS(
682: p_payroll_action_id
683: ,g_business_group_id
684: ,g_person_id
685: ,g_date_report

Line 819: END PAY_SE_ARCHIVE_TETA;

815: g_effective_date := NULL ;
816: g_person_id := NULL ;
817: g_payroll_action_id := NULL ;
818:
819: END PAY_SE_ARCHIVE_TETA;