APPS.PAY_BATCH_OBJECT_STATUS_PKG dependencies on PAY_BATCH_OBJECT_STATUS

Line 1: PACKAGE BODY pay_batch_object_status_pkg AS

1: PACKAGE BODY pay_batch_object_status_pkg AS
2: /* $Header: pybos.pkb 120.2 2006/09/27 17:44:31 thabara noship $ */
3:
4: --
5: -- ----------------------------------------------------------------------------

Line 20: pay_batch_object_status bos

16: is
17: select
18: bos.object_status
19: from
20: pay_batch_object_status bos
21: where
22: bos.object_type = p_object_type
23: and bos.object_id = p_object_id
24: ;

Line 25: l_object_status pay_batch_object_status.object_status%type;

21: where
22: bos.object_type = p_object_type
23: and bos.object_id = p_object_id
24: ;
25: l_object_status pay_batch_object_status.object_status%type;
26: begin
27: open csr_obj;
28: fetch csr_obj into l_object_status;
29: close csr_obj;

Line 46: l_object_status pay_batch_object_status.object_status%type;

42: ,p_object_id in number
43: ,p_default_status in varchar2 default null
44: ) return varchar2
45: is
46: l_object_status pay_batch_object_status.object_status%type;
47: begin
48: --
49: l_object_status := nvl(get_status(p_object_type, p_object_id)
50: ,p_default_status);

Line 76: pay_batch_object_status bos

72: select
73: bos.object_status
74: ,bos.payroll_action_id
75: from
76: pay_batch_object_status bos
77: where
78: bos.object_type = p_object_type
79: and bos.object_id = p_object_id
80: for update nowait

Line 158: l_object_status pay_batch_object_status.object_status%type;

154: ,p_object_status in varchar2 default null
155: ,p_default_status in varchar2 default null
156: )
157: is
158: l_object_status pay_batch_object_status.object_status%type;
159: begin
160: --
161: -- Lock the batch object.
162: --

Line 194: l_object_status pay_batch_object_status.object_status%type;

190: (p_object_type in varchar2
191: ,p_object_id in number
192: )
193: is
194: l_object_status pay_batch_object_status.object_status%type;
195: l_object_name hr_lookups.meaning%type;
196: begin
197: --
198: -- Lock the batch object.

Line 233: l_object_status pay_batch_object_status.object_status%type;

229: ,p_object_status in varchar2
230: ,p_payroll_action_id in number default null
231: )
232: is
233: l_object_status pay_batch_object_status.object_status%type;
234: begin
235: --
236: -- Note: In order to lock a batch object with a payroll action,
237: -- the same payroll_action_id has to be specified.

Line 255: update pay_batch_object_status

251:
252: --
253: -- Update the batch object status.
254: --
255: update pay_batch_object_status
256: set object_status = p_object_status
257: ,payroll_action_id = p_payroll_action_id
258: where
259: object_type = p_object_type

Line 266: insert into pay_batch_object_status

262: else
263: --
264: -- Insert a new row.
265: --
266: insert into pay_batch_object_status
267: (object_type
268: ,object_id
269: ,object_status
270: ,payroll_action_id

Line 292: l_object_status pay_batch_object_status.object_status%type;

288: ,p_object_id in number
289: ,p_payroll_action_id in number default null
290: )
291: is
292: l_object_status pay_batch_object_status.object_status%type;
293: begin
294: --
295: -- Lock the batch object.
296: --

Line 304: delete from pay_batch_object_status

300: ,p_payroll_action_id => p_payroll_action_id
301: ,p_object_status => l_object_status
302: );
303:
304: delete from pay_batch_object_status
305: where
306: object_type = p_object_type
307: and object_id = p_object_id;
308:

Line 313: end pay_batch_object_status_pkg;

309: end delete_object_status;
310: --
311: -------------------------------------------------------------------------------
312:
313: end pay_batch_object_status_pkg;