1 PACKAGE po_multi_mod_pvt AUTHID CURRENT_USER AS
2 /* $Header: PO_MULTI_MOD_PVT.pls 120.4 2011/12/16 12:55:27 agalande noship $ */
3
4 -------------------------------------------------------------------------------
5 --Start of Comments
6 --Name: start_mod_approval
7 --Pre-reqs:
8 -- None.
9 --Modifies:
10 -- None.
11 --Locks:
12 -- None.
13 --Function:
14 -- Create Modification as part of the Multi-Mod Concurrent Request.
15 --Parameters:
16 --IN:
17 --p_multi_mod_request_id
18 -- The request id of the Multi-Mod Request
19 --p_po_header_id
20 -- The id of the Order/Agreement for which the Mod needs to be created
21 --p_draft_id
22 -- The draft Id of the newly created Modification
23 --OUT:
24 --x_return_status
25 -- FND_API.G_RET_STS_SUCCESS if API succeeds
26 -- FND_API.G_RET_STS_ERROR if API fails
27 -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
28 --Testing:
29 -- None.
30 --End of Comments
31 -------------------------------------------------------------------------------
32 PROCEDURE start_mod_approval(p_multi_mod_request_id IN NUMBER,
33 p_po_header_id IN NUMBER,
34 p_draft_id IN NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2);
36
37 -------------------------------------------------------------------------------
38 --Start of Comments
39 --Name: create_modification
40 --Pre-reqs:
41 -- None.
42 --Modifies:
43 -- None.
44 --Locks:
45 -- None.
46 --Function:
47 -- Create Modification as part of the Multi-Mod Concurrent Request.
48 --Parameters:
49 --IN:
50 --p_multi_mod_request_id
51 -- The request id of the Multi-Mod Request
52 --p_po_header_id
53 -- The id of the Order/Agreement for which the Mod needs to be created
54 --p_addr_change_flag
55 -- Flag will indicate if there are any address changes in the Multi-Mod request
56 --p_clause_change_flag
57 -- Flag will indicate if there are any clause changes in the Multi-Mod request
58 --OUT:
59 --x_draft_id
60 -- The draft Id of the newly created Modification
61 --x_mod_number
62 -- The Modification Number of the newly created Modification
63 --x_mod_creation_flag
64 -- Flag indicate whether there are any relevant changes that would trigger
65 -- the need for Mod-creation.
66 --x_return_status
67 -- FND_API.G_RET_STS_SUCCESS if API succeeds
68 -- FND_API.G_RET_STS_ERROR if API fails
69 -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
70 --Testing:
71 -- None.
72 --End of Comments
73 -------------------------------------------------------------------------------
74 PROCEDURE create_modification(p_multi_mod_request_id IN NUMBER,
75 p_po_header_id IN NUMBER,
76 p_addr_change_flag IN VARCHAR2,
77 p_clause_change_flag IN VARCHAR2,
78 x_draft_id OUT NOCOPY NUMBER,
79 x_mod_number OUT NOCOPY VARCHAR2,
80 x_mod_creation_flag OUT NOCOPY VARCHAR2,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_error_msg_code OUT NOCOPY VARCHAR2);
83
84 -------------------------------------------------------------------------------
85 --Start of Comments
86 --Name: remove_mmod_doc_data
87 --Pre-reqs:
88 -- None.
89 --Modifies:
90 -- None.
91 --Locks:
92 -- None.
93 --Function:
94 -- If a Document has been removed from the selected documents list of a multi-mod
95 -- request, then all the associated vendor changes for the doc will be removed.
96 -- Also, all the related Validation Exceptions to that Document will be removed
97 --Parameters:
98 --IN:
99 --p_multi_mod_request_id
100 -- The request id of the Multi-Mod Request
101 --Testing:
102 -- None.
103 --End of Comments
104 -------------------------------------------------------------------------------
105 PROCEDURE remove_mmod_doc_data(p_multi_mod_request_id IN NUMBER);
106
107 -------------------------------------------------------------------------------
108 --Start of Comments
109 --Name: remove_multi_mod_request
110 --Pre-reqs:
111 -- None.
112 --Modifies:
113 -- None.
114 --Locks:
115 -- None.
116 --Function:
117 -- Removes the document from selected documents list.
118
119 --Parameters:
120 --IN:
121 --p_multi_mod_request_id
122 -- The request id of the Multi-Mod Request
123 --Testing:
124 -- None.
125 --End of Comments
126 -------------------------------------------------------------------------------
127
128 PROCEDURE remove_multi_mod_request (p_multi_mod_request_id IN NUMBER,
129 x_return_status OUT NOCOPY VARCHAR2);
130
131
132
133 --Start of Comments
134 --Name: remove_from_ASL
135 --Pre-reqs:
136 -- None.
137 --Modifies:
138 -- None.
139 --Locks:
140 -- None.
141 --Function:
142 -- Checks if there exists any ASL entry for the IDVs that are selected for
143 -- multi-mod vendor change and delete the entry from the ASL
144
145 --Parameters:
146 --IN:
147 --p_multi_mod_request_id
148 -- The request id of the Multi-Mod Request
149 --Testing:
150 -- None.
151 --End of Comments
152 -------------------------------------------------------------------------------
153
154 PROCEDURE remove_from_ASL (itemtype in varchar2,
155 itemkey in varchar2,
156 actid in number,
157 funcmode in varchar2,
158 resultout out NOCOPY varchar2);
159
160
161 END po_multi_mod_pvt; -- Package spec
162