APPS.OPI_DBI_COMMON_MOD_INCR_PKG dependencies on OPI_DBI_COMMON_MOD_INIT_PKG

Line 50: opi_dbi_common_mod_init_pkg.JOB_TXN_ETL;

46: */
47:
48: -- Job Transactions Staging
49: JOB_TXN_ETL CONSTANT NUMBER :=
50: opi_dbi_common_mod_init_pkg.JOB_TXN_ETL;
51:
52: -- Actual Resource Usage
53: ACTUAL_RES_ETL CONSTANT NUMBER :=
54: opi_dbi_common_mod_init_pkg.ACTUAL_RES_ETL;

Line 54: opi_dbi_common_mod_init_pkg.ACTUAL_RES_ETL;

50: opi_dbi_common_mod_init_pkg.JOB_TXN_ETL;
51:
52: -- Actual Resource Usage
53: ACTUAL_RES_ETL CONSTANT NUMBER :=
54: opi_dbi_common_mod_init_pkg.ACTUAL_RES_ETL;
55:
56: -- Resource Variance
57: RESOURCE_VAR_ETL CONSTANT NUMBER :=
58: opi_dbi_common_mod_init_pkg.RESOURCE_VAR_ETL;

Line 58: opi_dbi_common_mod_init_pkg.RESOURCE_VAR_ETL;

54: opi_dbi_common_mod_init_pkg.ACTUAL_RES_ETL;
55:
56: -- Resource Variance
57: RESOURCE_VAR_ETL CONSTANT NUMBER :=
58: opi_dbi_common_mod_init_pkg.RESOURCE_VAR_ETL;
59:
60: -- Job Master
61: JOB_MASTER_ETL CONSTANT NUMBER :=
62: opi_dbi_common_mod_init_pkg.JOB_MASTER_ETL;

Line 62: opi_dbi_common_mod_init_pkg.JOB_MASTER_ETL;

58: opi_dbi_common_mod_init_pkg.RESOURCE_VAR_ETL;
59:
60: -- Job Master
61: JOB_MASTER_ETL CONSTANT NUMBER :=
62: opi_dbi_common_mod_init_pkg.JOB_MASTER_ETL;
63:
64: /* All ETLs can have one of two sources: */
65: OPI_SOURCE CONSTANT NUMBER :=
66: opi_dbi_common_mod_init_pkg.OPI_SOURCE;

Line 66: opi_dbi_common_mod_init_pkg.OPI_SOURCE;

62: opi_dbi_common_mod_init_pkg.JOB_MASTER_ETL;
63:
64: /* All ETLs can have one of two sources: */
65: OPI_SOURCE CONSTANT NUMBER :=
66: opi_dbi_common_mod_init_pkg.OPI_SOURCE;
67:
68: OPM_SOURCE CONSTANT NUMBER :=
69: opi_dbi_common_mod_init_pkg.OPM_SOURCE;
70:

Line 69: opi_dbi_common_mod_init_pkg.OPM_SOURCE;

65: OPI_SOURCE CONSTANT NUMBER :=
66: opi_dbi_common_mod_init_pkg.OPI_SOURCE;
67:
68: OPM_SOURCE CONSTANT NUMBER :=
69: opi_dbi_common_mod_init_pkg.OPM_SOURCE;
70:
71: /* ETLs can have to stop for multiple reasons. The stop reason
72: codes are defined as follows: */
73: STOP_UNCOSTED CONSTANT NUMBER :=

Line 74: opi_dbi_common_mod_init_pkg.STOP_UNCOSTED;

70:
71: /* ETLs can have to stop for multiple reasons. The stop reason
72: codes are defined as follows: */
73: STOP_UNCOSTED CONSTANT NUMBER :=
74: opi_dbi_common_mod_init_pkg.STOP_UNCOSTED;
75:
76: STOP_ALL_COSTED CONSTANT NUMBER :=
77: opi_dbi_common_mod_init_pkg.STOP_ALL_COSTED;
78:

Line 77: opi_dbi_common_mod_init_pkg.STOP_ALL_COSTED;

73: STOP_UNCOSTED CONSTANT NUMBER :=
74: opi_dbi_common_mod_init_pkg.STOP_UNCOSTED;
75:
76: STOP_ALL_COSTED CONSTANT NUMBER :=
77: opi_dbi_common_mod_init_pkg.STOP_ALL_COSTED;
78:
79: /*----------------------------------------*/
80:
81:

Line 198: IF (NOT (opi_dbi_common_mod_init_pkg.check_global_setup ())) THEN

194:
195: -- check if the global set up is good
196: -- Use the initial load package
197: l_stmt_id := 20;
198: IF (NOT (opi_dbi_common_mod_init_pkg.check_global_setup ())) THEN
199: RAISE global_setup_missing;
200: END IF;
201:
202:

Line 217: l_bounds_warning := opi_dbi_common_mod_init_pkg.bounds_uncosted ();

213:
214: -- check if some bounds are uncosted before calling any other
215: -- procedure that can wipe out the stop reason code
216: l_stmt_id := 40;
217: l_bounds_warning := opi_dbi_common_mod_init_pkg.bounds_uncosted ();
218:
219:
220: -- Print the discrete org collection bounds
221: l_stmt_id := 50;

Line 222: opi_dbi_common_mod_init_pkg.print_opi_org_bounds;

218:
219:
220: -- Print the discrete org collection bounds
221: l_stmt_id := 50;
222: opi_dbi_common_mod_init_pkg.print_opi_org_bounds;
223:
224: -- if uncosted transactions were found, return a warning.
225: l_stmt_id := 80;
226: IF (l_bounds_warning) THEN