DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_ITEM_ASSOCIATIONS_PUB

Line 1658: l_data_level_names EGO_ITEM_ASSOCIATIONS_PUB.VARCHAR2_TBL_TYPE;

1654: l_copy_cat VARCHAR2(1);
1655: l_copy_sup VARCHAR2(1);
1656: l_copy_sup_site VARCHAR2(1);
1657: l_copy_sup_site_org VARCHAR2(1);
1658: l_data_level_names EGO_ITEM_ASSOCIATIONS_PUB.VARCHAR2_TBL_TYPE;
1659: l_src_item_id NUMBER;
1660: l_msg_count NUMBER;
1661: l_cntr NUMBER;
1662: BEGIN

Line 1967: EGO_ITEM_ASSOCIATIONS_PUB.copy_associations_to_items

1963: AND COPY_ITEM_ID IS NOT NULL
1964: AND ROWNUM = 1;
1965:
1966: Debug_Conc_Log('Process_Copy_Options_For_Items: l_src_item_id='||l_src_item_id);
1967: EGO_ITEM_ASSOCIATIONS_PUB.copy_associations_to_items
1968: (
1969: p_api_version => 1.0
1970: ,p_batch_id => p_batch_id
1971: ,p_src_item_id => l_src_item_id

Line 1977: 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);

1973: ,x_return_status => l_ret_status
1974: ,x_msg_count => l_msg_count
1975: ,x_msg_data => l_err_msg
1976: );
1977: 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);
1978: IF l_ret_status = 'S' THEN
1979: RETCODE := '0';
1980: ERRBUF := NULL;
1981: ELSIF l_ret_status = 'E' THEN

Line 2018: EGO_ITEM_ASSOCIATIONS_PUB.copy_from_style_to_SKUs

2014: l_msg_data VARCHAR2(4000);
2015: BEGIN
2016: -- call defaulting API for Supplier Intersections
2017: Debug_Conc_Log('Default_Supplier_Intersections: Starting copy_from_style_to_SKUs');
2018: EGO_ITEM_ASSOCIATIONS_PUB.copy_from_style_to_SKUs
2019: (
2020: p_api_version => 1.0
2021: ,p_batch_id => p_batch_id
2022: ,x_return_status => l_return_status

Line 2041: EGO_ITEM_ASSOCIATIONS_PUB.Copy_To_Packs

2037: RETURN;
2038: END IF;
2039:
2040: Debug_Conc_Log('Default_Supplier_Intersections: Calling Copy_To_Packs');
2041: EGO_ITEM_ASSOCIATIONS_PUB.Copy_To_Packs
2042: (
2043: p_api_version => 1.0
2044: ,p_batch_id => p_batch_id
2045: ,x_return_status => l_return_status

Line 3965: EGO_ITEM_ASSOCIATIONS_PUB.Pre_Process

3961:
3962: Debug_Conc_Log('Preprocess_Import: l_enabled_for_data_pool='||l_enabled_for_data_pool);
3963:
3964: Debug_Conc_Log('Preprocess_Import: Calling Pre_Process of Intersections ');
3965: EGO_ITEM_ASSOCIATIONS_PUB.Pre_Process
3966: (
3967: p_api_version => 1.0,
3968: p_batch_id => p_batch_id,
3969: x_return_status => l_return_status_str,