APPS.POA_DBI_REQ_F_C dependencies on DBMS_APPLICATION_INFO

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

120: else
121: l_sec_cur_yn := 0;
122: end if;
123:
124: dbms_application_info.set_module(module_name => 'DBI REQ COLLECT', action_name => 'start');
125: l_dop := bis_common_parameters.get_degree_of_parallelism;
126: -- default DOP to profile in EDW_PARALLEL_SRC if 2nd param is not passed
127: l_go_ahead := bis_collection_utilities.setup('POAREQLN');
128:

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

173: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_RATES';
174: EXECUTE IMMEDIATE l_stmt;
175: END IF;
176:
177: dbms_application_info.set_action('inc');
178: bis_collection_utilities.log('Populate Currency Conversion table '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
179: l_glob_date := '''' || To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS') || '''';
180: d_glob_date := bis_common_parameters.get_global_start_date;
181:

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

599: rate_date;
600: END IF;
601:
602: COMMIT;
603: dbms_application_info.set_action('stats incremental');
604:
605: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
606: fnd_stats.gather_table_stats(ownname => l_poa_schema, tabname => 'POA_DBI_REQ_INC') ;
607: END IF;

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

646: );
647:
648:
649: COMMIT;
650: dbms_application_info.set_action('stats rates');
651:
652: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
653: fnd_stats.gather_table_stats(ownname => l_poa_schema,
654: tabname => 'POA_DBI_REQ_RATES') ;

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

670:
671: l_start_time := sysdate; -- should be the end date of the collection??
672: l_login := fnd_global.login_id;
673: l_user := fnd_global.user_id;
674: dbms_application_info.set_action('collect');
675: if (l_no_batch is NOT NULL) then
676: IF (g_init) THEN
677: bis_collection_utilities.log('Initial Load - using one batch approach, populate base fact. '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
678: INSERT /*+ append parallel(t) */ INTO poa_dbi_req_f t (

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

1731: s.unproc_ped_flag
1732: );
1733: COMMIT;
1734:
1735: DBMS_APPLICATION_INFO.SET_ACTION('batch ' || v_batch_no || ' done');
1736: END LOOP;
1737: END IF;
1738: END IF;
1739: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

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

1738: END IF;
1739: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1740: bis_collection_utilities.wrapup(TRUE, l_count, 'POA DBI REQ COLLECTION SUCEEDED', to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
1741: g_init := false;
1742: dbms_application_info.set_module(null, null);
1743: if ( l_num_corrupt_rows > 0 ) then
1744: fnd_concurrent.af_commit;
1745: l_ret_variable := fnd_concurrent.set_completion_status(
1746: status => 'WARNING',

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

1748: );
1749: end if;
1750: EXCEPTION
1751: WHEN others THEN
1752: dbms_application_info.set_action('error');
1753: errbuf:=sqlerrm;
1754: retcode:=sqlcode;
1755: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1756: 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'''));