[Home] [Help]
PACKAGE: APPS.ITG_X_UTILS
Source
1 PACKAGE ITG_X_UTILS AUTHID CURRENT_USER AS
2 /* ARCS: $Header: itgxutls.pls 120.2 2006/02/16 23:00:27 bsaratna noship $
3 * CVS: itgxutls.pls,v 1.19 2003/02/05 23:05:06 klai Exp
4 */
5
6 /* Who are we? */
7 c_app_short_name CONSTANT VARCHAR2(5) := 'ITG';
8 c_application_id CONSTANT NUMBER := 230;
9 c_user_id CONSTANT NUMBER := 3;
10 c_resp_id CONSTANT NUMBER := 20707;
11 c_resp_appl_id CONSTANT NUMBER := 201;
12
13 /* Collaboration points. */
14 c_coll_pt CONSTANT VARCHAR2(30) := 'OIPC';
15 c_final_coll_pt CONSTANT VARCHAR2(30) := 'OIPC_FINAL';
16 c_xmlg_coll_pt CONSTANT VARCHAR2(30) := 'XML_GATEWAY';
17
18 /* Outbound event constants/values */
19 c_event_name CONSTANT VARCHAR2(30) := 'oracle.apps.itg.outbound';
20 g_event_key_pfx VARCHAR2(60);
21 g_local_system wf_systems.name%TYPE;
22 c_correlation_id CONSTANT VARCHAR2(10) := 'ITG_CID';
23
24 /* Trading pertner info. */
25 c_party_type CONSTANT VARCHAR2(1) := 'I';
26 c_party_site_name CONSTANT VARCHAR2(30) := 'OIPC Default TP';
27 g_party_id VARCHAR2(40);
28 g_party_site_id VARCHAR2(40);
29
30 /* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE
31 * Show package initialization/setup status in reference to possibly
32 * missing data in hr_locations_all (or any other problem at package
33 * load time).
34 */
35 g_initialized BOOLEAN := FALSE;
36
37 /*
38 ** Given an Address Style, return the Region with the
39 ** County name or equivalent
40 */
41 FUNCTION getCounty (
42 addrStyle IN VARCHAR2,
43 regionOne IN VARCHAR2,
44 regionTwo IN VARCHAR2
45 ) RETURN VARCHAR2;
46 PRAGMA restrict_references( getCounty, WNDS );
47
48 /*
49 ** Which segment in the p_idFlexNum is the p_flexQualifierName segment?
50 ** Returns the fnd_id_flex_segments.application_column_name value.
51 */
52 FUNCTION getFlexQualifierSegment (
53 p_idFlexNum number,
54 p_flexQualifierName varchar2
55 ) return varchar2;
56 PRAGMA restrict_references ( getFlexQualifierSegment, WNDS );
57
58 /*
59 ** get_inventory_org_id is used to get the inventory_organization_id
60 ** given the org_id using the financials_system_params_all table
61 */
62
63 FUNCTION get_inventory_org_id (p_org_id NUMBER)
64 RETURN NUMBER;
65 PRAGMA restrict_references( get_inventory_org_id, WNDS );
66
67 /*
68 ** Given a po_req_distribution_id, return the segment1
69 */
70 function getRequistnid ( poReqDistId IN Number ) return varchar2;
71 PRAGMA restrict_references( getRequistnid, WNDS );
72
73 /*
74 ** Given a po_req_distribution_id, return the line_num from po_requisition_lines_all
75 */
76 FUNCTION getReqLineNum ( poReqDistId IN Number )
77 RETURN varchar2;
78 PRAGMA restrict_references( getReqLineNum, WNDS );
79
80 /*
81 ** Given an Address Style, return the Region with the
82 ** State/Province name or equivalent
83 */
84 FUNCTION getState (
85 addrStyle IN VARCHAR2,
86 regionOne IN VARCHAR2,
87 regionTwo IN VARCHAR2
88 ) RETURN VARCHAR2;
89 PRAGMA restrict_references( getState, WNDS );
90
91 /*
92 ** getTaxId looks up a TIN or VRN for a given US or non-US
93 ** company. Returns a NULL if no ID number found.
94 */
95 FUNCTION getTaxId (
96 country IN varchar2,
97 orgId IN number,
98 orgName IN varchar2,
99 orgUnit IN number,
100 invOrg IN number
101 ) RETURN VARCHAR2;
102
103 /*
104 ** Return a concatenated segment string with
105 ** appropriate delimiter for the given flexfield
106 */
107 FUNCTION SegString (
108 appId IN NUMBER,
109 flexCode IN VARCHAR2,
110 flexNum IN NUMBER,
111 segment1 IN VARCHAR2, segment2 IN VARCHAR2,
112 segment3 IN VARCHAR2, segment4 IN VARCHAR2 := NULL,
113 segment5 IN VARCHAR2 := NULL, segment6 IN VARCHAR2 := NULL,
114 segment7 IN VARCHAR2 := NULL, segment8 IN VARCHAR2 := NULL,
115 segment9 IN VARCHAR2 := NULL, segment10 IN VARCHAR2 := NULL,
116 segment11 IN VARCHAR2 := NULL, segment12 IN VARCHAR2 := NULL,
117 segment13 IN VARCHAR2 := NULL, segment14 IN VARCHAR2 := NULL,
118 segment15 IN VARCHAR2 := NULL, segment16 IN VARCHAR2 := NULL,
119 segment17 IN VARCHAR2 := NULL, segment18 IN VARCHAR2 := NULL,
120 segment19 IN VARCHAR2 := NULL, segment20 IN VARCHAR2 := NULL,
121 segment21 IN VARCHAR2 := NULL, segment22 IN VARCHAR2 := NULL,
122 segment23 IN VARCHAR2 := NULL, segment24 IN VARCHAR2 := NULL,
123 segment25 IN VARCHAR2 := NULL, segment26 IN VARCHAR2 := NULL,
124 segment27 IN VARCHAR2 := NULL, segment28 IN VARCHAR2 := NULL,
125 segment29 IN VARCHAR2 := NULL, segment30 IN VARCHAR2 := NULL
126 ) RETURN VARCHAR2;
127 PRAGMA restrict_references( segString, WNDS );
128
129 /*
130 ** Returns the sign of a number
131 */
132 FUNCTION signOf ( anyNumber IN Number )
133 RETURN varchar2;
134 PRAGMA restrict_references( signOf, WNDS );
135
136 /*
137 ** sumPoLineLocs summarizes the quantity*price_override
138 ** from po_line_locations_all for the given po_header_id
139 **
140 ** Taken from Po_Ip_Oagxml_Pkg.
141 */
142 FUNCTION sumPoLineLocs (
143 poHeaderId IN Number,
144 poRelease IN Number := null
145 ) RETURN number;
146 PRAGMA restrict_references( sumPoLineLocs, WNDS );
147
148 /*
149 ** sumPoLineLocs summarizes the quantity*price_override
150 ** from po_line_locations_all for the given po_header_id
151 **
152 */
153 FUNCTION sumReqLines ( reqHeaderId IN NUMBER )
154 RETURN NUMBER;
155 PRAGMA restrict_references( sumReqLines, WNDS );
156
157 FUNCTION getAttachments(p_table_name VARCHAR2,
158 p_type VARCHAR2,
159 p_id NUMBER )
160 RETURN VARCHAR2;
161
162 FUNCTION isPoLineApproved(v_po_line_id in Number)
163 RETURN NUMBER;
164 PRAGMA restrict_references( isPoLineApproved, WNDS );
165
166 PROCEDURE addCBODDescMsg(p_msg_app IN VARCHAR2,
167 p_msg_code IN VARCHAR2,
168 p_token_vals IN VARCHAR2 := NULL,
169 p_translatable IN BOOLEAN := TRUE,
170 p_reset IN BOOLEAN := FALSE);
171
172 FUNCTION getCBODDescMsg(p_reset IN BOOLEAN := FALSE) RETURN VARCHAR2;
173
174 FUNCTION translateCBODDescMsg(p_msg_list IN VARCHAR2) RETURN VARCHAR2;
175
176 PROCEDURE getTextAttachments(p_table_name VARCHAR2,
177 p_id NUMBER,
178 x_pointernal OUT NOCOPY VARCHAR2,
179 x_misc OUT NOCOPY VARCHAR2,
180 x_approver OUT NOCOPY VARCHAR2,
181 x_buyer OUT NOCOPY VARCHAR2,
182 x_payables OUT NOCOPY VARCHAR2,
183 x_reciever OUT NOCOPY VARCHAR2,
184 x_vendor OUT NOCOPY VARCHAR2);
185
186
187 END;