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.OKI_DBI_LOAD_CLEB_PVT dependencies on BIS_COMMON_PARAMETERS

Line 307: g_global_start_date := bis_common_parameters.get_global_start_date;

303: g_0001_date := to_date('01-01-0001' ,'MM-DD-YYYY');
304: g_euro_start_date := to_date('01/01/1999','MM/DD/RRRR');
305:
306: l_run_date := sysdate;
307: g_global_start_date := bis_common_parameters.get_global_start_date;
308: g_no_of_workers := p_no_of_workers;
309:
310: IF( NVL(OKI_DBI_LOAD_CLEB_PVT.g_load_type,'INC LOAD') <> 'INITIAL LOAD')
311: THEN

Line 513: l_global_curr := BIS_COMMON_PARAMETERS.Get_Currency_Code;

509:
510:
511: l_start_date := OKI_DBI_LOAD_CLEB_PVT.G_Start_Date;
512: l_end_date := OKI_DBI_LOAD_CLEB_PVT.G_End_Date;
513: l_global_curr := BIS_COMMON_PARAMETERS.Get_Currency_Code;
514: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.G_Run_Date;
515: l_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
516: l_srate_type := bis_common_parameters.get_secondary_rate_type ;
517: l_annu_curr_code := CASE bis_common_parameters.get_annualized_currency_code

Line 515: l_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;

511: l_start_date := OKI_DBI_LOAD_CLEB_PVT.G_Start_Date;
512: l_end_date := OKI_DBI_LOAD_CLEB_PVT.G_End_Date;
513: l_global_curr := BIS_COMMON_PARAMETERS.Get_Currency_Code;
514: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.G_Run_Date;
515: l_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
516: l_srate_type := bis_common_parameters.get_secondary_rate_type ;
517: l_annu_curr_code := CASE bis_common_parameters.get_annualized_currency_code
518: WHEN 'PRIMARY' THEN 'Primary'
519: WHEN 'SECONDARY' THEN 'Secondary'

Line 516: l_srate_type := bis_common_parameters.get_secondary_rate_type ;

512: l_end_date := OKI_DBI_LOAD_CLEB_PVT.G_End_Date;
513: l_global_curr := BIS_COMMON_PARAMETERS.Get_Currency_Code;
514: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.G_Run_Date;
515: l_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
516: l_srate_type := bis_common_parameters.get_secondary_rate_type ;
517: l_annu_curr_code := CASE bis_common_parameters.get_annualized_currency_code
518: WHEN 'PRIMARY' THEN 'Primary'
519: WHEN 'SECONDARY' THEN 'Secondary'
520: ELSE 'Not Defined'

Line 517: l_annu_curr_code := CASE bis_common_parameters.get_annualized_currency_code

513: l_global_curr := BIS_COMMON_PARAMETERS.Get_Currency_Code;
514: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.G_Run_Date;
515: l_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
516: l_srate_type := bis_common_parameters.get_secondary_rate_type ;
517: l_annu_curr_code := CASE bis_common_parameters.get_annualized_currency_code
518: WHEN 'PRIMARY' THEN 'Primary'
519: WHEN 'SECONDARY' THEN 'Secondary'
520: ELSE 'Not Defined'
521: END;

Line 528: IF BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code IS NOT NULL

524: -- Added by Arun for secondary global currency conversion changes
525: IF(POA_CURRENCY_PKG.display_secondary_currency_yn)
526: THEN
527: -- Check if Sec currency Display profile is set
528: IF BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code IS NOT NULL
529: THEN l_sglobal_curr := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;
530: END IF;
531: END IF;
532: l_conv_type := bis_common_parameters.get_treasury_rate_type;

Line 529: THEN l_sglobal_curr := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;

525: IF(POA_CURRENCY_PKG.display_secondary_currency_yn)
526: THEN
527: -- Check if Sec currency Display profile is set
528: IF BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code IS NOT NULL
529: THEN l_sglobal_curr := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;
530: END IF;
531: END IF;
532: l_conv_type := bis_common_parameters.get_treasury_rate_type;
533:

Line 532: l_conv_type := bis_common_parameters.get_treasury_rate_type;

528: IF BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code IS NOT NULL
529: THEN l_sglobal_curr := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;
530: END IF;
531: END IF;
532: l_conv_type := bis_common_parameters.get_treasury_rate_type;
533:
534: rlog ('Treasury Rate Type is - '||NVL(l_conv_type, 'Not Defined'),1);
535:
536: IF l_conv_type is NULL THEN

Line 537: l_conv_type := bis_common_parameters.get_rate_type ;

533:
534: rlog ('Treasury Rate Type is - '||NVL(l_conv_type, 'Not Defined'),1);
535:
536: IF l_conv_type is NULL THEN
537: l_conv_type := bis_common_parameters.get_rate_type ;
538: END IF;
539:
540: rlog ('Primary Rate Type is - '||NVL(l_rate_type,'Not Defined'),1);
541: rlog ('Secondary Rate Type is - '||NVL(l_srate_type,'Not Defined'),1);

