PACKAGE: APPS.PO_CLM_OKC_INTEG_PKG

Source

1 PACKAGE PO_CLM_OKC_INTEG_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_CLM_OKC_INTEG_PKG.pls 120.0.12020000.3 2013/02/26 07:38:54 mabaig noship $ */
3 
4 
5 -----------------------------------------------------------------------
6 --Start of Comments
7 --Name: insert_exhibits
8 --Pre-reqs: None
9 --Modifies:
10 --Locks:
11 --  None
12 --Function:
13 --  Inserts the given exhibits for the given document if it does not exists for that document
14 --Parameters:
15 --IN:
16 --  p_document_type_tbl IN PO_TBL_VARCHAR30;
17 --  p_document_id_tbl   IN PO_TBL_NUMBER;
18 --  p_exhibit_name_tbl  IN PO_TBL_VARCHAR30;
19 --  p_exhibit_description_tbl IN PO_TBL_VARCHAR240;
20 --  p_is_cdrl_tbl       IN PO_TBL_VARCHAR1;
21 --  p_revision_num_tbl  IN PO_TBL_NUMBER;
22 --IN OUT:
23 --OUT:
24 --Returns:
25 --Notes:
26 --Testing:
27 --End of Comments
28 ------------------------------------------------------------------------
29 PROCEDURE insert_exhibits
30 (
31   p_document_type_tbl IN PO_TBL_VARCHAR30,
32   p_document_id_tbl   IN PO_TBL_NUMBER,
33   p_exhibit_name_tbl  IN PO_TBL_VARCHAR30,
34   p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
35   p_is_cdrl_tbl       IN PO_TBL_VARCHAR1,
36   p_revision_num_tbl  IN PO_TBL_NUMBER,
37   x_return_status OUT NOCOPY VARCHAR2,
38   x_return_msg   OUT NOCOPY VARCHAR2
39 
40 );
41 
42 
43 
44 -----------------------------------------------------------------------
45 --Start of Comments
46 --Name: delete_exhibits
47 --Pre-reqs: None
48 --Modifies:
49 --Locks:
50 --  None
51 --Function:
52 --  Deletes the given exhibits for the given document
53 --Parameters:
54 --IN:
55 --  p_document_type_tbl IN PO_TBL_VARCHAR30;
56 --  p_document_id_tbl   IN PO_TBL_NUMBER;
57 --  p_exhibit_name_tbl  IN PO_TBL_VARCHAR30;
58 --  p_is_cdrl_tbl       IN PO_TBL_VARCHAR1;
59 --IN OUT:
60 --OUT:
61 --Returns:
62 --Notes:
63 --Testing:
64 --End of Comments
65 ------------------------------------------------------------------------
66 PROCEDURE delete_exhibits
67 (
68   p_document_type_tbl IN PO_TBL_VARCHAR30,
69   p_document_id_tbl   IN PO_TBL_NUMBER,
70   p_exhibit_name_tbl  IN PO_TBL_VARCHAR30,
71   p_is_cdrl_tbl       IN PO_TBL_VARCHAR1,
72   x_return_status OUT NOCOPY VARCHAR2,
73   x_return_msg   OUT NOCOPY VARCHAR2
74 );
75 
76 
77 --------------------------------------------------------------------------------
78   --Start of Comments
79 
80   --Name: start_closeout_wf_process
81 
82   --Function:
83   --  Starts the Closeout WF process and the sets the attributes
84 
85   --End of Comments
86 --------------------------------------------------------------------------------
87 
88 PROCEDURE start_closeout_wf_process (
89   p_doc_id        IN  NUMBER ,
90   x_return_status OUT NOCOPY VARCHAR2
91 );
92 
93 
94 
95 END PO_CLM_OKC_INTEG_PKG;
96