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_RCV_TXN_F_C dependencies on BIS_COMMON_PARAMETERS

Line 83: l_global_cur_code := bis_common_parameters.get_currency_code;

79: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
80: BEGIN
81: Errbuf :=NULL;
82: Retcode:=0;
83: l_global_cur_code := bis_common_parameters.get_currency_code;
84: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
85: l_srate_type := bis_common_parameters.get_secondary_rate_type;
86: l_batch_size := bis_common_parameters.get_batch_size(10);
87: l_rate_type := bis_common_parameters.get_rate_type;

Line 84: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;

80: BEGIN
81: Errbuf :=NULL;
82: Retcode:=0;
83: l_global_cur_code := bis_common_parameters.get_currency_code;
84: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
85: l_srate_type := bis_common_parameters.get_secondary_rate_type;
86: l_batch_size := bis_common_parameters.get_batch_size(10);
87: l_rate_type := bis_common_parameters.get_rate_type;
88: if(poa_currency_pkg.display_secondary_currency_yn)

Line 85: l_srate_type := bis_common_parameters.get_secondary_rate_type;

81: Errbuf :=NULL;
82: Retcode:=0;
83: l_global_cur_code := bis_common_parameters.get_currency_code;
84: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
85: l_srate_type := bis_common_parameters.get_secondary_rate_type;
86: l_batch_size := bis_common_parameters.get_batch_size(10);
87: l_rate_type := bis_common_parameters.get_rate_type;
88: if(poa_currency_pkg.display_secondary_currency_yn)
89: then

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

82: Retcode:=0;
83: l_global_cur_code := bis_common_parameters.get_currency_code;
84: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
85: l_srate_type := bis_common_parameters.get_secondary_rate_type;
86: l_batch_size := bis_common_parameters.get_batch_size(10);
87: l_rate_type := bis_common_parameters.get_rate_type;
88: if(poa_currency_pkg.display_secondary_currency_yn)
89: then
90: l_sec_cur_yn := 1;

Line 87: l_rate_type := bis_common_parameters.get_rate_type;

83: l_global_cur_code := bis_common_parameters.get_currency_code;
84: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
85: l_srate_type := bis_common_parameters.get_secondary_rate_type;
86: l_batch_size := bis_common_parameters.get_batch_size(10);
87: l_rate_type := bis_common_parameters.get_rate_type;
88: if(poa_currency_pkg.display_secondary_currency_yn)
89: then
90: l_sec_cur_yn := 1;
91: else

Line 96: l_dop := bis_common_parameters.get_degree_of_parallelism;

92: l_sec_cur_yn := 0;
93: end if;
94:
95: DBMS_APPLICATION_INFO.SET_MODULE(module_name => 'DBI RTX COLLECT', action_name => 'start');
96: l_dop := bis_common_parameters.get_degree_of_parallelism;
97: -- default DOP to profile in EDW_PARALLEL_SRC if 2nd param is not passed
98: l_go_ahead := bis_collection_utilities.setup('POARCVTXN');
99: if (g_init) then
100: execute immediate 'alter session set hash_area_size=104857600';

Line 116: l_start_date := To_char(bis_common_parameters.get_global_start_date

112: -- date is NULL.
113: -- --------------------------------------------
114:
115: IF(g_init) THEN
116: l_start_date := To_char(bis_common_parameters.get_global_start_date
117: , 'YYYY/MM/DD HH24:MI:SS');
118: d_start_date := bis_common_parameters.get_global_start_date;
119: ELSE
120: l_start_date := '''' || To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POARCVTXN')) - 0.004,'YYYY/MM/DD HH24:MI:SS') || '''';

Line 118: d_start_date := bis_common_parameters.get_global_start_date;

114:
115: IF(g_init) THEN
116: l_start_date := To_char(bis_common_parameters.get_global_start_date
117: , 'YYYY/MM/DD HH24:MI:SS');
118: d_start_date := bis_common_parameters.get_global_start_date;
119: ELSE
120: l_start_date := '''' || To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POARCVTXN')) - 0.004,'YYYY/MM/DD HH24:MI:SS') || '''';
121: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
122: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POARCVTXN')) - 0.004;

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

145: END IF;
146:
147: DBMS_APPLICATION_INFO.SET_ACTION('inc');
148: bis_collection_utilities.log('Populate INC table '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
149: l_glob_date := '''' || To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS') || '''';
150: d_glob_date := bis_common_parameters.get_global_start_date;
151:
152: if (g_init) then
153: insert /*+ append parallel(poa_dbi_rtx_inc) */ into

Line 150: d_glob_date := bis_common_parameters.get_global_start_date;

146:
147: DBMS_APPLICATION_INFO.SET_ACTION('inc');
148: bis_collection_utilities.log('Populate INC table '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
149: l_glob_date := '''' || To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS') || '''';
150: d_glob_date := bis_common_parameters.get_global_start_date;
151:
152: if (g_init) then
153: insert /*+ append parallel(poa_dbi_rtx_inc) */ into
154: poa_dbi_rtx_inc