DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_ITEM_ASSOCIATIONS_PUB

Line 1828: l_data_level_names EGO_ITEM_ASSOCIATIONS_PUB.VARCHAR2_TBL_TYPE;

1824: l_copy_cat VARCHAR2(1);
1825: l_copy_sup VARCHAR2(1);
1826: l_copy_sup_site VARCHAR2(1);
1827: l_copy_sup_site_org VARCHAR2(1);
1828: l_data_level_names EGO_ITEM_ASSOCIATIONS_PUB.VARCHAR2_TBL_TYPE;
1829: l_src_item_id NUMBER;
1830: l_msg_count NUMBER;
1831: l_cntr NUMBER;
1832: BEGIN

Line 2137: EGO_ITEM_ASSOCIATIONS_PUB.copy_associations_to_items

2133: AND COPY_ITEM_ID IS NOT NULL
2134: AND ROWNUM = 1;
2135:
2136: Debug_Conc_Log('Process_Copy_Options_For_Items: l_src_item_id='||l_src_item_id);
2137: EGO_ITEM_ASSOCIATIONS_PUB.copy_associations_to_items
2138: (
2139: p_api_version => 1.0
2140: ,p_batch_id => p_batch_id
2141: ,p_src_item_id => l_src_item_id

Line 2147: Debug_Conc_Log('Process_Copy_Options_For_Items: Done EGO_ITEM_ASSOCIATIONS_PUB.copy_associations_to_items - l_return_status, l_msg_data='||l_ret_status||','||l_err_msg);

2143: ,x_return_status => l_ret_status
2144: ,x_msg_count => l_msg_count
2145: ,x_msg_data => l_err_msg
2146: );
2147: Debug_Conc_Log('Process_Copy_Options_For_Items: Done EGO_ITEM_ASSOCIATIONS_PUB.copy_associations_to_items - l_return_status, l_msg_data='||l_ret_status||','||l_err_msg);
2148: IF l_ret_status = 'S' THEN
2149: RETCODE := '0';
2150: ERRBUF := NULL;
2151: ELSIF l_ret_status = 'E' THEN

Line 2189: EGO_ITEM_ASSOCIATIONS_PUB.copy_from_style_to_SKUs

2185: l_msg_data VARCHAR2(4000);
2186: BEGIN
2187: -- call defaulting API for Supplier Intersections
2188: Debug_Conc_Log('Default_Supplier_Intersections: Starting copy_from_style_to_SKUs');
2189: EGO_ITEM_ASSOCIATIONS_PUB.copy_from_style_to_SKUs
2190: (
2191: p_api_version => 1.0
2192: ,p_batch_id => p_batch_id
2193: ,x_return_status => l_return_status

Line 2213: EGO_ITEM_ASSOCIATIONS_PUB.Copy_To_Packs

2209: RETURN;
2210: END IF;
2211:
2212: Debug_Conc_Log('Default_Supplier_Intersections: Calling Copy_To_Packs');
2213: EGO_ITEM_ASSOCIATIONS_PUB.Copy_To_Packs
2214: (
2215: p_api_version => 1.0
2216: ,p_batch_id => p_batch_id
2217: ,x_return_status => l_return_status

Line 4600: EGO_ITEM_ASSOCIATIONS_PUB.Pre_Process

4596:
4597: Debug_Conc_Log('Preprocess_Import: l_enabled_for_data_pool='||l_enabled_for_data_pool);
4598:
4599: Debug_Conc_Log('Preprocess_Import: Calling Pre_Process of Intersections ');
4600: EGO_ITEM_ASSOCIATIONS_PUB.Pre_Process
4601: (
4602: p_api_version => 1.0,
4603: p_batch_id => l_batch_id, -- bug 12693246 changed from p_batch_id to l_batch_id
4604: x_return_status => l_return_status_str,