1 PACKAGE PO_UDA_DATA_UTIL AUTHID CURRENT_USER AS
2 /* $Header: PO_UDA_DATA_UTIL.pls 120.13.12020000.3 2013/02/10 15:42:01 vegajula ship $ */
3
4 TYPE g_object_dff_cr IS RECORD
5 (
6 l_object_name FND_OBJECTS.DATABASE_OBJECT_NAME%TYPE,
7 l_dff_name FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
8 l_object_ext_b_table FND_TABLES.TABLE_NAME%TYPE,
9 l_object_ext_tl_table FND_TABLES.TABLE_NAME%TYPE,
10 l_ag_mapping_column VARCHAR2(50),
11 l_arch_object_name FND_OBJECTS.DATABASE_OBJECT_NAME%TYPE
12 );
13
14 TYPE object_dff_tl IS TABLE OF g_object_dff_cr INDEX BY VARCHAR2(50);
15 g_object_dff_tl object_dff_tl;
16
17 TYPE address_eit_tbl is table of varchar2(100) index by varchar2(100);
18 g_address_eit_tbl address_eit_tbl;
19
20 PROCEDURE CHECK_ATTR_OR_PAGE_ID_VALID
21 (
22 p_template_id IN NUMBER
23 ,p_attr_grp_or_page_id IN NUMBER
24 ,p_attr_grp_or_page_type IN VARCHAR2
25 ,x_usage_code OUT NOCOPY VARCHAR2
26 ,x_found_status OUT NOCOPY VARCHAR2
27 );
28
29
30 PROCEDURE UDA_DEFAULT_ATTRIBUTES
31 (
32 p_template_id IN NUMBER
33 ,p_attr_grp_id IN NUMBER
34 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
35 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
36 ,x_attr_name_value_pairs OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
37 ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_errorcode OUT NOCOPY NUMBER
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE UDA_VALIDATE_ATTRIBUTES
45 (
46 p_template_id IN NUMBER
47 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
48 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
49 ,x_attr_name_value_pairs OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
50 ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_errorcode OUT NOCOPY NUMBER
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE CHECK_CONTEXT_VALID
58 (
59 p_template_id IN NUMBER
60 ,p_usage_code IN VARCHAR2
61 ,x_valid_status OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE GET_ATTR_OR_PAGE_ID
65 (
66 p_sql_str IN VARCHAR2
67 ,p_template_id IN VARCHAR2
68 ,x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER
69 ,x_type OUT NOCOPY VARCHAR2
70 ,x_id OUT NOCOPY NUMBER
71 ,x_found_status OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE AutoCreate_User_Attrs
75 (
76 from_template_id IN NUMBER
77 ,to_template_id IN NUMBER
78 ,from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
79 ,to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
80 ,copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSION
81 ,attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
82 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Archive_Attrs_Data
89 (
90 x_template_id IN NUMBER
91 ,x_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
92 ,x_revision_id IN NUMBER
93 ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE Copy_User_Attrs
100 (
101 x_template_id IN NUMBER
102 ,x_from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
103 ,x_to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
104 ,x_copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSIVE
105 ,x_attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
106 ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 PROCEDURE Merge_Amendment_Address_AG
113 (
114 x_amd_requisition_header_id IN NUMBER
115 ,x_requisition_header_id IN NUMBER
116 ,x_return_status OUT NOCOPY VARCHAR2
117 );
118
119 PROCEDURE Merge_Mod_Address_AG
120 (
121 p_po_header_id IN NUMBER
122 ,p_draft_id IN NUMBER
123 ,x_return_status OUT NOCOPY VARCHAR2
124 );
125
126 PROCEDURE GET_ASSOCIATION_ID
127 (
128 p_template_id IN NUMBER,
129 p_attribute_grp_id IN NUMBER,
130 p_association_id OUT NOCOPY NUMBER
131 );
132
133 PROCEDURE CREATE_ASSOCIATION_ID
134 (
135 p_template_id IN NUMBER,
136 p_attribute_grp_id IN NUMBER,
137 p_association_id OUT NOCOPY NUMBER
138 );
139
140 FUNCTION Get_Table_Columns_List (
141 p_from_table_name IN VARCHAR2
142 ,p_from_cols_to_exclude_list IN VARCHAR2 DEFAULT NULL
143 ,p_from_table_alias_prefix IN VARCHAR2 DEFAULT NULL
144 ,p_to_table_name IN VARCHAR2 DEFAULT NULL
145 ,p_to_table_alias_prefix IN VARCHAR2 DEFAULT NULL
146 )
147 RETURN VARCHAR2;
148
149 PROCEDURE get_attr_group_ids(
150 p_object_name IN VARCHAR2,
151 p_where_clause IN VARCHAR2,
152 p_attr_grp_type IN VARCHAR2,
153 x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER
154 );
155
156 Function get_template_id (
157 p_functional_area IN VARCHAR2,
158 p_document_type IN VARCHAR2,
159 p_document_style_id IN NUMBER,
160 p_document_level IN VARCHAR2,
161 p_input_date IN DATE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_err_msg OUT NOCOPY VARCHAR2
164 ) RETURN NUMBER ;
165
166 PROCEDURE Execute_uda_Function(
167 p_Action_Id IN NUMBER
168 ,p_template_id IN NUMBER
169 ,p_attribute_group_id IN NUMBER
170 ,p_event IN VARCHAR2
171 ,x_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
172 ,x_attribute_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
173 ,x_attribute_data_table IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
174 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
175 ,x_return_status OUT NOCOPY VARCHAR2
176 ,x_errorcode OUT NOCOPY NUMBER
177 ,x_msg_count OUT NOCOPY NUMBER
178 ,x_msg_data OUT NOCOPY VARCHAR2
179 );
180
181 PROCEDURE get_po_header_attr_group_ids(
182 p_template_id IN VARCHAR2,
183 p_po_header_id IN NUMBER,
184 p_is_doc_mod VARCHAR2,
185 x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
186 x_return_status OUT NOCOPY VARCHAR2
187 );
188
189 PROCEDURE get_po_line_attr_group_ids(
190 p_template_id IN VARCHAR2,
191 p_po_line_id IN NUMBER,
192 p_draft_id IN NUMBER DEFAULT -1,
193 p_is_doc_mod VARCHAR2,
194 x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
195 x_return_status OUT NOCOPY VARCHAR2
196 );
197
198 PROCEDURE get_po_line_loc_attr_group_ids(
199 p_template_id IN VARCHAR2,
200 p_po_line_location_id IN NUMBER,
201 p_is_doc_mod VARCHAR2,
202 x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
203 x_return_status OUT NOCOPY VARCHAR2
204 );
205 PROCEDURE global_update_line_uda
206 (
207 po_src_line_id IN NUMBER ,
208 po_dest_line_ids_tbl IN PO_TBL_NUMBER,
209 p_draft_id IN NUMBER
210 );
211 PROCEDURE global_update_shipment_uda
212 (
213 po_src_line_location_id IN NUMBER ,
214 po_dest_line_location_ids_tbl IN PO_TBL_NUMBER,
215 p_draft_id IN NUMBER
216 );
217
218 function is_location_valid (
219 p_location_id in number,
220 p_address_type in varchar2
221 ) return varchar2;
222
223 function get_award_type (
224 p_po_header_id in number,
225 p_draft_id in number,
226 x_return_status out nocopy varchar2,
227 x_msg_data out nocopy varchar2
228 ) return varchar2;
229
230 --<Bug 13915026>
231 PROCEDURE get_attr_group_id (
232 p_contract_type IN VARCHAR2,
233 p_idc_type IN VARCHAR2,
234 p_template_id IN NUMBER,
235 p_attr_category IN VARCHAR2,
236 x_attr_group_id OUT NOCOPY NUMBER,
237 x_return_status OUT NOCOPY VARCHAR2
238 );
239
240
241 END PO_UDA_DATA_UTIL;