APPS.POA_DBI_NEG_F_C dependencies on DBMS_APPLICATION_INFO

Line 84: dbms_application_info.set_module(module_name => 'DBI NEGOTIATION COLLECT', action_name => 'start');

80: else
81: l_sec_cur_yn := 0;
82: end if;
83:
84: dbms_application_info.set_module(module_name => 'DBI NEGOTIATION COLLECT', action_name => 'start');
85: l_dop := bis_common_parameters.get_degree_of_parallelism;
86: -- default DOP to profile in EDW_PARALLEL_SRC if 2nd param is not passed
87: l_go_ahead := bis_collection_utilities.setup('POADBINEGF');
88:

Line 136: dbms_application_info.set_action('inc');

132: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_RATES';
133: EXECUTE IMMEDIATE l_stmt;
134: END IF;
135:
136: dbms_application_info.set_action('inc');
137: bis_collection_utilities.log('Populate Currency Conversion table '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
138: l_glob_date := '''' || To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS') || '''';
139: d_glob_date := bis_common_parameters.get_global_start_date;
140:

Line 239: dbms_application_info.set_action('stats incremental');

235: )
236: );
237: END IF;
238: COMMIT;
239: dbms_application_info.set_action('stats incremental');
240:
241: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
242: fnd_stats.gather_table_stats(ownname => l_poa_schema, tabname => 'POA_DBI_NEG_INC') ;
243: END IF;

Line 286: dbms_application_info.set_action('stats rates');

282: );
283:
284: COMMIT;
285:
286: dbms_application_info.set_action('stats rates');
287:
288: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
289: fnd_stats.gather_table_stats(ownname => l_poa_schema,
290: tabname => 'POA_DBI_NEG_RATES') ;

Line 310: dbms_application_info.set_action('collect');

306:
307: l_start_time := sysdate; -- should be the end date of the collection??
308: l_login := fnd_global.login_id;
309: l_user := fnd_global.user_id;
310: dbms_application_info.set_action('collect');
311: IF (l_no_batch is NOT NULL) then
312: IF (g_init) THEN
313: bis_collection_utilities.log('Initial Load - using one batch approach, populate base fact. '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
314: INSERT /*+ append parallel(t) */ INTO poa_dbi_neg_f t (

Line 1012: DBMS_APPLICATION_INFO.SET_ACTION('batch ' || v_batch_no || ' done');

1008: l_user,
1009: l_start_time
1010: );
1011: COMMIT;
1012: DBMS_APPLICATION_INFO.SET_ACTION('batch ' || v_batch_no || ' done');
1013: END LOOP;
1014: END IF;
1015: END IF;
1016: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

Line 1019: dbms_application_info.set_module(null, null);

1015: END IF;
1016: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1017: bis_collection_utilities.wrapup(TRUE, l_count, 'POA_DBI_NEG_F COLLECTION SUCEEDED', to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
1018: g_init := false;
1019: dbms_application_info.set_module(null, null);
1020: EXCEPTION
1021: WHEN others THEN
1022: dbms_application_info.set_action('error');
1023: errbuf:=sqlerrm;

Line 1022: dbms_application_info.set_action('error');

1018: g_init := false;
1019: dbms_application_info.set_module(null, null);
1020: EXCEPTION
1021: WHEN others THEN
1022: dbms_application_info.set_action('error');
1023: errbuf:=sqlerrm;
1024: retcode:=sqlcode;
1025: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1026: bis_collection_utilities.wrapup(FALSE, l_count, errbuf||':'||retcode, to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), to_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));