PACKAGE: APPS.DDR_BASE_UTIL_PKG

Source

1 PACKAGE DDR_BASE_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: ddrubass.pls 120.0.12010000.3 2010/03/03 04:21:05 vbhave ship $ */
3   FUNCTION rtl_inv_item_dups_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
4   FUNCTION rtl_inv_item_dups_s_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
5   FUNCTION prmtn_pln_dups_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
6   FUNCTION prmtn_pln_dups_s_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
7   FUNCTION rtl_ordr_item_dups_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
8   FUNCTION rtl_ordr_item_dups_s_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
9   FUNCTION rtl_ship_item_dups_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
10   FUNCTION rtl_ship_item_dups_s_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
11   FUNCTION rtl_sl_rtn_dups_fnc(p_load_id IN NUMBER  DEFAULT NULL) RETURN VARCHAR2;
12   FUNCTION rtl_sl_rtn_dups_s_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
13   FUNCTION sls_frcst_item_dups_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
14   FUNCTION sls_frcst_item_dups_s_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
15   FUNCTION synd_cnsmptn_data_dups_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
16   FUNCTION synd_cnsmptn_data_dups_s_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
17   FUNCTION mfg_ship_item_dups_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
18   FUNCTION mfg_ship_item_dups_s_fnc(p_load_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
19   FUNCTION decide_dedup_chk RETURN VARCHAR2;
20   FUNCTION decide_discover_mode RETURN VARCHAR2;
21   FUNCTION decide_run_map_err(map_nm IN VARCHAR2, map_stg IN VARCHAR2) RETURN NUMBER;
22   FUNCTION decide_run_typ RETURN VARCHAR2;
23   FUNCTION decide_sf_map RETURN VARCHAR2;
24   FUNCTION decide_run_cnt_stg(map_nm IN VARCHAR2) RETURN NUMBER;
25   FUNCTION decide_run_map(map_nm IN VARCHAR2) RETURN NUMBER;
26   PROCEDURE trunc_tble_pub( p_tbl_name IN VARCHAR2);
27 
28   FUNCTION get_load_id(p_run_id IN NUMBER) RETURN NUMBER;
29   FUNCTION get_map_run_id(p_audit_id VARCHAR2) RETURN NUMBER;
30   c_audit_id NUMBER := NULL;
31   c_map_id NUMBER := NULL;
32 END ddr_base_util_pkg;