APPS.OPI_DBI_WMS_RTP_F_C dependencies on BIS_COMMON_PARAMETERS

Line 63: l_dop := bis_common_parameters.get_degree_of_parallelism;

59: Errbuf :=NULL;
60: Retcode:=0;
61:
62: DBMS_APPLICATION_INFO.SET_MODULE(module_name => 'OPI DBI RTP COLLECT', action_name => 'start');
63: l_dop := bis_common_parameters.get_degree_of_parallelism;
64: -- default DOP to profile in EDW_PARALLEL_SRC if 2nd param is not passed
65: l_go_ahead := bis_collection_utilities.setup('OPIDBIRTP');
66: if (g_init) then
67: execute immediate 'alter session set hash_area_size=104857600';

Line 77: l_start_date := To_char(bis_common_parameters.get_global_start_date

73: END IF;
74: bis_collection_utilities.g_debug := FALSE;
75:
76: IF(g_init) THEN
77: l_start_date := To_char(bis_common_parameters.get_global_start_date
78: , 'YYYY/MM/DD HH24:MI:SS');
79: d_start_date := bis_common_parameters.get_global_start_date;
80: ELSE
81: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004,'YYYY/MM/DD HH24:MI:SS');

Line 79: d_start_date := bis_common_parameters.get_global_start_date;

75:
76: IF(g_init) THEN
77: l_start_date := To_char(bis_common_parameters.get_global_start_date
78: , 'YYYY/MM/DD HH24:MI:SS');
79: d_start_date := bis_common_parameters.get_global_start_date;
80: ELSE
81: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004,'YYYY/MM/DD HH24:MI:SS');
82: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
83: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004;

Line 92: l_glob_date := To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS');

88:
89: bis_collection_utilities.log( 'The collection range is from '||
90: l_start_date ||' to '|| l_end_date, 0);
91:
92: l_glob_date := To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS');
93: d_glob_date := bis_common_parameters.get_global_start_date;
94:
95: DBMS_APPLICATION_INFO.SET_ACTION('rates');
96: if (not(fnd_installation.get_app_info('OPI', l_status, l_industry, l_opi_schema))) then

Line 93: d_glob_date := bis_common_parameters.get_global_start_date;

89: bis_collection_utilities.log( 'The collection range is from '||
90: l_start_date ||' to '|| l_end_date, 0);
91:
92: l_glob_date := To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS');
93: d_glob_date := bis_common_parameters.get_global_start_date;
94:
95: DBMS_APPLICATION_INFO.SET_ACTION('rates');
96: if (not(fnd_installation.get_app_info('OPI', l_status, l_industry, l_opi_schema))) then
97: bis_collection_utilities.log('Error getting app info '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);