eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_DBI_PO_DIST_F_C dependencies on BIS_COMMON_PARAMETERS

Line 94: l_global_cur_code := bis_common_parameters.get_currency_code;

90: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
91: BEGIN
92: Errbuf :=NULL;
93: Retcode:=0;
94: l_global_cur_code := bis_common_parameters.get_currency_code;
95: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
96: l_srate_type := bis_common_parameters.get_secondary_rate_type;
97: l_batch_size := bis_common_parameters.get_batch_size(10);
98: l_rate_type := bis_common_parameters.get_rate_type;

Line 95: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;

91: BEGIN
92: Errbuf :=NULL;
93: Retcode:=0;
94: l_global_cur_code := bis_common_parameters.get_currency_code;
95: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
96: l_srate_type := bis_common_parameters.get_secondary_rate_type;
97: l_batch_size := bis_common_parameters.get_batch_size(10);
98: l_rate_type := bis_common_parameters.get_rate_type;
99: if(poa_currency_pkg.display_secondary_currency_yn)

Line 96: l_srate_type := bis_common_parameters.get_secondary_rate_type;

92: Errbuf :=NULL;
93: Retcode:=0;
94: l_global_cur_code := bis_common_parameters.get_currency_code;
95: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
96: l_srate_type := bis_common_parameters.get_secondary_rate_type;
97: l_batch_size := bis_common_parameters.get_batch_size(10);
98: l_rate_type := bis_common_parameters.get_rate_type;
99: if(poa_currency_pkg.display_secondary_currency_yn)
100: then

Line 97: l_batch_size := bis_common_parameters.get_batch_size(10);

93: Retcode:=0;
94: l_global_cur_code := bis_common_parameters.get_currency_code;
95: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
96: l_srate_type := bis_common_parameters.get_secondary_rate_type;
97: l_batch_size := bis_common_parameters.get_batch_size(10);
98: l_rate_type := bis_common_parameters.get_rate_type;
99: if(poa_currency_pkg.display_secondary_currency_yn)
100: then
101: l_sec_cur_yn := 1;

Line 98: l_rate_type := bis_common_parameters.get_rate_type;

94: l_global_cur_code := bis_common_parameters.get_currency_code;
95: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
96: l_srate_type := bis_common_parameters.get_secondary_rate_type;
97: l_batch_size := bis_common_parameters.get_batch_size(10);
98: l_rate_type := bis_common_parameters.get_rate_type;
99: if(poa_currency_pkg.display_secondary_currency_yn)
100: then
101: l_sec_cur_yn := 1;
102: else

Line 107: l_dop := bis_common_parameters.get_degree_of_parallelism;

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
111: execute immediate 'alter session set hash_area_size=104857600';

Line 123: l_start_date := To_char(bis_common_parameters.get_global_start_date

119: bis_collection_utilities.g_debug := FALSE;
120:
121:
122: IF(g_init) THEN
123: l_start_date := To_char(bis_common_parameters.get_global_start_date
124: , 'YYYY/MM/DD HH24:MI:SS');
125: d_start_date := bis_common_parameters.get_global_start_date;
126: ELSE
127: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAPODIST')) - 0.004,'YYYY/MM/DD HH24:MI:SS');

Line 125: d_start_date := bis_common_parameters.get_global_start_date;

121:
122: IF(g_init) THEN
123: l_start_date := To_char(bis_common_parameters.get_global_start_date
124: , 'YYYY/MM/DD HH24:MI:SS');
125: d_start_date := bis_common_parameters.get_global_start_date;
126: ELSE
127: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAPODIST')) - 0.004,'YYYY/MM/DD HH24:MI:SS');
128: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
129: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAPODIST')) - 0.004;

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

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:
163: if(g_init) then
164: insert /*+ append parallel(poa_dbi_pod_inc) */ into poa_dbi_pod_inc

Line 161: d_glob_date := bis_common_parameters.get_global_start_date;

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:
163: if(g_init) then
164: insert /*+ append parallel(poa_dbi_pod_inc) */ into poa_dbi_pod_inc
165: ( primary_key,