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
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
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
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,
67: p_patch_id := l_patch_id;
68: --
69: end ins_patch_status;
70: --
71: end pay_patch_status_pkg;