DBA Data[Home] [Help]

APPS.POA_DBI_PO_DIST_F_C dependencies on POA_CURRENCY_PKG

Line 99: if(poa_currency_pkg.display_secondary_currency_yn)

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
103: l_sec_cur_yn := 0;

Line 464: poa_currency_pkg.get_dbi_global_rate(

460: select
461: txn_cur_code,
462: func_cur_code,
463: rate_date,
464: poa_currency_pkg.get_dbi_global_rate(
465: l_rate_type,
466: func_cur_code,
467: rate_date,
468: txn_cur_code

Line 472: else poa_currency_pkg.get_dbi_sglobal_rate(

468: txn_cur_code
469: ) global_cur_conv_rate,
470: ( case when l_sec_cur_yn = 0
471: then null
472: else poa_currency_pkg.get_dbi_sglobal_rate(
473: l_srate_type,
474: func_cur_code,
475: rate_date,
476: txn_cur_code

Line 505: poa_currency_pkg.get_dbi_global_rate(

501: select
502: txn_cur_code,
503: func_cur_code,
504: rate_date,
505: poa_currency_pkg.get_dbi_global_rate(
506: l_rate_type,
507: func_cur_code,
508: rate_date,
509: txn_cur_code

Line 513: else poa_currency_pkg.get_dbi_sglobal_rate(

509: txn_cur_code
510: ) global_cur_conv_rate,
511: ( case when l_sec_cur_yn = 0
512: then null
513: else poa_currency_pkg.get_dbi_sglobal_rate(
514: l_srate_type,
515: func_cur_code,
516: rate_date,
517: txn_cur_code

Line 598: poa_currency_pkg.get_dbi_global_rate(

594: select
595: txn_cur_code,
596: func_cur_code,
597: rate_date,
598: poa_currency_pkg.get_dbi_global_rate(
599: l_rate_type,
600: func_cur_code,
601: rate_date,
602: txn_cur_code

Line 606: else poa_currency_pkg.get_dbi_sglobal_rate(

602: txn_cur_code
603: ) global_cur_conv_rate,
604: ( case when l_sec_cur_yn = 0
605: then null
606: else poa_currency_pkg.get_dbi_sglobal_rate(
607: l_srate_type,
608: func_cur_code,
609: rate_date,
610: txn_cur_code

Line 1197: IF (poa_currency_pkg.g_missing_cur) THEN

1193: || '. Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1194:
1195: /* missing currency handling */
1196:
1197: IF (poa_currency_pkg.g_missing_cur) THEN
1198: poa_currency_pkg.g_missing_cur := false;
1199: errbuf := 'There are missing currencies\n';
1200: RAISE_APPLICATION_ERROR (-20000, 'Error in INC table collection: ' || errbuf);
1201: END IF;

Line 1198: poa_currency_pkg.g_missing_cur := false;

1194:
1195: /* missing currency handling */
1196:
1197: IF (poa_currency_pkg.g_missing_cur) THEN
1198: poa_currency_pkg.g_missing_cur := false;
1199: errbuf := 'There are missing currencies\n';
1200: RAISE_APPLICATION_ERROR (-20000, 'Error in INC table collection: ' || errbuf);
1201: END IF;
1202: