DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_IMPORT_PVT

Line 1488: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;

1484: p_batch_id NUMBER)
1485: IS
1486: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1487: l_def_style_catg_option VARCHAR2(1);
1488: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;
1489: BEGIN
1490: RETCODE := '0';
1491: Debug_Conc_Log('Copy_New_Cat_Assgns_From_Style: Starting');
1492: l_def_style_catg_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ALTERNATE_CATALOG');

Line 4264: l_source_system_id := EGO_IMPORT_PVT.GET_PDH_SOURCE_SYSTEM_ID;

4260: SELECT SOURCE_SYSTEM_ID INTO l_source_system_id
4261: FROM EGO_IMPORT_BATCHES_B
4262: WHERE BATCH_ID = p_batch_id;
4263: EXCEPTION WHEN NO_DATA_FOUND THEN
4264: l_source_system_id := EGO_IMPORT_PVT.GET_PDH_SOURCE_SYSTEM_ID;
4265: END;
4266:
4267: Debug_Conc_Log('Default_Org_Assignments: l_source_system_id='||l_source_system_id);
4268: FOR i IN c_intf_records(l_source_system_id) LOOP

Line 5129: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;

5125: , p_item_number VARCHAR2
5126: )
5127: IS
5128: TYPE ROWID_TYPE_TBL IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
5129: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;
5130: l_row_id_tbl ROWID_TYPE_TBL;
5131: l_err_txt VARCHAR2(4000);
5132: l_ret_code VARCHAR2(100);
5133: BEGIN

Line 5565: ,EGO_IMPORT_PVT.get_pdh_source_system_id

5561: ,'SYNC'
5562: ,p_item_number
5563: ,p_organization_id
5564: ,NVL(l_grp_item_catalog_group_id,l_item_catalog_group_id)
5565: ,EGO_IMPORT_PVT.get_pdh_source_system_id
5566: ,null
5567: ,NVL(l_grp_row_identifier,l_row_identifier)
5568: ,p_attr_group_type
5569: ,p_attr_group_name