Line 555: SELECT NVL(BIS_COMMON_PARAMETERS.get_batch_size(BIS_COMMON_PARAMETERS.HIGH)

551: l_salesperson_code := 'SALESPERSON';
552: END IF ;
553:
554: rlog ('Sales Person Code - '||l_salesperson_code,1);
555: SELECT NVL(BIS_COMMON_PARAMETERS.get_batch_size(BIS_COMMON_PARAMETERS.HIGH)
556: , 1000)
557: INTO l_batch_size
558: FROM DUAL ;
559:

Line 1089: l_global_curr := bis_common_parameters.get_currency_code ;

1085:
1086:
1087: l_start_date := OKI_DBI_LOAD_CLEB_PVT.g_start_date ;
1088: l_end_date := OKI_DBI_LOAD_CLEB_PVT.g_end_date ;
1089: l_global_curr := bis_common_parameters.get_currency_code ;
1090: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
1091:
1092: -- Added by Arun for secondary global currency conversion changes
1093: IF(POA_CURRENCY_PKG.display_secondary_currency_yn)

Line 1096: IF BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code IS NOT NULL

1092: -- Added by Arun for secondary global currency conversion changes
1093: IF(POA_CURRENCY_PKG.display_secondary_currency_yn)
1094: THEN
1095: -- Check if Sec Currency display flag is set
1096: IF BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code IS NOT NULL
1097: THEN l_sglobal_curr := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;
1098: END IF;
1099: END IF;
1100:

Line 1097: THEN l_sglobal_curr := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;

1093: IF(POA_CURRENCY_PKG.display_secondary_currency_yn)
1094: THEN
1095: -- Check if Sec Currency display flag is set
1096: IF BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code IS NOT NULL
1097: THEN l_sglobal_curr := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;
1098: END IF;
1099: END IF;
1100:
1101: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');

Line 1108: SELECT NVL(BIS_COMMON_PARAMETERS.get_batch_size(BIS_COMMON_PARAMETERS.HIGH)

1104: ELSE
1105: l_salesperson_code := 'SALESPERSON';
1106: END IF ;
1107:
1108: SELECT NVL(BIS_COMMON_PARAMETERS.get_batch_size(BIS_COMMON_PARAMETERS.HIGH)
1109: , 1000)
1110: INTO l_batch_size
1111: FROM DUAL ;
1112:

Line 1152: l_rate_type := bis_common_parameters.get_treasury_rate_type;

1148: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_PREV_INC' ;
1149: EXECUTE IMMEDIATE l_sql_string ;
1150: rlog('Truncated Table OKI_DBI_PREV_INC ',1);
1151:
1152: l_rate_type := bis_common_parameters.get_treasury_rate_type;
1153:
1154: rlog ('Treasury Rate Type is '||NVL(l_rate_type,'Not Defined'),1);
1155:
1156: IF l_rate_type is NULL THEN

Line 1157: l_rate_type := bis_common_parameters.get_rate_type ;

1153:
1154: rlog ('Treasury Rate Type is '||NVL(l_rate_type,'Not Defined'),1);
1155:
1156: IF l_rate_type is NULL THEN
1157: l_rate_type := bis_common_parameters.get_rate_type ;
1158: END IF;
1159:
1160: rlog ('Primary Rate Type is '||NVL(bis_common_parameters.get_rate_type,'Not Defined'),1);
1161:

Line 1160: rlog ('Primary Rate Type is '||NVL(bis_common_parameters.get_rate_type,'Not Defined'),1);

1156: IF l_rate_type is NULL THEN
1157: l_rate_type := bis_common_parameters.get_rate_type ;
1158: END IF;
1159:
1160: rlog ('Primary Rate Type is '||NVL(bis_common_parameters.get_rate_type,'Not Defined'),1);
1161:
1162: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
1163:
1164:

Line 1814: l_rate_type := bis_common_parameters.get_rate_type ;

1810: l_length_date NUMBER ;
1811: l_length_contract_id NUMBER ;
1812:
1813: BEGIN
1814: l_rate_type := bis_common_parameters.get_rate_type ;
1815: l_srate_type := bis_common_parameters.get_secondary_rate_type ;
1816: l_global_currency := bis_common_parameters.get_currency_code;
1817: l_indenting := ' ' ;
1818: l_length_contract_number := 35 ;

Line 1815: l_srate_type := bis_common_parameters.get_secondary_rate_type ;

1811: l_length_contract_id NUMBER ;
1812:
1813: BEGIN
1814: l_rate_type := bis_common_parameters.get_rate_type ;
1815: l_srate_type := bis_common_parameters.get_secondary_rate_type ;
1816: l_global_currency := bis_common_parameters.get_currency_code;
1817: l_indenting := ' ' ;
1818: l_length_contract_number := 35 ;
1819: l_length_sts_code := 30 ;

Line 1816: l_global_currency := bis_common_parameters.get_currency_code;

1812:
1813: BEGIN
1814: l_rate_type := bis_common_parameters.get_rate_type ;
1815: l_srate_type := bis_common_parameters.get_secondary_rate_type ;
1816: l_global_currency := bis_common_parameters.get_currency_code;
1817: l_indenting := ' ' ;
1818: l_length_contract_number := 35 ;
1819: l_length_sts_code := 30 ;
1820: l_length_rate_type := 12 ;

Line 1829: l_sglobal_currency := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;

1825:
1826:
1827: IF(POA_CURRENCY_PKG.display_secondary_currency_yn)
1828: THEN
1829: l_sglobal_currency := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_Code;
1830: END IF;
1831:
1832: -- Section 1 Missing functional to global conversion rates
1833: rout(rpad('*' ,80 ,'*'), 0 ) ;

Line 2208: g_global_start_date := bis_common_parameters.get_global_start_date;

2204: BEGIN
2205:
2206:
2207:
2208: g_global_start_date := bis_common_parameters.get_global_start_date;
2209: g_4712_date := to_date('01/01/4712' , 'MM/DD/YYYY');
2210: l_login_id := FND_GLOBAL.login_id ;
2211: l_run_date := sysdate;
2212:

Line 2213: l_annu_curr_code := bis_common_parameters.get_annualized_currency_code;

2209: g_4712_date := to_date('01/01/4712' , 'MM/DD/YYYY');
2210: l_login_id := FND_GLOBAL.login_id ;
2211: l_run_date := sysdate;
2212:
2213: l_annu_curr_code := bis_common_parameters.get_annualized_currency_code;
2214: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */
2215: l_sglob_curr_code := 'SECONDARY';/*bis_common_parameters.get_secondary_currency_code;*/
2216:
2217: l_location := ' Inserting modified contract lines into OKI_DBI_CLE_B_OLD

Line 2214: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */

2210: l_login_id := FND_GLOBAL.login_id ;
2211: l_run_date := sysdate;
2212:
2213: l_annu_curr_code := bis_common_parameters.get_annualized_currency_code;
2214: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */
2215: l_sglob_curr_code := 'SECONDARY';/*bis_common_parameters.get_secondary_currency_code;*/
2216:
2217: l_location := ' Inserting modified contract lines into OKI_DBI_CLE_B_OLD
2218: table with worker '|| p_worker||' ';

Line 2215: l_sglob_curr_code := 'SECONDARY';/bis_common_parameters.get_secondary_currency_code;/

2211: l_run_date := sysdate;
2212:
2213: l_annu_curr_code := bis_common_parameters.get_annualized_currency_code;
2214: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */
2215: l_sglob_curr_code := 'SECONDARY';/*bis_common_parameters.get_secondary_currency_code;*/
2216:
2217: l_location := ' Inserting modified contract lines into OKI_DBI_CLE_B_OLD
2218: table with worker '|| p_worker||' ';
2219: rlog('Populating Staging Table OKI_DBI_CLE_B_OLD with updated/created Contracts : '

Line 4565: l_annu_curr_code := bis_common_parameters. get_annualized_currency_code;

4561: l_program_id := fnd_global.CONC_PROGRAM_ID;
4562: l_program_login_id := fnd_global.conc_login_id;
4563:
4564: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
4565: l_annu_curr_code := bis_common_parameters. get_annualized_currency_code;
4566: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */
4567: l_sglob_curr_code := 'SECONDARY';/*bis_common_parameters.get_secondary_currency_code;*/
4568:
4569: l_start_date := OKI_DBI_LOAD_CLEB_PVT.g_start_date ;

Line 4566: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */

4562: l_program_login_id := fnd_global.conc_login_id;
4563:
4564: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
4565: l_annu_curr_code := bis_common_parameters. get_annualized_currency_code;
4566: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */
4567: l_sglob_curr_code := 'SECONDARY';/*bis_common_parameters.get_secondary_currency_code;*/
4568:
4569: l_start_date := OKI_DBI_LOAD_CLEB_PVT.g_start_date ;
4570: l_end_date := OKI_DBI_LOAD_CLEB_PVT.g_end_date ;

Line 4567: l_sglob_curr_code := 'SECONDARY';/bis_common_parameters.get_secondary_currency_code;/

4563:
4564: l_sysdate := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
4565: l_annu_curr_code := bis_common_parameters. get_annualized_currency_code;
4566: l_glob_curr_code := 'PRIMARY';/* BUg 4015406 bis_common_parameters.get_currency_code; */
4567: l_sglob_curr_code := 'SECONDARY';/*bis_common_parameters.get_secondary_currency_code;*/
4568:
4569: l_start_date := OKI_DBI_LOAD_CLEB_PVT.g_start_date ;
4570: l_end_date := OKI_DBI_LOAD_CLEB_PVT.g_end_date ;
4571: l_run_date := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;