[Home] [Help]
1542: -- Bug 10263673 : Start
1543: -- The below call to the api is needed as, the row idents need to be cleaned up after the template/copy attrs is done
1544: -- and before the attr level defaulting.
1545: Debug_Conc_Log('Process_Copy_Options_For_UDAs: Calling Clean_Up_UDA_Row_Idents ');
1546: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
1547: p_batch_id => p_batch_id,
1548: p_process_status => 2,
1549: p_ignore_item_num_upd => FND_API.G_TRUE,
1550: p_commit => FND_API.G_FALSE );
1654: p_batch_id NUMBER)
1655: IS
1656: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1657: l_def_style_catg_option VARCHAR2(1);
1658: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;
1659: BEGIN
1660: RETCODE := '0';
1661: Debug_Conc_Log('Copy_New_Cat_Assgns_From_Style: Starting');
1662: l_def_style_catg_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ALTERNATE_CATALOG');
2510: -- building SQLs for Defaulting of Item Revision Level UDAs for newly created revisions
2511: -- ER 9489112, only Defaulting of Item Rev level UDAs when Change Order enabled and AddAllItemToChangeOrder option = Y
2512: -- since java code will default Item Rev level UDAs later
2513: --pnagasur:Modified below query for Bug 13394823
2514: l_add_all_to_cm := EGO_IMPORT_PVT.getAddAllToChangeFlag(p_batch_id => p_batch_id);
2515: IF l_add_all_to_cm <> 'Y' THEN
2516: l_src_sql := q'#
2517: SELECT
2518: ROWNUM AS ROW_IDENTIFIER,
4871: /* Fix for bug#9678667 : End */
4872:
4873: -- Bug 9678667 : Start
4874: Debug_Conc_Log('Preprocess_Import: Calling Clean_Up_UDA_Row_Idents ');
4875: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
4876: p_batch_id => p_batch_id,
4877: p_process_status => 2,
4878: p_ignore_item_num_upd => FND_API.G_TRUE,
4879: p_commit => FND_API.G_FALSE );
4957: SELECT SOURCE_SYSTEM_ID INTO l_source_system_id
4958: FROM EGO_IMPORT_BATCHES_B
4959: WHERE BATCH_ID = p_batch_id;
4960: EXCEPTION WHEN NO_DATA_FOUND THEN
4961: l_source_system_id := EGO_IMPORT_PVT.GET_PDH_SOURCE_SYSTEM_ID;
4962: END;
4963:
4964: Debug_Conc_Log('Default_Org_Assignments: l_source_system_id='||l_source_system_id);
4965: FOR i IN c_intf_records(l_source_system_id) LOOP
5875: , p_item_number VARCHAR2
5876: )
5877: IS
5878: TYPE ROWID_TYPE_TBL IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
5879: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;
5880: l_row_id_tbl ROWID_TYPE_TBL;
5881: l_err_txt VARCHAR2(4000);
5882: l_ret_code VARCHAR2(100);
5883: BEGIN
6345: ,'SYNC'
6346: ,p_item_number
6347: ,p_organization_id
6348: ,NVL(l_grp_item_catalog_group_id,l_item_catalog_group_id)
6349: ,EGO_IMPORT_PVT.get_pdh_source_system_id
6350: ,null
6351: ,NVL(l_grp_row_identifier,l_row_identifier)
6352: ,p_attr_group_type
6353: ,p_attr_group_name