1 PACKAGE PO_XML_UTILS_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXMLUTS.pls 120.4.12020000.2 2013/02/10 20:26:34 vegajula ship $ */
3
4 -- Start of comments
5 -- API name : getAttachment
6 -- Type : public
7 -- Pre-reqs : none
8 -- Function : get text attachment, short text and long text
9 -- Parameters :
10 -- IN : p_media_id in number required
11 -- p_datatype_id in number required
12 -- OUT : x_attachment_content out clob
13 -- Version : initial version
14 -- End of comments
15 procedure getAttachment (p_media_id in NUMBER,
16 p_datatype_id in NUMBER,
17 x_attachment_content out NOCOPY CLOB);
18
19 -- Start of comments
20 -- API name : getAttachmentFile
21 -- Type : public
22 -- Pre-reqs : none
23 -- Function : get file attachment
24 -- Parameters :
25 -- IN : p_media_id in number required
26 -- IN : p_pk1_value in NUMBER required
27 -- IN : p_pk2_value in NUMBER required
28 -- IN : p_pk3_value in NUMBER required
29 -- IN : p_pk4_value in NUMBER required
30 -- IN : p_pk5_value in NUMBER required
31 -- IN : p_entity_name in VARCHAR2 required
32 -- OUT : x_cid out varchar2
33 -- Version : initial version
34 -- End of comments
35 procedure getAttachmentFile (p_media_id in NUMBER,
36 p_pk1_value in NUMBER,
37 p_pk2_value IN NUMBER,
38 p_pk3_value IN NUMBER,
39 p_pk4_value IN NUMBER,
40 p_pk5_value IN NUMBER,
41 p_entity_name IN VARCHAR2,
42 x_cid out NOCOPY VARCHAR2);
43 -- Start of comments
44 -- API name : getAttachmentUrl
45 -- Type : public
46 -- Pre-reqs : none
47 -- Function : get url attached
48 -- Parameters :
49 -- IN : p_document_id number required
50 -- OUT : x_attachment_content varchar2
51 -- Version : initial version
52 -- End of comments
53 PROCEDURE getAttachmentUrl (p_document_id IN NUMBER,
54 x_attachment_content OUT NOCOPY VARCHAR2);
55
56 -- Start of comments
57 -- API name : splitforids
58 -- Type : public
59 -- Pre-reqs : none
60 -- Function : split ECX_PARAMETER3 to user_id, responsibility_id and application_id
61 -- Parameters :
62 -- IN : p_ecx_parameter3 ECX_PARAMETER3
63 -- OUT : x_user_id user_id
64 -- : x_resp_id responsibility_id
65 -- : x_appl_id application_id
66 -- Version : initial version
67 -- End of comments
68 procedure splitforids (p_ecx_parameter3 in VARCHAR2,
69 x_user_id out NOCOPY NUMBER,
70 x_resp_id out NOCOPY NUMBER,
71 x_appl_id out NOCOPY NUMBER);
72
73 -- Start of comments
74 -- API name : getBlanketPONumber
75 -- Type : public
76 -- Pre-reqs : none
77 -- Function : Given a po_release_id returns the segment1 of the blanket; Otherwise null.
78 -- Parameters :
79 -- IN : p_release_id Release Id
80 -- : p_po_type PO Type - RELEASE or REGULAR
81 -- OUT : p_Blanket_PO_Num Blanket PO#
82 -- Version : initial version
83 -- End of comments
84 procedure getBlanketPONumber (p_release_id in NUMBER,
85 p_po_type in VARCHAR2,
86 p_Blanket_PO_Num out NOCOPY VARCHAR2
87 );
88
89
90
91 -- Start of comments
92 -- API name : getTandC
93 -- Type : public
94 -- Pre-reqs : none
95 -- Function : get terms and conditions
96 -- Parameters :
97 -- IN : p_user_id in number required
98 -- p_resp_id in number required
99 -- : p_appl_id in number required
100 -- OUT : x_TandCcontent out clob
101 -- Version : initial version
102 -- End of comments
103
104 --Bug 6692126 Changing the in parameters
105 -- p_document_id in number
106 -- p_document_type in varchar2
107
108 /*procedure getTandC(p_user_id in NUMBER,
109 p_resp_id in NUMBER,
110 p_appl_id in NUMBER,
111 x_TandCcontent out NOCOPY CLOB); */
112
113 procedure getTandC (p_document_id in NUMBER,
114 p_document_type in VARCHAR2,
115 x_TandCcontent out NOCOPY CLOB);
116
117 /*Added for bug#6912518*/
118 procedure getTandCforXML (p_po_header_id in NUMBER,
119 p_po_release_id in NUMBER,
120 x_TandCcontent out NOCOPY CLOB);
121
122 -- Start of comments
123 -- API name : regenandsend
124 -- Type : Group
125 -- Pre-reqs : None
126 -- Function : Given a po_header_id and other related information it
127 -- will generate and send the PROCESS_PO xml document.
128 -- Parameters :
129 -- IN : p_po_header_id po_header_id or po_release_id of the PO
130 -- p_po_type STANDARD or RELEASE depending on the PO type
131 -- p_po_revision
132 -- p_user_id
133 -- p_responsibility_id
134 -- p_application_id
135 -- p_preparer_user_name
136 -- OUT :
137 -- Version :
138 -- End of Comments
139
140 procedure regenandsend(p_po_header_id in NUMBER,
141 p_po_type in VARCHAR2,
142 p_po_revision in NUMBER,
143 p_user_id in NUMBER,
144 p_responsibility_id in NUMBER,
145 p_application_id NUMBER,
146 p_preparer_user_name VARCHAR2 default null);
147
148 -- Start of comments
149 -- API Name : getGlobalAgreementInfo
150 -- Type : private
151 -- Pre-Reqs : FPI code line
152 -- Function : Given a line_id it will provide the associated Global Contract information.
153 -- Parameters :
154 -- IN : p_po_line_id line_id you are interested
155 -- OUT : x_GLOBALCONTRACT The Global Contract PO num, if exists.
156 -- : x_GLOBALCONTRACTLIN The line num of the Glbl Cntrct PO
157 -- Version : Initial version for FPI.
158 -- End Of Comments
159
160 procedure getGlobalAgreementInfo (p_po_line_id in NUMBER,
161 x_GLOBALCONTRACT OUT NOCOPY VARCHAR2,
162 x_GLOBALCONTRACTLIN OUT NOCOPY VARCHAR2);
163
164 -- Start of comments
165 -- API Name : getTaxDetails
166 -- Type : group
167 -- Pre-Reqs : FPI code line
168 -- Function : Given a line_loc_id it will get the tax details information.
169 -- Version : Initial version for FPI.
170 -- End Of Comments
171 procedure getTaxDetails (p_po_line_loc_id IN NUMBER,
172 x_TAX_RATE OUT NOCOPY varchar2,
173 x_IS_VAT_RECOVERABLE OUT NOCOPY varchar2,
174 x_TAX_TYPE OUT NOCOPY varchar2,
175 x_TAX_NAME OUT NOCOPY varchar2,
176 x_ESTIMATED_TAX_AMOUNT OUT NOCOPY number,
177 x_TAX_DESCRIPTION OUT NOCOPY varchar2
178 );
179
180 -- Start of Comments
181 -- In R12, we only need to present the taxable_flag information
182 -- other tax information are migrated to ebTax.
183 -- End of Comments
184 procedure getTaxInfo (p_po_line_loc_id IN NUMBER,
185 X_TAXABLE OUT NOCOPY varchar2);
186
187
188 -- Start of Comments
189 -- API Name : getUserEnvLang
190 -- Type : group
191 -- Pre-Reqs : FPH codeline
192 -- Function : Gets the session language.
193 -- Version : Initial version of FPH.
194 -- End of Comments
195
196 procedure getUserEnvLang (x_lang OUT NOCOPY varchar2);
197
198 END PO_XML_UTILS_GRP;
199
200