[Home] [Help]
PACKAGE: APPS.PO_GA_PVT
Source
1 PACKAGE PO_GA_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVGAS.pls 120.2.12020000.2 2013/02/10 11:48:20 vegajula ship $ */
3
4 --< Shared Proc FPJ Start >
5 g_requesting_org_type CONSTANT VARCHAR2(15) := 'REQUESTING';
6 g_purchasing_org_type CONSTANT VARCHAR2(15) := 'PURCHASING';
7 g_owning_org_type CONSTANT VARCHAR2(15) := 'OWNING';
8 --< Shared Proc FPJ End >
9
10 FUNCTION get_org_id
11 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
12 ) RETURN PO_HEADERS_ALL.org_id%TYPE;
13
14 FUNCTION get_current_org
15 RETURN PO_SYSTEM_PARAMETERS.org_id%TYPE;
16
17 FUNCTION is_owning_org
18 ( p_po_header_id IN PO_HEADERS.po_header_id%TYPE
19 ) RETURN BOOLEAN;
20
21 --< Shared Proc FPJ > Modified signature to remove %TYPE
22 FUNCTION get_org_name
23 ( p_org_id IN NUMBER
24 ) RETURN VARCHAR2;
25
26 FUNCTION is_global_agreement
27 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
28 ) RETURN BOOLEAN;
29
30 FUNCTION is_enabled
31 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
32 ) RETURN BOOLEAN;
33
34 FUNCTION enabled_orgs_exist
35 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
36 p_owning_org_id IN PO_HEADERS_ALL.org_id%TYPE
37 ) RETURN BOOLEAN;
38
39 FUNCTION is_referenced
40 ( p_po_line_id IN PO_LINES_ALL.from_line_id%TYPE
41 ) RETURN BOOLEAN;
42
43 --< Shared Proc FPJ > Modified signature to remove %TYPE
44 PROCEDURE get_ga_values
45 ( p_po_header_id IN NUMBER,
46 x_global_agreement_flag OUT NOCOPY VARCHAR2,
47 x_owning_org_id OUT NOCOPY NUMBER,
48 x_owning_org_name OUT NOCOPY VARCHAR2
49 );
50
51 FUNCTION is_expired
52 ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
53 ) RETURN BOOLEAN;
54
55 FUNCTION is_approved
56 ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
57 ) RETURN BOOLEAN;
58
59 FUNCTION is_ga_valid
60 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
61 p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
62 ) RETURN BOOLEAN;
63
64 FUNCTION is_date_valid
65 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
66 p_date IN DATE
67 ) RETURN BOOLEAN;
68
69 --< Shared Proc FPJ Start >
70 PROCEDURE validate_item
71 ( x_return_status OUT NOCOPY VARCHAR2,
72 p_item_id IN NUMBER,
73 p_org_id IN NUMBER,
74 p_valid_org_id IN NUMBER,
75 x_is_purchasable OUT NOCOPY BOOLEAN,
76 x_is_same_uom_class OUT NOCOPY BOOLEAN,
77 x_is_not_osp_item OUT NOCOPY BOOLEAN
78 );
79 --< Shared Proc FPJ End >
80
81 FUNCTION is_ship_to_org_valid
82 ( p_ship_to_org_id IN PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE
83 ) RETURN BOOLEAN;
84
85 FUNCTION get_vendor_site_id
86 ( p_po_header_id IN PO_GA_ORG_ASSIGNMENTS.po_header_id%TYPE
87 ) RETURN PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE;
88
89 PROCEDURE get_currency_info -- <2694908>
90 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
91 x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
92 x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
93 x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
94 x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
95 );
96
97 FUNCTION rate_exists -- <2709419>
98 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
99 ) RETURN BOOLEAN;
100
101 --<Bug 2721740 mbhargav START>
102 PROCEDURE sync_ga_line_attachments(
103 p_po_header_id IN po_headers_all.po_header_id%TYPE,
104 p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_data OUT NOCOPY VARCHAR2);
107
108 PROCEDURE reference_attachments(
109 p_api_version IN NUMBER,
110 p_from_entity_name IN VARCHAR2,
111 p_from_pk1_value IN VARCHAR2,
112 p_from_pk2_value IN VARCHAR2 DEFAULT NULL,
113 p_from_pk3_value IN VARCHAR2 DEFAULT NULL,
114 p_from_pk4_value IN VARCHAR2 DEFAULT NULL,
115 p_from_pk5_value IN VARCHAR2 DEFAULT NULL,
116 p_to_entity_name IN VARCHAR2,
117 p_to_pk1_value IN VARCHAR2,
118 p_to_pk2_value IN VARCHAR2 DEFAULT NULL,
119 p_to_pk3_value IN VARCHAR2 DEFAULT NULL,
120 p_to_pk4_value IN VARCHAR2 DEFAULT NULL,
121 p_to_pk5_value IN VARCHAR2 DEFAULT NULL,
122 p_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_data OUT NOCOPY VARCHAR2);
125 --<Bug 2721740 mbhargav END>
126
127
128 -- <GC FPJ START>
129 PROCEDURE is_purchasing_site_on_ga
130 ( p_po_header_id IN NUMBER,
131 p_vendor_site_id IN NUMBER,
132 x_result OUT NOCOPY VARCHAR2
133 );
134
135 FUNCTION is_local_document
136 ( p_po_header_id IN NUMBER,
137 p_type_lookup_code IN VARCHAR2
138 ) RETURN BOOLEAN;
139 -- <GC FPJ END>
140
141 --< Shared Proc FPJ Start >
142 FUNCTION get_purchasing_org_id
143 ( p_po_header_id IN NUMBER
144 ) RETURN NUMBER;
145
146 PROCEDURE validate_item_revision
147 (
148 x_return_status OUT NOCOPY VARCHAR2,
149 p_item_id IN NUMBER,
150 p_org_id IN NUMBER,
151 p_ga_item_revision IN VARCHAR2,
152 p_owning_org_id IN NUMBER,
153 p_check_rev_control IN BOOLEAN,
154 x_is_valid OUT NOCOPY BOOLEAN,
155 x_item_revision OUT NOCOPY VARCHAR2
156 );
157
158 PROCEDURE validate_item_in_org
159 (
160 x_return_status OUT NOCOPY VARCHAR2,
161 p_item_id IN NUMBER,
162 p_org_id IN NUMBER,
163 p_ga_org_type IN VARCHAR2,
164 p_ga_item_revision IN VARCHAR2,
165 p_owning_org_id IN NUMBER,
166 x_is_valid OUT NOCOPY BOOLEAN,
167 x_item_revision OUT NOCOPY VARCHAR2
168 );
169
170 PROCEDURE val_enabled_purchasing_org
171 (
172 x_return_status OUT NOCOPY VARCHAR2,
173 p_po_header_id IN NUMBER,
174 x_purchasing_org_id IN OUT NOCOPY NUMBER,
175 x_is_valid OUT NOCOPY BOOLEAN
176 );
177
178 PROCEDURE val_enabled_requesting_org
179 (
180 x_return_status OUT NOCOPY VARCHAR2,
181 p_po_header_id IN NUMBER,
182 x_requesting_org_id IN OUT NOCOPY NUMBER,
183 x_is_valid OUT NOCOPY BOOLEAN,
184 x_purchasing_org_id OUT NOCOPY NUMBER
185 );
186
187 PROCEDURE validate_in_purchasing_org
188 (
189 x_return_status OUT NOCOPY VARCHAR2,
190 p_po_header_id IN NUMBER,
191 p_item_id IN NUMBER,
192 p_purchasing_org_id IN NUMBER,
193 p_ga_item_revision IN VARCHAR2,
194 p_owning_org_id IN NUMBER,
195 x_is_pou_valid OUT NOCOPY BOOLEAN,
196 x_is_item_valid OUT NOCOPY BOOLEAN,
197 x_item_revision OUT NOCOPY VARCHAR2
198 );
199
200 PROCEDURE validate_in_requesting_org
201 (
202 x_return_status OUT NOCOPY VARCHAR2,
203 p_po_header_id IN NUMBER,
204 p_item_id IN NUMBER,
205 p_requesting_org_id IN NUMBER,
206 p_ga_item_revision IN VARCHAR2,
207 p_owning_org_id IN NUMBER,
208 x_is_rou_valid OUT NOCOPY BOOLEAN,
209 x_is_item_valid OUT NOCOPY BOOLEAN,
210 x_item_revision OUT NOCOPY VARCHAR2
211 );
212
213 FUNCTION requesting_org_type RETURN VARCHAR2;
214
215 FUNCTION purchasing_org_type RETURN VARCHAR2;
216
217 FUNCTION owning_org_type RETURN VARCHAR2;
218
219 --< Shared Proc FPJ End >
220
221 --Bug 12838070
222 PROCEDURE sync_all_ga_line_attachments(
223 p_po_header_id IN po_headers_all.po_header_id%TYPE,
224 p_draft_id IN PO_LINES_DRAFT_ALL.draft_id%TYPE, --Bug 13540474
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_data OUT NOCOPY VARCHAR2);
227
228 END PO_GA_PVT;