[Home] [Help]
375:
376: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Class codes Array', d_progress);
377: x_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
378: (
379: EGO_COL_NAME_VALUE_PAIR_OBJ
380: (
381: 'UDA_TEMPLATE_ID'
382: ,l_uda_template_id || ''
383: )
652: l_data_level VARCHAR2(200);
653: l_sql_query VARCHAR2(4000);
654: l_check NUMBER;
655: v_query_hdl NUMBER;
656: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
657: l_attr_row_obj EGO_USER_ATTR_ROW_OBJ;
658: l_rows_processed NUMBER;
659: l_attr_grp_loc_index NUMBER;
660: l_row_identifier NUMBER;
1179: l_attr_id_index1 NUMBER;
1180: l_attr_obj EGO_USER_ATTR_DATA_OBJ;
1181: l_attr_obj1 EGO_USER_ATTR_DATA_OBJ;
1182: ext_attr_value_pairs_ind NUMBER;
1183: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1184:
1185: g_uda_return_status VARCHAR2(2);
1186: uda_msg_data VARCHAR2(2000);
1187: uda_return_status VARCHAR2(2);
1201: l_attr_name_value_pairs_ind NUMBER;
1202: l_attributes_row_table_ind NUMBER;
1203: l_ext_attr_value_pairs_ind NUMBER;
1204:
1205: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1206: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
1207: l_attributes_row ego_user_attr_row_obj;
1208: l_external_attr_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1209:
1204:
1205: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1206: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
1207: l_attributes_row ego_user_attr_row_obj;
1208: l_external_attr_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1209:
1210: l_err_txt VARCHAR2(2000);
1211:
1212: BEGIN
1313: EGO_EXT_FWK_PUB.EXECUTE_FUNCTION
1314: (
1315: p_Action_Id => l_action_id
1316: ,p_pk_col_value_pairs => x_pk_column_name_value_pairs
1317: ,p_dtlevel_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_name, l_data_level_id))
1318: ,x_attributes_row_table => l_attributes_row_table
1319: ,x_attributes_data_table => l_attr_name_value_pairs
1320: ,x_external_attrs_value_pairs => x_external_attr_value_pairs
1321: ,x_return_status => x_return_status
2219: x_return_status VARCHAR2(100) := null;
2220: x_msg_data VARCHAR2(100) := null;
2221: x_errorcode NUMBER := null;
2222: x_msg_count NUMBER := 0;
2223: test_ext_param ego_col_name_value_pair_obj;
2224: l_attribute_category VARCHAR2(30);
2225: l_language_code_tbl po_tbl_varchar5;
2226: l_org_id NUMBER;
2227: l_records_exist VARCHAR2(1):= 'N';
2256: p_ext_attr_value => l_org_id,
2257: x_external_attr_value_pairs => x_external_attr_value_pairs
2258: );
2259:
2260: -- Form ego_col_name_value_pair_obj object
2261: -- This is useful for addresses
2262: IF p_attr_display_name_list IS NOT NULL AND p_attr_display_name_list.Count <> 0
2263: THEN
2264:
2264:
2265: x_external_attr_value_pairs.extend(p_attr_display_name_list.Count);
2266: FOR i IN 1..p_attr_display_name_list.Count
2267: LOOP
2268: x_external_attr_value_pairs(x_external_attr_value_pairs.Count - p_attr_display_name_list.Count+ i):= NEW ego_col_name_value_pair_obj('p_source_item',p_attr_display_name_list(i));
2269: END LOOP;
2270: END IF;
2271:
2272: fnd_msg_pub.Initialize;