APPS.PAY_PATCH_STATUS_PKG dependencies on PAY_PATCH_STATUS

Line 1: package body pay_patch_status_pkg as

1: package body pay_patch_status_pkg as
2: /* $Header: pycoppst.pkb 120.0 2005/05/29 04:08 appldev noship $ */
3: --
4: /*
5: Name

Line 28: from pay_patch_status

24: begin
25: --
26: select id
27: into l_patch_id
28: from pay_patch_status
29: where patch_number = p_patch_number;
30: --
31: exception
32: when no_data_found then

Line 34: select pay_patch_status_s.nextval

30: --
31: exception
32: when no_data_found then
33: --
34: select pay_patch_status_s.nextval
35: into l_patch_id
36: from dual;
37: --
38: insert into pay_patch_status

Line 38: insert into pay_patch_status

34: select pay_patch_status_s.nextval
35: into l_patch_id
36: from dual;
37: --
38: insert into pay_patch_status
39: (ID,
40: PATCH_NUMBER,
41: PATCH_NAME,
42: PHASE,

Line 71: end pay_patch_status_pkg;

67: p_patch_id := l_patch_id;
68: --
69: end ins_patch_status;
70: --
71: end pay_patch_status_pkg;