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

Line 1083: IF (NOT BIS_COMMON_PARAMETERS.CHECK_GLOBAL_PARAMETERS(l_list)) THEN

1079: l_list(1) := 'BIS_GLOBAL_START_DATE';
1080: l_list(2) := 'BIS_PRIMARY_CURRENCY_CODE';
1081: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';
1082:
1083: IF (NOT BIS_COMMON_PARAMETERS.CHECK_GLOBAL_PARAMETERS(l_list)) THEN
1084: BIS_COLLECTION_UTILITIES.put_line('Missing global parameters. Please setup global_start_date and primary_currency_code first.');
1085: retcode := g_error;
1086: errbuf := 'Program stops.';
1087: RAISE intialization_exception;

Line 1098: SELECT BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE INTO g_global_start_date FROM DUAL;

1094: g_sysdate := trunc(sysdate);
1095: g_created_by := nvl(fnd_global.user_id, -1);
1096: g_last_update_login := nvl(fnd_global.login_id, -1);
1097: g_last_updated_by := nvl(fnd_global.user_id, -1);
1098: SELECT BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE INTO g_global_start_date FROM DUAL;
1099: SELECT bis_common_parameters.get_currency_code INTO g_global_currency_code FROM dual;
1100: IF g_global_currency_code IS NULL THEN
1101: RAISE intialization_exception;
1102: END IF;

Line 1099: SELECT bis_common_parameters.get_currency_code INTO g_global_currency_code FROM dual;

1095: g_created_by := nvl(fnd_global.user_id, -1);
1096: g_last_update_login := nvl(fnd_global.login_id, -1);
1097: g_last_updated_by := nvl(fnd_global.user_id, -1);
1098: SELECT BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE INTO g_global_start_date FROM DUAL;
1099: SELECT bis_common_parameters.get_currency_code INTO g_global_currency_code FROM dual;
1100: IF g_global_currency_code IS NULL THEN
1101: RAISE intialization_exception;
1102: END IF;
1103:

Line 1107: g_degree := bis_common_parameters.get_degree_of_parallelism;

1103:
1104: IF NOT fnd_installation.get_app_info( 'OPI', l_status, l_industry, g_opi_schema) THEN
1105: RAISE intialization_exception;
1106: END IF;
1107: g_degree := bis_common_parameters.get_degree_of_parallelism;
1108: BIS_COLLECTION_UTILITIES.put_line('global_start_date = ' || TO_CHAR(g_global_start_date, 'DD-MON-YYYY') || '.');
1109: g_global_rate_type := bis_common_parameters.get_rate_type;
1110: BIS_COLLECTION_UTILITIES.put_line('The primary rate type is ' || g_global_rate_type);
1111:

Line 1109: g_global_rate_type := bis_common_parameters.get_rate_type;

1105: RAISE intialization_exception;
1106: END IF;
1107: g_degree := bis_common_parameters.get_degree_of_parallelism;
1108: BIS_COLLECTION_UTILITIES.put_line('global_start_date = ' || TO_CHAR(g_global_start_date, 'DD-MON-YYYY') || '.');
1109: g_global_rate_type := bis_common_parameters.get_rate_type;
1110: BIS_COLLECTION_UTILITIES.put_line('The primary rate type is ' || g_global_rate_type);
1111:
1112: -- secondary currency support
1113: g_secondary_rate_type := bis_common_parameters.get_secondary_rate_type;

Line 1113: g_secondary_rate_type := bis_common_parameters.get_secondary_rate_type;

1109: g_global_rate_type := bis_common_parameters.get_rate_type;
1110: BIS_COLLECTION_UTILITIES.put_line('The primary rate type is ' || g_global_rate_type);
1111:
1112: -- secondary currency support
1113: g_secondary_rate_type := bis_common_parameters.get_secondary_rate_type;
1114: g_secondary_currency_code :=
1115: bis_common_parameters.get_secondary_currency_code;
1116:
1117: -- check that either both the secondary rate type and secondary

Line 1115: bis_common_parameters.get_secondary_currency_code;

1111:
1112: -- secondary currency support
1113: g_secondary_rate_type := bis_common_parameters.get_secondary_rate_type;
1114: g_secondary_currency_code :=
1115: bis_common_parameters.get_secondary_currency_code;
1116:
1117: -- check that either both the secondary rate type and secondary
1118: -- rate are null, or that neither are null.
1119: IF ( (g_secondary_currency_code IS NULL AND

Line 1975: g_degree := bis_common_parameters.get_degree_of_parallelism;

1971: l_err_msg VARCHAR2(255);
1972: BEGIN
1973:
1974: l_stmt_num := 10;
1975: g_degree := bis_common_parameters.get_degree_of_parallelism;
1976: BIS_COLLECTION_UTILITIES.PUT_LINE('Starting Materialized Views Refresh for Production to Plan...');
1977:
1978: l_stmt_num := 20;
1979: REFRESH_CBN_MV(errbuf, retcode);