DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_IMPORT_OPTION_SETS

Line 3850: FROM EGO_IMPORT_OPTION_SETS

3846: BEGIN
3847: Debug_Conc_Log('Validate_Timestamp_With_Prod: Starting p_batch_id='||p_batch_id);
3848: BEGIN
3849: SELECT NVL(ENABLED_FOR_DATA_POOL, 'N') INTO l_enabled_for_data_pool
3850: FROM EGO_IMPORT_OPTION_SETS
3851: WHERE BATCH_ID = p_batch_id;
3852: EXCEPTION WHEN OTHERS THEN
3853: Debug_Conc_Log('Validate_Timestamp_With_Prod: exception='||SQLERRM);
3854: RETCODE := '0';

Line 4591: FROM EGO_IMPORT_OPTION_SETS

4587:
4588: BEGIN
4589: SELECT NVL(ENABLED_FOR_DATA_POOL, 'N')
4590: INTO l_enabled_for_data_pool
4591: FROM EGO_IMPORT_OPTION_SETS
4592: WHERE BATCH_ID = l_batch_id; -- bug 12693246 changed from p_batch_id to l_batch_id
4593: EXCEPTION WHEN OTHERS THEN
4594: l_enabled_for_data_pool := 'N';
4595: END;

Line 6462: FROM EGO_IMPORT_OPTION_SETS

6458: BEGIN
6459: Debug_Conc_Log('Validate_Timestamp_In_Batch: Starting p_batch_id='||p_batch_id);
6460: BEGIN
6461: SELECT NVL(ENABLED_FOR_DATA_POOL, 'N') INTO l_enabled_for_data_pool
6462: FROM EGO_IMPORT_OPTION_SETS
6463: WHERE BATCH_ID = p_batch_id;
6464: EXCEPTION WHEN OTHERS THEN
6465: Debug_Conc_Log('Validate_Timestamp_In_Batch: exception='||SQLERRM);
6466: RETCODE := '0';

Line 6757: FROM EGO_IMPORT_OPTION_SETS

6753: BEGIN
6754: Debug_Conc_Log('Update_Timestamp_In_Prod: Starting p_batch_id='||p_batch_id);
6755: BEGIN
6756: SELECT NVL(ENABLED_FOR_DATA_POOL, 'N') INTO l_enabled_for_data_pool
6757: FROM EGO_IMPORT_OPTION_SETS
6758: WHERE BATCH_ID = p_batch_id;
6759: EXCEPTION WHEN OTHERS THEN
6760: Debug_Conc_Log('Update_Timestamp_In_Prod: exception='||SQLERRM);
6761: RETCODE := '0';