PACKAGE: APPS.DDR_WEBSERVICES_CONSTANTS

Source

1 PACKAGE ddr_webservices_constants AUTHID CURRENT_USER AS
2 /* $Header: ddrpwscs.pls 120.0 2008/02/13 07:08:52 vbhave noship $ */
3 	   --code for MARKET ITEM SALES DAY
4 	   g_misd_cd CONSTANT VARCHAR2 (50) := 'MISD';
5 	   --code for PROMOTION PLAN
6 	   g_pp_cd CONSTANT VARCHAR2 (50) := 'PP';
7 	   --code for RETAIL INVENTORY ITEM DAY
8 	   g_riid_cd CONSTANT VARCHAR2 (50) := 'RIID';
9 	   --code for RETAIL SALE RETURN ITEM DAY
10 	   g_rsrid_cd CONSTANT VARCHAR2 (50) := 'RSRID';
11    	   --code for RETAILER ORDER ITEM DAY
12 	   g_roid_cd CONSTANT VARCHAR2 (50) := 'ROID';
13 	   --code for RETAILER SHIP ITEM DAY
14 	   g_rsid_cd CONSTANT VARCHAR2 (50) := 'RSID';
15 	   --code for SALE FORECAST ITEM BY DAY
16 	   g_sfid_cd CONSTANT VARCHAR2 (50) := 'SFID';
17 	   --table name for MARKET ITEM SALES DAY
18 	   g_misd_fact_tbl CONSTANT VARCHAR2 (30) := 'DDR_B_MKT_ITEM_SLS_DAY';
19 	   --table name for PROMOTION PLAN
20 	   g_pp_fact_tbl CONSTANT VARCHAR2 (30) := 'DDR_B_PRMTN_PLN';
21 	   --table name for RETAIL INVENTORY ITEM DAY fact
22 	   g_riid_fact_tbl CONSTANT VARCHAR2 (30) := 'DDR_B_RTL_INV_ITEM_DAY';
23   	   --table name for RETAIL SALE RETURN ITEM DAY fact
24 	   g_rsrid_fact_tbl CONSTANT VARCHAR2 (30) := 'DDR_B_RTL_SL_RTN_ITM_DAY';
25    	   --table name for RETAILER ORDER ITEM DAY
26 	   g_roid_fact_tbl CONSTANT VARCHAR2 (30) := 'DDR_B_RTL_ORDR_ITEM_DAY';
27    	   --table name for RETAILER SHIP ITEM DAY
28 	   g_rsid_fact_tbl CONSTANT VARCHAR2 (30) := 'DDR_B_RTL_SHIP_ITEM_DAY';
29 	   --table name for SALE FORECAST ITEM BY DAY
30 	   g_sfid_fact_tbl CONSTANT VARCHAR2 (30) := 'DDR_B_SLS_FRCST_ITEM_DAY';
31 
32 	   --file mode read
33 	   g_file_read_mode CONSTANT VARCHAR2 (1) := 'R';
34   	   --file mode write
35 	   g_file_write_mode CONSTANT VARCHAR2 (1) := 'W';
36 
37 	   --return status Success
38 	   g_ret_sts_success CONSTANT VARCHAR2(1):='S';
39 	   --return status 'Error
40 	   g_ret_sts_error CONSTANT VARCHAR2(1):='E';
41 	   --return status 'Unexoected Error
42 	   g_ret_sts_unexp_error CONSTANT VARCHAR2(1):='U';
43 	   --return status 'Initialized
44 	   g_ret_sts_initialize CONSTANT VARCHAR2(1):='I';
45 	   --return status 'Running
46 	   g_ret_sts_running CONSTANT VARCHAR2(1):='R';
47 	   g_api_version NUMBER:=1.0;
48 END ddr_webservices_constants;