[Home] [Help]
183: END get_uda_template_id;
184:
185:
186: PROCEDURE get_attribute_groups(p_uda_template_id IN NUMBER,
187: x_attr_group_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
188: )
189: IS
190: l_api_name VARCHAR2(30) := 'get_attribute_groups';
191: l_progress VARCHAR2(3) := '000';
192:
193:
194: l_return_status VARCHAR2(1);
195: l_err_msg VARCHAR2(1000);
196: l_attr_group_tbl PO_TBL_VARCHAR30;
197:
198: BEGIN
199: IF g_debug_stmt THEN
200: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
378: PROCEDURE get_autocreate_properties(p_doc_level IN VARCHAR2,
379: p_attr_group IN VARCHAR2,
380: p_src_doc_type IN VARCHAR2,
381: p_tar_doc_type IN VARCHAR2,
382: x_group_property_tbl OUT NOCOPY PO_TBL_VARCHAR30
383: )
384: /* Query our newly created Rules Table */
385: IS
386: l_api_name VARCHAR2(30) := 'get_autocreate_properties';
1341: x_source_pkey_tbl po_tbl_number;
1342: x_target_pkey_tbl po_tbl_number;
1343: x_pkey_tbl po_tbl_number;
1344:
1345: l_attr_group_tbl po_tbl_varchar30;
1346: x_return_status VARCHAR2(1);
1347: x_msg_count NUMBER;
1348: x_msg_data VARCHAR2(2000);
1349:
1831: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1832: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1833:
1834: l_to_pk1_value NUMBER;
1835: l_attr_group_tbl PO_TBL_VARCHAR30;
1836:
1837: x_return_status VARCHAR2(1);
1838: x_msg_count NUMBER;
1839: x_msg_data VARCHAR2(1000);
3194:
3195: x_doc_level_tbl po_tbl_varchar15;
3196:
3197: l_uda_template_id NUMBER;
3198: x_attr_group_tbl po_tbl_varchar30;
3199: x_priorities_tbl PO_TBL_VARCHAR3;
3200: l_ag_type VARCHAR2(300);
3201: l_tbl_name varchar2(100);
3202: x_source_pkey_tbl po_tbl_number;
3204: l_data_copied VARCHAR2(1);
3205: x_source_doc_level VARCHAR2(10);
3206: x_group_type VARCHAR2(120);
3207: x_group_property VARCHAR2(120);
3208: x_group_property_tbl PO_TBL_VARCHAR30;
3209: l_authorization_status po_headers_all.AUTHORIZATION_STATUS%TYPE; /*bug 12415651*/
3210:
3211:
3212: BEGIN