DBA Data[Home] [Help]

APPS.PAY_NZ_SOE_PKG dependencies on PAY_NZ_SOE_PKG

Line 1: package body pay_nz_soe_pkg as

1: package body pay_nz_soe_pkg as
2: /* $Header: pynzsoe.pkb 120.0.12000000.4 2007/06/04 11:54:56 dduvvuri noship $ */
3:
4: /*
5: **

Line 81: hr_utility.set_location('pay_nz_soe_pkg.get_tax_code', 10) ;

77: and ppa.effective_date between iv1.effective_start_date and iv1.effective_end_date;
78:
79: begin
80:
81: hr_utility.set_location('pay_nz_soe_pkg.get_tax_code', 10) ;
82:
83: open c_tax_code (p_run_assignment_action_id) ;
84: fetch c_tax_code into l_tax_code,l_special_tax_code ;
85: if c_tax_code%notfound

Line 98: hr_utility.set_location('pay_nz_soe_pkg.get_tax_code', 20) ;

94: l_tax_code := 'STC' ;
95: end if;
96: close c_tax_code ;
97:
98: hr_utility.set_location('pay_nz_soe_pkg.get_tax_code', 20) ;
99:
100: return l_tax_code ;
101:
102: exception

Line 105: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_tax_code') ;

101:
102: exception
103: when others then
104: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
105: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_tax_code') ;
106: hr_utility.set_message_token('STEP','body') ;
107: hr_utility.raise_error ;
108:
109: end get_tax_code ;

Line 137: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 10) ;

133: and pad.person_id = cp_person_id
134: and sysdate between nvl(pad.date_from, sysdate) and nvl(pad.date_to, sysdate);
135:
136: Begin
137: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 10) ;
138: open c_get_home_address(p_person_id);
139: fetch c_get_home_address into p_addr_line1,
140: p_addr_line2,
141: p_addr_line3,

Line 146: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 20) ;

142: p_town_city,
143: p_postal_code,
144: p_country_name;
145: close c_get_home_address;
146: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 20) ;
147:
148: Exception
149: when others then
150: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

Line 151: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_home_address') ;

147:
148: Exception
149: when others then
150: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
151: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_home_address') ;
152: hr_utility.set_message_token('STEP','body') ;
153: hr_utility.raise_error ;
154:
155: End;

Line 183: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 10) ;

179: and ftt.language = USERENV('LANG') -- Bug 3257888
180: and hrl.location_id = cp_location_id;
181:
182: Begin
183: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 10) ;
184: open c_get_work_address(p_location_id);
185: fetch c_get_work_address into p_addr_line1,
186: p_addr_line2,
187: p_addr_line3,

Line 192: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 20) ;

188: p_town_city,
189: p_postal_code,
190: p_country_name;
191: close c_get_work_address;
192: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 20) ;
193:
194: Exception
195: when others then
196: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

Line 197: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_work_address') ;

193:
194: Exception
195: when others then
196: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
197: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_work_address') ;
198: hr_utility.set_message_token('STEP','body') ;
199: hr_utility.raise_error ;
200:
201: End;

Line 701: pay_nz_soe_pkg.balance_totals(

697: fetch run_ids into cur_run_id;
698: exit when run_ids%NOTFOUND;
699: l_RUN_ASSIGNMENT_ACTION_ID := cur_run_id;
700: pre_pay:= 0;
701: pay_nz_soe_pkg.balance_totals(
702: p_assignment_id ,
703: l_RUN_ASSIGNMENT_ACTION_ID ,
704: p_effective_date ,
705: l_GROSS_INCOME_TP,

Line 730: pay_nz_soe_pkg.balance_totals(

726: p_non_tax_allow_ytd := l_NON_TAX_YTD;
727: p_pre_tax_deductions_ytd := l_PRE_TAX_DED_YTD;
728: close run_ids;
729: if Pre_pay <> 0 then
730: pay_nz_soe_pkg.balance_totals(
731: p_assignment_id ,
732: p_assignment_action_id ,
733: p_effective_date ,
734: p_gross_this_pay ,

Line 747: END pay_nz_soe_pkg ;

743: p_pre_tax_deductions_ytd );
744: end if;
745: end final_balance_totals;
746:
747: END pay_nz_soe_pkg ;