DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_NO_PAYPROC

Line 1: PACKAGE BODY pay_no_payproc AS

1: PACKAGE BODY pay_no_payproc AS
2: /* $Header: pynopproc.pkb 120.1.12000000.2 2007/04/05 19:38:18 sugarg noship $ */
3:
4: -- Globals
5: l_package CONSTANT VARCHAR2(20):= 'PAY_NO_PAYPROC.';

Line 5: l_package CONSTANT VARCHAR2(20):= 'PAY_NO_PAYPROC.';

1: PACKAGE BODY pay_no_payproc AS
2: /* $Header: pynopproc.pkb 120.1.12000000.2 2007/04/05 19:38:18 sugarg noship $ */
3:
4: -- Globals
5: l_package CONSTANT VARCHAR2(20):= 'PAY_NO_PAYPROC.';
6:
7: /* name of the process , this name is used to do any custom validation, it defaults to NO_ACK */
8:
9: g_process CONSTANT VARCHAR2 (10) := 'NO_ACK' ;

Line 135: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter

131: , HR_ORGANIZATION_INFORMATION hoi1
132: , HR_ORGANIZATION_INFORMATION hoi2
133: WHERE o1.business_group_id = pa1.business_group_id
134: and hoi1.organization_id = o1.organization_id
135: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter
136: (pa1.payroll_action_id,'LEGAL_EMPLOYER'))
137: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
138: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
139: and hoi1.organization_id = hoi2.organization_id

Line 155: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));

151:
152: l_proc_name := l_package || 'assignment_action_code';
153: hr_utility.set_location(l_proc_name, 10);
154:
155: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
156: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
157: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
158:
159: hr_utility.set_location(l_proc_name, 20);

Line 156: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));

152: l_proc_name := l_package || 'assignment_action_code';
153: hr_utility.set_location(l_proc_name, 10);
154:
155: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
156: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
157: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
158:
159: hr_utility.set_location(l_proc_name, 20);
160:

Line 157: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));

153: hr_utility.set_location(l_proc_name, 10);
154:
155: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
156: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
157: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
158:
159: hr_utility.set_location(l_proc_name, 20);
160:
161: FOR rec_asg IN csr_asg(p_payroll_action_id

Line 1431: p_ret_code_rem := pay_no_payproc.get_lookup_meaning ('NO_RETURN_CODES',p_ah_ret_code);

1427: l_record_length := 321;
1428:
1429: p_ah_seq_no := substr( p_line ,14,6);
1430: p_ah_ret_code := substr( p_line ,4,2);
1431: p_ret_code_rem := pay_no_payproc.get_lookup_meaning ('NO_RETURN_CODES',p_ah_ret_code);
1432:
1433:
1434: IF p_trans_code = 'BETFOR00' THEN
1435:

Line 1553: end PAY_NO_PAYPROC;

1549: ---------------------------------------------------------------------------------------------------------------
1550:
1551:
1552: ------------------------------------------------------------------------
1553: end PAY_NO_PAYPROC;