1 PACKAGE ddr_emd_util AUTHID CURRENT_USER AS
2 /* $Header: ddremdus.pls 120.1.12020000.2 2012/07/12 21:39:09 gglover ship $ */
3
4 TYPE number_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 TYPE date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
6 TYPE varchar_tbl IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
7
8 c_populate_custom CONSTANT VARCHAR2(1) := 'C';
9 c_populate_standard CONSTANT VARCHAR2(1) := 'S';
10 c_batch_size CONSTANT NUMBER := 50000;
11
12 error CONSTANT VARCHAR2(1) := 'E';
13 success CONSTANT VARCHAR2(1) := 'S';
14
15 new_item_period CONSTANT NUMBER := 30;
16
17 PROCEDURE create_exception(p_mfg_org_cd IN VARCHAR2
18 , p_rtl_org_cd IN VARCHAR2
19 , p_excptn_type IN VARCHAR2
20 , p_excptn_src_code IN VARCHAR2
21 , p_excptn_date IN VARCHAR2
22 , p_org_bsns_unit_id IN VARCHAR2
23 , p_mfg_sku_item_id IN VARCHAR2
24 , p_rtl_sku_item_id IN VARCHAR2
25 , p_user_id IN VARCHAR2
26 , p_excptn_qty IN VARCHAR2 DEFAULT NULL
27 , p_excptn_amt IN VARCHAR2 DEFAULT NULL);
28 PROCEDURE delete_exception(p_excptn_type IN VARCHAR2
29 , p_excptn_src_code IN VARCHAR2
30 , p_date_offset IN NUMBER DEFAULT 0);
31
32 PROCEDURE delete_all_exceptions_wrp(p_end_date IN DATE
33 , p_excptn_type IN VARCHAR2 DEFAULT NULL
34 , p_excptn_src_code IN VARCHAR2 DEFAULT NULL);
35
36 PROCEDURE delete_all_exceptions(p_end_date IN DATE
37 , p_excptn_type IN VARCHAR2 DEFAULT NULL
38 , p_excptn_src_code IN VARCHAR2 DEFAULT NULL
39 , x_return_status OUT NOCOPY VARCHAR2
40 , x_msg OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE calc_exception_measures(p_date_offset IN NUMBER
44 ,p_bsns_unit_cd IN VARCHAR2 DEFAULT NULL
45 ,p_rtl_org_cd IN VARCHAR2 DEFAULT NULL
46 ,p_calc_ifpl_excptn IN BOOLEAN
47 ,p_calc_oosim_excptn IN BOOLEAN
48 ,p_calc_npisales_excptn IN BOOLEAN
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE calc_exception_measures_wrp(p_date_offset IN NUMBER
54 , p_bsns_unit_cd IN VARCHAR2 DEFAULT NULL
55 , p_rtl_org_cd IN VARCHAR2 DEFAULT NULL
56 , p_calc_ifpl_excptn IN VARCHAR2 DEFAULT 'Y'
57 , p_calc_oosim_excptn IN VARCHAR2 DEFAULT 'Y'
58 , p_calc_npisales_excptn IN VARCHAR2 DEFAULT 'Y');
59 END ddr_emd_util;