APPS.PAY_WCI_OCCUPATIONS_API dependencies on PAY_WCI_OCCUPATIONS

Line 1: Package Body pay_wci_occupations_api as

1: Package Body pay_wci_occupations_api as
2: /* $Header: pypwoapi.pkb 115.2 2002/12/05 14:58:06 swinton noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'pay_wci_occupations_api';

2: /* $Header: pypwoapi.pkb 115.2 2002/12/05 14:58:06 swinton noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'pay_wci_occupations_api';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_wci_occupation >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 55: pay_wci_occupations_bk1.create_wci_occupation_b

51: --
52: -- Call Before Process User Hook
53: --
54: begin
55: pay_wci_occupations_bk1.create_wci_occupation_b
56: (p_effective_date => l_effective_date
57: ,p_object_version_number => p_object_version_number
58: ,p_business_group_id => l_business_group_id
59: ,p_rate_id => p_rate_id

Line 94: pay_wci_occupations_bk1.create_wci_occupation_a

90: --
91: -- Call After Process User Hook
92: --
93: begin
94: pay_wci_occupations_bk1.create_wci_occupation_a
95: (p_effective_date => l_effective_date
96: ,p_occupation_id => p_occupation_id
97: ,p_object_version_number => p_object_version_number
98: ,p_business_group_id => l_business_group_id

Line 177: from pay_wci_occupations

173: l_object_version_number number;
174: --
175: cursor csr_record_details is
176: select business_group_id,rate_id
177: from pay_wci_occupations
178: where occupation_id = p_occupation_id;
179:
180: begin
181:

Line 206: pay_wci_occupations_bk2.update_wci_occupation_b

202: --
203: -- Call Before Process User Hook
204: --
205: begin
206: pay_wci_occupations_bk2.update_wci_occupation_b
207: (p_effective_date => l_effective_date
208: ,p_occupation_id => p_occupation_id
209: ,p_object_version_number => p_object_version_number
210: ,p_business_group_id => l_business_group_id

Line 244: pay_wci_occupations_bk2.update_wci_occupation_a

240: --
241: -- Call After Process User Hook
242: --
243: begin
244: pay_wci_occupations_bk2.update_wci_occupation_a
245: (p_effective_date => l_effective_date
246: ,p_occupation_id => p_occupation_id
247: ,p_object_version_number => p_object_version_number
248: ,p_business_group_id => l_business_group_id

Line 320: from pay_wci_occupations

316: l_business_group_id number;
317: --
318: cursor csr_business_group_id is
319: select business_group_id
320: from pay_wci_occupations
321: where occupation_id = p_occupation_id;
322:
323: begin
324:

Line 343: pay_wci_occupations_bk3.delete_wci_occupation_b

339: --
340: -- Call Before Process User Hook
341: --
342: begin
343: pay_wci_occupations_bk3.delete_wci_occupation_b
344: (p_occupation_id => p_occupation_id
345: ,p_object_version_number => p_object_version_number
346: ,p_business_group_id => l_business_group_id
347: );

Line 375: pay_wci_occupations_bk3.delete_wci_occupation_a

371: --
372: -- Call After Process User Hook
373: --
374: begin
375: pay_wci_occupations_bk3.delete_wci_occupation_a
376: (p_occupation_id => p_occupation_id
377: ,p_object_version_number => p_object_version_number
378: ,p_business_group_id => l_business_group_id
379: );

Line 423: end pay_wci_occupations_api;

419: raise;
420:
421: end delete_wci_occupation;
422: --
423: end pay_wci_occupations_api;