APPS.POA_DBI_PO_DIST_F_C dependencies on DBMS_APPLICATION_INFO

Line 106: DBMS_APPLICATION_INFO.SET_MODULE(module_name => 'DBI POD COLLECT', action_name => 'start');

102: else
103: l_sec_cur_yn := 0;
104: end if;
105:
106: DBMS_APPLICATION_INFO.SET_MODULE(module_name => 'DBI POD COLLECT', action_name => 'start');
107: l_dop := bis_common_parameters.get_degree_of_parallelism;
108: -- default DOP to profile in EDW_PARALLEL_SRC if 2nd param is not passed
109: l_go_ahead := bis_collection_utilities.setup('POAPODIST');
110: if (g_init) then

Line 158: DBMS_APPLICATION_INFO.SET_ACTION('inc');

154: EXECUTE IMMEDIATE l_stmt;
155: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_DETAILS';
156: EXECUTE IMMEDIATE l_stmt;
157:
158: DBMS_APPLICATION_INFO.SET_ACTION('inc');
159: bis_collection_utilities.log('Populate INC table '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
160: l_glob_date := To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS');
161: d_glob_date := bis_common_parameters.get_global_start_date;
162:

Line 448: DBMS_APPLICATION_INFO.SET_ACTION('stats incremental');

444: end if;
445:
446: COMMIT;
447:
448: DBMS_APPLICATION_INFO.SET_ACTION('stats incremental');
449:
450: fnd_stats.gather_table_stats(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_POD_INC');
451:
452: insert /*+ APPEND */ into poa_dbi_pod_rates

Line 1182: DBMS_APPLICATION_INFO.SET_ACTION('stats rates');

1178:
1179: COMMIT;
1180:
1181:
1182: DBMS_APPLICATION_INFO.SET_ACTION('stats rates');
1183:
1184: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1185: TABNAME => 'POA_DBI_POD_RATES') ;
1186: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,

Line 1216: DBMS_APPLICATION_INFO.SET_ACTION('collect');

1212:
1213: l_start_time := sysdate;
1214: l_login := fnd_global.login_id;
1215: l_user := fnd_global.user_id;
1216: DBMS_APPLICATION_INFO.SET_ACTION('collect');
1217:
1218: if (l_no_batch is NOT NULL) then
1219: IF (g_init) THEN
1220: bis_collection_utilities.log('Initial Load - populate match table. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

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

2526: COMMIT;
2527: bis_collection_utilities.log('best price calculation hit='|| poa_dbi_savings_pkg.g_hit_count, 2);
2528: poa_dbi_savings_pkg.g_hit_count := 0;
2529:
2530: DBMS_APPLICATION_INFO.SET_ACTION('batch ' || v_batch_no || ' done');
2531: END LOOP;
2532: END IF;
2533: END IF;
2534: /*

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

2544: and pll.approved_date >= pod.creation_date)
2545: where f.po_distribution_id in (select primary_key from poa_dbi_pod_inc
2546: where batch_id = v_batch_no);
2547: COMMIT;
2548: DBMS_APPLICATION_INFO.SET_ACTION('EAD batch ' || v_batch_no || ' done');
2549: END LOOP;
2550: END IF;
2551: */
2552:

Line 2556: DBMS_APPLICATION_INFO.set_module(NULL, NULL);

2552:
2553: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
2554: bis_collection_utilities.wrapup(TRUE, l_count, 'POA DBI PO DIST COLLECTION SUCEEDED', To_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
2555: g_init := false;
2556: DBMS_APPLICATION_INFO.set_module(NULL, NULL);
2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: DBMS_APPLICATION_INFO.SET_ACTION('error');
2560: errbuf:=sqlerrm;

Line 2559: DBMS_APPLICATION_INFO.SET_ACTION('error');

2555: g_init := false;
2556: DBMS_APPLICATION_INFO.set_module(NULL, NULL);
2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: DBMS_APPLICATION_INFO.SET_ACTION('error');
2560: errbuf:=sqlerrm;
2561: retcode:=sqlcode;
2562: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
2563: -- dbms_output.put_line(l_start_date || l_end_date);