APPS.PAY_SG_CPFLINE dependencies on PAY_SG_CPFLINE

Line 1: package body pay_sg_cpfline as

1: package body pay_sg_cpfline as
2: /* $Header: pysgcpfl.pkb 120.6.12020000.3 2012/10/08 07:05:06 jalin ship $ */
3: g_debug boolean;
4: --
5: l_package VARCHAR2(100);

Line 135: l_package := ' pay_sg_cpfline.';

131: select pay_assignment_actions_s.nextval
132: from dual;
133: --
134: begin
135: l_package := ' pay_sg_cpfline.';
136: l_proc_name := l_package || 'assignment_action_code';
137: pay_sg_cpfline.initialization_code(p_payroll_action_id) ;
138: --
139: if g_debug then

Line 137: pay_sg_cpfline.initialization_code(p_payroll_action_id) ;

133: --
134: begin
135: l_package := ' pay_sg_cpfline.';
136: l_proc_name := l_package || 'assignment_action_code';
137: pay_sg_cpfline.initialization_code(p_payroll_action_id) ;
138: --
139: if g_debug then
140: hr_utility.set_location(l_proc_name || ' Start of assignment_action_code',30);
141: end if;

Line 183: l_package := ' pay_sg_cpfline.';

179: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
180: is
181:
182: begin
183: l_package := ' pay_sg_cpfline.';
184: l_proc_name := l_package || 'initialization_code';
185: g_debug := hr_utility.debug_enabled;
186: --
187: if g_debug then

Line 307: l_package := ' pay_sg_cpfline.';

303: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei2.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei2.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))
304: order by rppa.action_sequence desc;
305:
306: begin
307: l_package := ' pay_sg_cpfline.';
308: l_proc_name := l_package || 'archive_code';
309: l_1984_frozen_earnings := 0;
310:
311: ---------------------------------

Line 545: hr_utility.set_location('pay_sg_cpfline: Start of check_cpf_number',10);

541: l_year number;
542: begin
543:
544: if g_debug then
545: hr_utility.set_location('pay_sg_cpfline: Start of check_cpf_number',10);
546: end if;
547:
548: l_cpf_num_uen := substr(p_er_cpf_number,1,10);
549: l_cpf_num_pc := substr(p_er_cpf_number,11,3);

Line 628: hr_utility.set_location('pay_sg_cpfline: End of check_cpf_number',20);

624: end if;
625: end if;
626:
627: if g_debug then
628: hr_utility.set_location('pay_sg_cpfline: End of check_cpf_number',20);
629: end if;
630:
631: return l_return;
632: end check_cpf_number;

Line 670: end pay_sg_cpfline;

666: 'Voluntary CPF Withheld',
667: 'CPF Elig Comp 1984 Frozen Salary and Other Earnings') /*Bug 3501915 */
668: order by 2 ;
669:
670: end pay_sg_cpfline;