PACKAGE: APPS.OPI_DBI_BOUNDS_PKG

Source

1 PACKAGE opi_dbi_bounds_pkg AS
2 --$Header: OPIINVBNDS.pls 120.3 2005/11/29 05:18:34 srayadur noship $
3 
4 PROCEDURE maintain_opi_dbi_logs(p_etl_type  IN  VARCHAR2,
5                                 p_load_type  VARCHAR2);
6 
7 PROCEDURE call_etl_specific_bound(p_etl_type  IN  VARCHAR2,
8                           				p_load_type  VARCHAR2);
9 
10 PROCEDURE setup_inv_mmt_bounds(p_load_type  VARCHAR2);
11 
12 PROCEDURE setup_cogs_mmt_bounds(p_load_type  VARCHAR2);
13 
14 PROCEDURE create_first_mmt_bounds(p_etl_type  IN  VARCHAR2);
15 
16 PROCEDURE set_mmt_new_bounds(p_etl_type  IN  VARCHAR2,p_load_type IN VARCHAR2);
17 
18 PROCEDURE setup_inv_wta_bounds(p_load_type  IN  VARCHAR2);
19 
20 PROCEDURE set_sysdate_bounds(p_load_type  IN  VARCHAR2, p_etl_type IN VARCHAR2, p_driving_table_code IN VARCHAR2);
21 
22 PROCEDURE setup_cc_mmt_bounds(p_load_type  IN  VARCHAR2);
23 
24 PROCEDURE set_load_successful(p_etl_type  IN  VARCHAR2,
25                               p_load_type  VARCHAR2);
26 
27 PROCEDURE print_opi_org_bounds(p_etl_type IN VARCHAR2,
28 				p_load_type IN VARCHAR2);
29 
30 FUNCTION bounds_uncosted(p_etl_type IN VARCHAR2, p_load_type IN VARCHAR2) return BOOLEAN;
31 
32 -- Forward declaration
33 PROCEDURE write (p_pkg_name    IN VARCHAR2,
34                  p_proc_name   IN VARCHAR2,
35                  p_stmt_no     IN NUMBER  ,
36                  p_debug_msg   IN VARCHAR2);
37 
38 PROCEDURE load_opm_org_ledger_data;
39 
40 END opi_dbi_bounds_pkg;