APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on PAY_NO_ARC_HOLIDAY_ENTITLEMENT

Line 1: PACKAGE BODY PAY_NO_ARC_HOLIDAY_ENTITLEMENT as

1: PACKAGE BODY PAY_NO_ARC_HOLIDAY_ENTITLEMENT as
2: /* $Header: pynohlea.pkb 120.0.12000000.1 2007/05/22 07:29:44 rajesrin noship $ */
3: TYPE lock_rec IS RECORD (
4: archive_assact_id NUMBER);
5: TYPE lock_table IS TABLE OF lock_rec INDEX BY BINARY_INTEGER;

Line 8: g_package VARCHAR2(33) := ' PAY_NO_ARC_HOLIDAY_ENTITLEMENT.';

4: archive_assact_id NUMBER);
5: TYPE lock_table IS TABLE OF lock_rec INDEX BY BINARY_INTEGER;
6: g_debug boolean := hr_utility.debug_enabled;
7: g_lock_table lock_table;
8: g_package VARCHAR2(33) := ' PAY_NO_ARC_HOLIDAY_ENTITLEMENT.';
9: g_business_group_id NUMBER;
10: g_legal_employer_id NUMBER;
11: g_effective_date DATE;
12: g_employee_id NUMBER;

Line 70: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,

66: ,p_archive OUT NOCOPY VARCHAR2
67: ,p_effective_date OUT NOCOPY DATE
68: ) IS
69: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
70: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,
71: 'LEGAL_EMPLOYER')
72: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')
73: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')
74: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ASSIGNMENTSETID')

Line 72: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')

68: ) IS
69: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
70: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,
71: 'LEGAL_EMPLOYER')
72: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')
73: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')
74: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ASSIGNMENTSETID')
75: ,effective_date
76: ,business_group_id

Line 73: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')

69: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
70: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,
71: 'LEGAL_EMPLOYER')
72: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')
73: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')
74: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ASSIGNMENTSETID')
75: ,effective_date
76: ,business_group_id
77: FROM pay_payroll_actions

Line 74: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ASSIGNMENTSETID')

70: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,
71: 'LEGAL_EMPLOYER')
72: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')
73: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')
74: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ASSIGNMENTSETID')
75: ,effective_date
76: ,business_group_id
77: FROM pay_payroll_actions
78: WHERE payroll_action_id = p_payroll_action_id;

Line 116: PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_ALL_PARAMETERS( p_payroll_action_id

112: END IF;
113:
114:
115:
116: PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_ALL_PARAMETERS( p_payroll_action_id
117: ,g_business_group_id
118: ,g_legal_employer_id
119: ,g_assignment_set_id
120: ,g_employee_id

Line 163: /* ASSIGNMENT ACTION CODE PAY_NO_ARC_HOLIDAY_ENTITLEMENT.ASSIGNMENT_ACTION_CODE */

159: -- Return cursor that selects no rows
160: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
161: END RANGE_CODE;
162:
163: /* ASSIGNMENT ACTION CODE PAY_NO_ARC_HOLIDAY_ENTITLEMENT.ASSIGNMENT_ACTION_CODE */
164:
165: PROCEDURE ASSIGNMENT_ACTION_CODE
166: (p_payroll_action_id IN NUMBER
167: ,p_start_person IN NUMBER

Line 220: PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_ALL_PARAMETERS( p_payroll_action_id

216:
217:
218: hr_utility.trace('Entering Assignment Action Code '||p_payroll_action_id);
219:
220: PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_ALL_PARAMETERS( p_payroll_action_id
221: ,g_business_group_id
222: ,g_legal_employer_id
223: ,g_assignment_set_id
224: ,g_employee_id

Line 494: END PAY_NO_ARC_HOLIDAY_ENTITLEMENT;

490: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
491: END IF;
492: fnd_file.put_line (fnd_file.LOG, 'Exiting archive code' );
493: END ARCHIVE_CODE;
494: END PAY_NO_ARC_HOLIDAY_ENTITLEMENT;