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.5.12020000.9 2013/02/27 07:11:32 abdash ship $ */
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.5.12020000.9 2013/02/27 07:11:32 abdash ship $ */
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 92: AND pa2.consolidation_set_id = PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'CONSOLIDATION_SET_ID')

88: WHERE pa1.payroll_action_id = p_payroll_action_id
89: AND pa2.payroll_id = p_payroll_id
90: -- and asg.payroll_id = p_payroll_id
91:
92: AND pa2.consolidation_set_id = PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'CONSOLIDATION_SET_ID')
93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),
94: fnd_date.date_to_canonical(to_date('01/01/1001','DD/MM/YYYY'))))
95: and pa1.effective_date
96: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments

Line 93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),

89: AND pa2.payroll_id = p_payroll_id
90: -- and asg.payroll_id = p_payroll_id
91:
92: AND pa2.consolidation_set_id = PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'CONSOLIDATION_SET_ID')
93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),
94: fnd_date.date_to_canonical(to_date('01/01/1001','DD/MM/YYYY'))))
95: and pa1.effective_date
96: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
97: AND act.payroll_action_id = pa2.payroll_action_id

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

160:
161: l_proc_name := l_package || 'assignment_action_code';
162: hr_utility.set_location(l_proc_name, 10);
163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);

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

161: l_proc_name := l_package || 'assignment_action_code';
162: hr_utility.set_location(l_proc_name, 10);
163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);

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

162: hr_utility.set_location(l_proc_name, 10);
163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);

Line 167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));

163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);
171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);

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

1461: l_record_length := 321;
1462:
1463: p_ah_seq_no := substr( p_line ,14,6);
1464: p_ah_ret_code := substr( p_line ,4,2);
1465: p_ret_code_rem := pay_no_payproc.get_lookup_meaning ('NO_RETURN_CODES',p_ah_ret_code);
1466:
1467:
1468: IF p_trans_code = 'BETFOR00' THEN
1469:

Line 1663: end PAY_NO_PAYPROC;

1659: RETURN l_output;
1660: END conv_spec_char;
1661:
1662: ------------------------------------------------------------------------
1663: end PAY_NO_PAYPROC;