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