[Home] [Help]
136: l_attr_category po_uda_ag_template_usages.ATTRIBUTE_CATEGORY%TYPE;
137:
138: l_contract_type VARCHAR2(200);
139: d_progress NUMBER;
140: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY;
141:
142: l_ext_table VARCHAR2(200);
143: l_sql_query VARCHAR2(4000);
144: l_mod_add_query VARCHAR2(2000);
381:
382: -- CURSORS FOR ALL CONTEXTS should be added later if needed
383:
384: l_entity_code VARCHAR2(200);
385: l_context_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
386: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
387: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
388: l_attr_grp_ids_list PO_TBL_NUMBER;
389: l_idc_type VARCHAR2(200);
434: d_progress := 60;
435: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_po_uda_usage_object, l_po_uda_usage_object_array', d_progress);
436:
437: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
438: l_context_array := EGO_COL_NAME_VALUE_PAIR_ARRAY();
439: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_context_array', d_progress);
440:
441: d_progress := 70;
442: if(c_get_usages_rec.attribute_category = 'PRICING') AND l_entity_code = 'PO_LINE_EXT_ATTRS' then
580: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;
581:
582: is_valid_entity_ag BOOLEAN := FALSE;
583:
584: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
585: l_entity_code VARCHAR2(200);
586: l_ag_type VARCHAR2(200);
587: l_ag_name VARCHAR2(200);
588: l_attr_list VARCHAR2(2000);
596: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
597:
598: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
599: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
600: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
601:
602: l_pk_col_name_value_pairs_ind NUMBER;
603: l_attr_name_value_pairs_ind NUMBER;
604: l_attributes_row_table_ind NUMBER;
1741:
1742: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1743: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1744:
1745: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1746:
1747: l_pk1_column_name VARCHAR2(200);
1748: l_pk2_column_name VARCHAR2(200);
1749: l_pk3_column_name VARCHAR2(200);
1886:
1887: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1888: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1889:
1890: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1891:
1892: l_pk1_column_name VARCHAR2(200);
1893: l_pk2_column_name VARCHAR2(200);
1894: l_pk3_column_name VARCHAR2(200);
1896: l_pk5_column_name VARCHAR2(200);
1897:
1898: l_base_object_name VARCHAR2(200);
1899:
1900: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1901:
1902: l_failed_row_id_list VARCHAR2(2000);
1903: l_entity_code VARCHAR2(200);
1904: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1955: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1956: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1957: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_attributes_row_table, l_attr_name_value_pairs', d_progress);
1958: d_progress := 80;
1959: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
1960: (
1961: EGO_COL_NAME_VALUE_PAIR_OBJ
1962: (
1963: 'UDA_TEMPLATE_ID'
2217: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;
2218:
2219: is_valid_entity_ag BOOLEAN := FALSE;
2220:
2221: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2222: l_entity_code VARCHAR2(200);
2223: l_ag_type VARCHAR2(200);
2224: l_ag_name VARCHAR2(200);
2225: l_attr_list VARCHAR2(2000);
2233: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
2234:
2235: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2236: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
2237: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2238:
2239: l_pk_col_name_value_pairs_ind NUMBER;
2240: l_attr_name_value_pairs_ind NUMBER;
2241: l_attributes_row_table_ind NUMBER;
2264:
2265: d_progress := 10;
2266:
2267: x_return_status := FND_API.G_RET_STS_SUCCESS;
2268: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2269: l_attr_group_request_table := EGO_ATTR_GROUP_REQUEST_TABLE();
2270:
2271: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized l_pk_column_name_value_pairs, l_attr_group_request_table', d_progress);
2272:
2504: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
2505: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
2506: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_attributes_row_table, l_attr_name_value_pairs' , d_progress);
2507:
2508: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2509: (
2510: EGO_COL_NAME_VALUE_PAIR_OBJ
2511: (
2512: 'UDA_TEMPLATE_ID'
2824: ,p_pk2_value IN NUMBER DEFAULT NULL
2825: ,p_pk3_value IN NUMBER DEFAULT NULL
2826: ,p_pk4_value IN NUMBER DEFAULT NULL
2827: ,p_pk5_value IN NUMBER DEFAULT NULL
2828: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
2829: )
2830: IS
2831: l_pk1_column_name VARCHAR2(200);
2832: l_pk2_column_name VARCHAR2(200);
2834: l_pk4_column_name VARCHAR2(200);
2835: l_pk5_column_name VARCHAR2(200);
2836: BEGIN
2837:
2838: x_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2839: BEGIN
2840: select o.pk1_column_name,
2841: o.pk2_column_name,
2842: o.pk3_column_name,
3160: -- the debug procedures didnt have the check to see if logging
3161: -- was enabled, hence added that check.
3162: PROCEDURE DEBUG
3163: (
3164: p_structure_array IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3165: ,p_progress IN NUMBER
3166: )
3167: IS
3168: l_structure_ind NUMBER;