68: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
69: BEGIN
70: errbuf :=NULL;
71: retcode:=0;
72: l_batch_size := bis_common_parameters.get_batch_size(10);
73: l_rate_type := bis_common_parameters.get_rate_type;
74: l_global_cur_code := bis_common_parameters.get_currency_code;
75: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
76: l_srate_type := bis_common_parameters.get_secondary_rate_type;
69: BEGIN
70: errbuf :=NULL;
71: retcode:=0;
72: l_batch_size := bis_common_parameters.get_batch_size(10);
73: l_rate_type := bis_common_parameters.get_rate_type;
74: l_global_cur_code := bis_common_parameters.get_currency_code;
75: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
76: l_srate_type := bis_common_parameters.get_secondary_rate_type;
77: if(poa_currency_pkg.display_secondary_currency_yn)
70: errbuf :=NULL;
71: retcode:=0;
72: l_batch_size := bis_common_parameters.get_batch_size(10);
73: l_rate_type := bis_common_parameters.get_rate_type;
74: l_global_cur_code := bis_common_parameters.get_currency_code;
75: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
76: l_srate_type := bis_common_parameters.get_secondary_rate_type;
77: if(poa_currency_pkg.display_secondary_currency_yn)
78: then
71: retcode:=0;
72: l_batch_size := bis_common_parameters.get_batch_size(10);
73: l_rate_type := bis_common_parameters.get_rate_type;
74: l_global_cur_code := bis_common_parameters.get_currency_code;
75: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
76: l_srate_type := bis_common_parameters.get_secondary_rate_type;
77: if(poa_currency_pkg.display_secondary_currency_yn)
78: then
79: l_sec_cur_yn := 1;
72: l_batch_size := bis_common_parameters.get_batch_size(10);
73: l_rate_type := bis_common_parameters.get_rate_type;
74: l_global_cur_code := bis_common_parameters.get_currency_code;
75: l_sglobal_cur_code := bis_common_parameters.get_secondary_currency_code;
76: l_srate_type := bis_common_parameters.get_secondary_rate_type;
77: if(poa_currency_pkg.display_secondary_currency_yn)
78: then
79: l_sec_cur_yn := 1;
80: else
81: l_sec_cur_yn := 0;
82: end if;
83:
84: dbms_application_info.set_module(module_name => 'DBI NEGOTIATION COLLECT', action_name => 'start');
85: l_dop := bis_common_parameters.get_degree_of_parallelism;
86: -- default DOP to profile in EDW_PARALLEL_SRC if 2nd param is not passed
87: l_go_ahead := bis_collection_utilities.setup('POADBINEGF');
88:
89: IF (g_init)
103: -- date is NULL.
104: -- --------------------------------------------
105:
106: IF (g_init) THEN
107: l_start_date := To_char(bis_common_parameters.get_global_start_date,'YYYY/MM/DD HH24:MI:SS');
108: d_start_date := bis_common_parameters.get_global_start_date;
109: ELSE
110: l_start_date := '''' || to_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POADBINEGF'))-0.004,'YYYY/MM/DD HH24:MI:SS') || '''';
111: /* if there is not a success record in the bis refresh log, then we have to get the global start date as l_start_date*/
104: -- --------------------------------------------
105:
106: IF (g_init) THEN
107: l_start_date := To_char(bis_common_parameters.get_global_start_date,'YYYY/MM/DD HH24:MI:SS');
108: d_start_date := bis_common_parameters.get_global_start_date;
109: ELSE
110: l_start_date := '''' || to_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POADBINEGF'))-0.004,'YYYY/MM/DD HH24:MI:SS') || '''';
111: /* if there is not a success record in the bis refresh log, then we have to get the global start date as l_start_date*/
112: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POADBINEGF'))-0.004;
134: END IF;
135:
136: dbms_application_info.set_action('inc');
137: bis_collection_utilities.log('Populate Currency Conversion table '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
138: l_glob_date := '''' || To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS') || '''';
139: d_glob_date := bis_common_parameters.get_global_start_date;
140:
141: IF (g_init) THEN
142: INSERT /*+ append parallel(poa_dbi_neg_inc) */ INTO poa_dbi_neg_inc
135:
136: dbms_application_info.set_action('inc');
137: bis_collection_utilities.log('Populate Currency Conversion table '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
138: l_glob_date := '''' || To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS') || '''';
139: d_glob_date := bis_common_parameters.get_global_start_date;
140:
141: IF (g_init) THEN
142: INSERT /*+ append parallel(poa_dbi_neg_inc) */ INTO poa_dbi_neg_inc
143: (