eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.DDR_SETUP_UTIL

Source


1 PACKAGE BODY ddr_setup_util AS
2 /* $Header: ddrstpub.pls 120.2.12010000.3 2008/09/13 05:53:12 vbhave ship $ */
3 
4   v_version CONSTANT VARCHAR2(30):= 'DDR seed verion 1.1';
5 
6   PROCEDURE Raise_Error (p_error_text IN VARCHAR2)
7   IS
8       l_error_text        VARCHAR2(240);
9   BEGIN
10       l_error_text := p_error_text;
11       Raise_Application_Error(-20001,l_error_text);
12   END Raise_Error;
13 
14   PROCEDURE setup(p_mfg_org VARCHAR2) IS
15     v_org_exists NUMBER:=0;
16   BEGIN
17     setup_mfg_org(p_mfg_org);
18     setup_ws_metadata;
19     setup_lookup_type;
20     setup_lookup(p_mfg_org);
21   END setup;
22 
23   PROCEDURE setup_mfg_org(p_mfg_org VARCHAR2) IS
24     v_org_exists NUMBER:=0;
25   BEGIN
26     SELECT COUNT(*)
27     INTO   v_org_exists
28     FROM   DDR_R_ORG
29     WHERE  mfg_org_cd = p_mfg_org
30     AND    org_cd = p_mfg_org;
31 
32     IF v_org_exists > 0 THEN
33       raise_error('The manufacture org exists');
34     END IF;
35 
36     INSERT INTO ddr_r_org
37     (mfg_org_cd, org_cd, org_typ, glbl_loc_id, glbl_loc_id_typ,
38     created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
39     VALUES
40     (p_mfg_org, p_mfg_org, 'MFG', -1, -1,
41     -1, SYSDATE, '-1', SYSDATE, '-1', v_version, SYSDATE, '-1', '-1');
42   END  setup_mfg_org;
43 
44   PROCEDURE setup_lookup(p_mfg_org VARCHAR2) IS
45   BEGIN
46     DELETE ddr_r_lkup_mst
47     WHERE  mfg_org_cd = p_mfg_org;
48 
49     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
50     VALUES (p_mfg_org,'BSNS_UNIT_TYP','CATALOGUE','Catalogue','Catalogue',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
51     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
52     VALUES (p_mfg_org,'BSNS_UNIT_TYP','DC','Distribution Centre','Distribution Centre',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
53     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
54     VALUES (p_mfg_org,'BSNS_UNIT_TYP','RTLSTORE','Retail Store','Retail Store',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
55     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
56     VALUES (p_mfg_org,'BSNS_UNIT_TYP','WAREHOUSE','Warehouse','Warehouse',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
57     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
58     VALUES (p_mfg_org,'BSNS_UNIT_TYP','WEBSTORE','Web Store','Web Store',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
59     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
60     VALUES (p_mfg_org,'CHNL_TYP','Direct','Direct','Direct',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
61     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
62     VALUES (p_mfg_org,'ERR','DSR-1001','NULL not allowed','This column value can not be NULL, please provide non NULL value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
63     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
64     VALUES (p_mfg_org,'ERR','DSR-1002','Invalid Value','No matching value found in setup, please provide valid column value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
65     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
66     VALUES (p_mfg_org,'ERR','DSR-1003','Zero Value','This column can not have zero values, please provide non zero value',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
67     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
68     VALUES (p_mfg_org,'ERR','DSR-1004','Invalid item association','The item is not authorized to be sold from this Business Unit',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
69     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
70     VALUES (p_mfg_org,'ERR','DSR-1005','Invalid Organization Type','Invalid Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
71     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
72     VALUES (p_mfg_org,'ERR','DSR-1006','Invalid Combination','Invalid Combination',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
73     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
74     VALUES (p_mfg_org,'ERR','DSR-1007','Inactive Business Unit','The Business Unit is not operational',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
75     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
76     VALUES (p_mfg_org,'ERR','DSR-1008','Time Alloc % Not Found','No record found for Time allocation in setup ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
77     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
78     VALUES (p_mfg_org,'ERR','DSR-1009','Org Alloc % Not Found','No record found for Organization  allocation in setup',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
79     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
80     VALUES (p_mfg_org,'ERR','DSR-1010','No UOM conversion Found','No matching value found in the setup conversion table',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
81     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
82     VALUES (p_mfg_org,'ERR','DSR-1011','No Exchange Rate found ','No matching value found in the setup exchange rate table',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
83     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
84     VALUES (p_mfg_org,'ERR','DSR-1012','Inactive Item','The Item has expired',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
85     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
86     VALUES (p_mfg_org,'MEASURE','% RETURNS','% RETURNS','% Returns',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
87     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
88     VALUES (p_mfg_org,'MEASURE','CATEGORY MONETARY SALES','CATEGORY MONETARY SALES','CATEGORY MONETARY SALES',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
89     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
90     VALUES (p_mfg_org,'MEASURE','DEDUCTION AMT','Deduction Amount','Deduction Amount',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
91     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
92     VALUES (p_mfg_org,'MEASURE','DEDUCTION BALANCE','Deduction Balance','Deduction Balance',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
93     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
94     VALUES (p_mfg_org,'MEASURE','DOLLAR SALE','Dollar Sale','Dollar Sale',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
95     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
96     VALUES (p_mfg_org,'MEASURE','GROSS MARGIN','Gross Margin','Gross Margin',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
97     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
98     VALUES (p_mfg_org,'MEASURE','IN STOCK %','IN STOCK %','In Stock % ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
99     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
100     VALUES (p_mfg_org,'MEASURE','INVENTORY COVER MAX','INVENTORY COVER MAX','Inventory Cover max ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
101     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
102     VALUES (p_mfg_org,'MEASURE','INVENTORY COVER MIN','INVENTORY COVER MIN','Inventory Cover min ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
103     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
104     VALUES (p_mfg_org,'MEASURE','INVENTORY TURNS','Inventory Turns','Inventory Turns',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
105     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
106     VALUES (p_mfg_org,'MEASURE','INVOICE ACCURACY','Invoice Accuracy','Invoice Accuracy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
107     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
108     VALUES (p_mfg_org,'MEASURE','ITEM DATA ACCURACY','Item Data Accuracy','Item Data Accuracy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
109     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
110     VALUES (p_mfg_org,'MEASURE','ITEM DATA SYNCHRONIZATION','Item Data Synchronization','Item Data Synchronization',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
111     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
112     VALUES (p_mfg_org,'MEASURE','LATE PAYMENT','Late Payment','Late Payment',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
113     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
114     VALUES (p_mfg_org,'MEASURE','MONETARY SALES','MONETARY SALES','MONETARY SALES',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
115     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
116     VALUES (p_mfg_org,'MEASURE','NO OF DEDUCTIONS','No. of Deductions','No. of Deductions',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
117     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
118     VALUES (p_mfg_org,'MEASURE','ON TIME DELIVERY DATE','On Time Delivery - Date','On Time Delivery - Date',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
119     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
120     VALUES (p_mfg_org,'MEASURE','ON TIME DELIVERY TIME','On Time Delivery - Time','On Time Delivery - Time',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
121     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
122     VALUES (p_mfg_org,'MEASURE','ON-HAND INVENTORY','ON-HAND INVENTORY','On-Hand Inventory ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
123     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
124     VALUES (p_mfg_org,'MEASURE','ORDER CHANGE %','Order Change %','Order Change %',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
125     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
126     VALUES (p_mfg_org,'MEASURE','ORDER CYCLE TIME','Order Cycle Time','Order Cycle Time',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
127     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
128     VALUES (p_mfg_org,'MEASURE','PAYEMENT DAYS','Payment Days','Payment Days',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
129     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
130     VALUES (p_mfg_org,'MEASURE','PERFECT ORDER %','Perfect Order %','Perfect Order %',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
131     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
132     VALUES (p_mfg_org,'MEASURE','RETAIL GROSS MARGIN (%)','RETAIL GROSS MARGIN (%)','Retail Gross Margin (%)',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
133     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
134     VALUES (p_mfg_org,'MEASURE','SALES FORECAST ACCURACY (%)','SALES FORECAST ACCURACY (%)','Sales Forecast Accuracy (%)',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
135     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
136     VALUES (p_mfg_org,'MEASURE','SERVICE LEVEL','SERVICE LEVEL','Service Level ',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
137     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
138     VALUES (p_mfg_org,'MEASURE','SHARE OF MARKET','Share of Market','Share of Market',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
139     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
140     VALUES (p_mfg_org,'MEASURE','SHOPPER PENETRATION','Shopper Penetration','Shopper Penetration',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
141     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
142     VALUES (p_mfg_org,'MEASURE','UNIT SALE','Unit Sale','Unit Sale',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
143     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
144     VALUES (p_mfg_org,'MEASURE','UNSALEABLES','Unsaleables','Unsaleables',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
145     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
146     VALUES (p_mfg_org,'MEASURE_TYP','EXTERNAL','External Measure','External Measure',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
147     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
148     VALUES (p_mfg_org,'MEASURE_TYP','GOAL','Goal','Goal',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
149     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
150     VALUES (p_mfg_org,'MEASURE_TYP','THRESHOLD','Threshold','Threshold',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
151     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
152     VALUES (p_mfg_org,'MFG_ITEM_LVL','CLASS','Item Class / Category','Item Class / Category',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
153     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
154     VALUES (p_mfg_org,'MFG_ITEM_LVL','COMPANY','Item Company','Item Company',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
155     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
156     VALUES (p_mfg_org,'MFG_ITEM_LVL','DIVISION','Item Division','Item Division',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
157     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
158     VALUES (p_mfg_org,'MFG_ITEM_LVL','GROUP','Item Group','Item Group',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
159     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
160     VALUES (p_mfg_org,'MFG_ITEM_LVL','ITEM','Item','Item',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
161     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
162     VALUES (p_mfg_org,'MFG_ITEM_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
163     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
164     VALUES (p_mfg_org,'MFG_ITEM_LVL','SKU','SKU','SKU',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
165     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
166     VALUES (p_mfg_org,'MFG_ITEM_LVL','SUBCLASS','Item Sub-Class','Item Sub-Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
167     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
168     VALUES (p_mfg_org,'ORG_LVL','AREA','Area','Area',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
169     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
170     VALUES (p_mfg_org,'ORG_LVL','BU','Business Unit','Business Unit',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
171     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
172     VALUES (p_mfg_org,'ORG_LVL','CHAIN','Chain','Chain',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
173     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
174     VALUES (p_mfg_org,'ORG_LVL','DISTRICT','District','District',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
175     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
176     VALUES (p_mfg_org,'ORG_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
177     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
178     VALUES (p_mfg_org,'ORG_LVL','ORGANIZATION','Organization','Organization',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
182     VALUES (p_mfg_org,'ORG_TYP','CMP','Competitor','Competitor',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
179     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
180     VALUES (p_mfg_org,'ORG_LVL','REGION','Region','Region',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
181     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
183     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
184     VALUES (p_mfg_org,'ORG_TYP','MFG','Manufacturer','Manufacturer',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
185     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
186     VALUES (p_mfg_org,'ORG_TYP','RTL','Retailer','Retailer',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
187     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
188     VALUES (p_mfg_org,'RTL_ITEM_LVL','CLASS','Item Class / Category','Item Class / Category',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
189     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
190     VALUES (p_mfg_org,'RTL_ITEM_LVL','COMPANY','Item Company','Item Company',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
191     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
192     VALUES (p_mfg_org,'RTL_ITEM_LVL','DEPARTMENT','Item Department','Item Department',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
193     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
194     VALUES (p_mfg_org,'RTL_ITEM_LVL','DIVISION','Item Division','Item Division',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
195     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
196     VALUES (p_mfg_org,'RTL_ITEM_LVL','GROUP','Item Group','Item Group',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
197     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
198     VALUES (p_mfg_org,'RTL_ITEM_LVL','ITEM','Item','Item',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
199     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
200     VALUES (p_mfg_org,'RTL_ITEM_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
201     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
202     VALUES (p_mfg_org,'RTL_ITEM_LVL','SKU','SKU','SKU',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
203     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
204     VALUES (p_mfg_org,'RTL_ITEM_LVL','SUBCLASS','Item Sub-Class','Item Sub-Class',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
205     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
206     VALUES (p_mfg_org,'SYS_PARAM','DISCOVERY_MODE','N','Discovery mode for POS Data: Possible values are N for Strict Mode and Y for Item Discovery Mode',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
207     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
208     VALUES (p_mfg_org,'SYS_PARAM','MAX_OUTPUT_RECORDS','20000000','Maximum records that can be returned to the calling application through web services',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
209     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
210     VALUES (p_mfg_org,'SYS_PARAM','MAX_REC_PER_FILE','200000','Maximum number of records per output file created by web service',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
211     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
212     VALUES (p_mfg_org,'SYS_PARAM','OUTPUT_DIR_PATH',NULL,'Directory for web service output files',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
213     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
214     VALUES (p_mfg_org,'SYS_PARAM','PERFORM_DUP_CHECK','N','Duplicate record check for Fact data: Possible values are Y to perform check for duplicate records and N to skip check for duplicate records',v_version
218            ,SYSDATE,'-1',SYSDATE,'-1');
215            ,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
216     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
217     VALUES (p_mfg_org,'SYS_PARAM','RUN_TYPE_FACT','P','Data Load Mode for Fact data: Possible values are P for Partial data load, S for Simulation and A for All or None data load',v_version,SYSDATE,'-1','-1','-1'
219     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
220     VALUES (p_mfg_org,'SYS_PARAM','RUN_TYP_REF','P','Data Load Mode for Reference data: Possible values are P for Partial Load and S for Simulation Load',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
221     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
222     VALUES (p_mfg_org,'SYS_PARAM','STAGE_TO_TARGET_VALIDATION','N','Dangling key check for data in staging tables: Possible values are Y to perform dangling key validation, N to skip dangling key validation',v_version
223            ,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
224     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
225     VALUES (p_mfg_org,'SYS_PARAM','DDR_WS_FILE_PATH',NULL,'Complete directory path for output files location',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
226     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
227     VALUES (p_mfg_org,'TIME_LVL','DAY','Day','Day',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
228     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
229     VALUES (p_mfg_org,'TIME_LVL','MONTH','Month','Month',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
230     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
231     VALUES (p_mfg_org,'TIME_LVL','NA','Not Applicable','Not Applicable',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
232     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
233     VALUES (p_mfg_org,'TIME_LVL','QUARTER','Quarter','Quarter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
234     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
235     VALUES (p_mfg_org,'TIME_LVL','WEEK','Week','Week',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
236     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
237     VALUES (p_mfg_org,'TIME_LVL','YEAR','Year','Year',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
238     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
239     VALUES (p_mfg_org,'PRMTN_FLAG','Y','Promotion','Promotion Sales',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
240     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
241     VALUES (p_mfg_org,'PRMTN_FLAG','N','Regular','Non Promotion Sales',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
242 
243     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
244     VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SRC_DIR',NULL,'Directory location for the data file',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
245     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
246     VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SRC_FILENAME',NULL,'Name of the data file',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
247     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
248     VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_SUCCESS_DIR',NULL,'Archive directory for data file after successful data load',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
249     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
250     VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_FAILED_DIR',NULL,'Archive directory for data file if data load fails',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
251     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
252     VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_TO_ADDR',NULL,'To email address for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
256     VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_MAIL_SERVER',NULL,'Email server for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
253     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
254     VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_FM_ADDR',NULL,'From email address for process notifications',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
255     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
257     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
258     VALUES (p_mfg_org,'SYS_PARAM','RETL_DSR_CLASS_DIR',NULL,'Directory location for java class files used for RMS integration',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
259 
260     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
261     VALUES (p_mfg_org,'ITM_TYP','M','Manufacturer Item','Item from manufacturer item hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
262     INSERT INTO ddr_r_lkup_mst (mfg_org_cd,lkup_typ_cd,lkup_cd,lkup_name,lkup_desc,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
263     VALUES (p_mfg_org,'ITM_TYP','C','Competitor Item','Item from competitor item hierarchy',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
264   END setup_lookup;
265 
266   PROCEDURE setup_ws_metadata IS
267   BEGIN
268     DELETE ddr_ws_metadata;
269 
270     INSERT INTO ddr_ws_metadata
271     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
272     VALUES
273    ('MFG_CLASS_CD', 'ITEM', 'Item Class', 4, NULL,
274     'Y', 'Y', -1, SYSDATE, '-1',
275     SYSDATE, '-1', v_version, SYSDATE, '-1',
276     '-1');
277     INSERT INTO ddr_ws_metadata
278     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
279     VALUES
280    ('MFG_SBC_CD', 'ITEM', 'Item SubClass', 3, NULL,
281     'Y', 'Y', -1, SYSDATE, '-1',
282     SYSDATE, '-1', v_version, SYSDATE, '-1',
283     '-1');
284     INSERT INTO ddr_ws_metadata
285     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
286     VALUES
287    ('MFG_ITEM_NBR', 'ITEM', 'Item Number', 2, NULL,
288     'Y', 'N', -1, SYSDATE, '-1',
289     SYSDATE, '-1', v_version, SYSDATE, '-1',
290     '-1');
291     INSERT INTO ddr_ws_metadata
292     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
293     VALUES
294    ('MFG_SKU_ITEM_NBR', 'ITEM', 'Sku Item Number', 1, NULL,
295     'Y', 'Y', -1, SYSDATE, '-1',
296     SYSDATE, '-1', v_version, SYSDATE, '-1',
297     '-1');
298     INSERT INTO ddr_ws_metadata
299     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
300     VALUES
301    ('MFG_DIV_CD', 'ITEM', 'Item Division', 6, NULL,
302     'Y', 'N', -1, SYSDATE, '-1',
303     SYSDATE, '-1', v_version, SYSDATE, '-1',
304     '-1');
305     INSERT INTO ddr_ws_metadata
306     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
307     VALUES
308    ('MFG_GRP_CD', 'ITEM', 'Item Group', 5, NULL,
309     'Y', 'N', -1, SYSDATE, '-1',
310     SYSDATE, '-1', v_version, SYSDATE, '-1',
311     '-1');
312     INSERT INTO ddr_ws_metadata
313     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
314     VALUES
315    ('CLSTR_CD', 'ORGANIZATION', 'Organization Retail Cluster', 7, NULL,
316     'Y', 'N', -1, SYSDATE, '-1',
317     SYSDATE, '-1', v_version, SYSDATE, '-1',
318     '-1');
319     INSERT INTO ddr_ws_metadata
320     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
321     VALUES
322    ('ORG_CD', 'ORGANIZATION', 'Organization Retail Org', 6, NULL,
323     'Y', 'N', -1, SYSDATE, '-1',
324     SYSDATE, '-1', v_version, SYSDATE, '-1',
325     '-1');
326     INSERT INTO ddr_ws_metadata
327     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
328     VALUES
329    ('CHAIN_CD', 'ORGANIZATION', 'Organization Retail Chain', 5, NULL,
330     'Y', 'N', -1, SYSDATE, '-1',
331     SYSDATE, '-1', v_version, SYSDATE, '-1',
332     '-1');
333     INSERT INTO ddr_ws_metadata
337     'N', 'N', -1, SYSDATE, '-1',
334     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
335     VALUES
336    ('AREA_CD', 'ORGANIZATION', 'Organization Retail Area', 4, NULL,
338     SYSDATE, '-1', v_version, SYSDATE, '-1',
339     '-1');
340     INSERT INTO ddr_ws_metadata
341     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
342     VALUES
343    ('RGN_CD', 'ORGANIZATION', 'Organization Retail Region', 3, NULL,
344     'N', 'N', -1, SYSDATE, '-1',
345     SYSDATE, '-1', v_version, SYSDATE, '-1',
346     '-1');
347     INSERT INTO ddr_ws_metadata
348     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
349     VALUES
350    ('DSTRCT_CD', 'ORGANIZATION', 'Organization Retail District', 2, NULL,
351     'N', 'N', -1, SYSDATE, '-1',
352     SYSDATE, '-1', v_version, SYSDATE, '-1',
353     '-1');
354     INSERT INTO ddr_ws_metadata
355     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
356     VALUES
357    ('BSNS_UNIT_CD', 'ORGANIZATION', 'Organization Retail Bus. Unit', 1, NULL,
358     'N', 'N', -1, SYSDATE, '-1',
359     SYSDATE, '-1', v_version, SYSDATE, '-1',
360     '-1');
361     INSERT INTO ddr_ws_metadata
362     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
363     VALUES
364    ('INV_LOC_CD', 'ORGANIZATION', 'Organization Inventory Level', 0, NULL,
365     'Y', 'N', -1, SYSDATE, '-1',
366     SYSDATE, '-1', v_version, SYSDATE, '-1',
367     '-1');
368     INSERT INTO ddr_ws_metadata
369     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
370     VALUES
371    ('CNTRY_CD', 'LOCATION', 'Location Country', 3, NULL,
372     'N', 'N', -1, SYSDATE, '-1',
373     SYSDATE, '-1', v_version, SYSDATE, '-1',
374     '-1');
375     INSERT INTO ddr_ws_metadata
376     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
377     VALUES
378    ('STATE_CD', 'LOCATION', 'Location State', 2, NULL,
379     'N', 'N', -1, SYSDATE, '-1',
380     SYSDATE, '-1', v_version, SYSDATE, '-1',
381     '-1');
382     INSERT INTO ddr_ws_metadata
386     'N', 'N', -1, SYSDATE, '-1',
383     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
384     VALUES
385    ('CITY_CD', 'LOCATION', 'Location City', 1, NULL,
387     SYSDATE, '-1', v_version, SYSDATE, '-1',
388     '-1');
389     INSERT INTO ddr_ws_metadata
390     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
391     VALUES
392    ('CLNDR_YR_CD', 'GREGORIAN TIME', 'Calander Year', 5, NULL,
393     'Y', 'N', -1, SYSDATE, '-1',
394     SYSDATE, '-1', v_version, SYSDATE, '-1',
395     '-1');
396     INSERT INTO ddr_ws_metadata
397     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
398     VALUES
399    ('CLNDR_QTR_CD', 'GREGORIAN TIME', 'Calander Quarter', 4, NULL,
400     'Y', 'N', -1, SYSDATE, '-1',
401     SYSDATE, '-1', v_version, SYSDATE, '-1',
402     '-1');
403     INSERT INTO ddr_ws_metadata
404     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
405     VALUES
406    ('CLNDR_MNTH_CD', 'GREGORIAN TIME', 'Calander Month', 3, NULL,
407     'Y', 'N', -1, SYSDATE, '-1',
408     SYSDATE, '-1', v_version, SYSDATE, '-1',
409     '-1');
410     INSERT INTO ddr_ws_metadata
411     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
412     VALUES
413    ('CLNDR_WK_CD', 'GREGORIAN TIME', 'Calander Week', 2, NULL,
414     'Y', 'N', -1, SYSDATE, '-1',
415     SYSDATE, '-1', v_version, SYSDATE, '-1',
416     '-1');
417     INSERT INTO ddr_ws_metadata
418     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
419     VALUES
420    ('CLNDR_DAY_CD', 'GREGORIAN TIME', 'Calander Day', 1, NULL,
421     'Y', 'Y', -1, SYSDATE, '-1',
422     SYSDATE, '-1', v_version, SYSDATE, '-1',
423     '-1');
424     INSERT INTO ddr_ws_metadata
425     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
426     VALUES
427    ('BSNS_YR_CD', 'BUSINESS TIME', 'Business Year', 5, NULL,
428     'Y', 'N', -1, SYSDATE, '-1',
429     SYSDATE, '-1', v_version, SYSDATE, '-1',
430     '-1');
431     INSERT INTO ddr_ws_metadata
432     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
433     VALUES
434    ('BSNS_QTR_CD', 'BUSINESS TIME', 'Business Quarter', 4, NULL,
435     'Y', 'N', -1, SYSDATE, '-1',
436     SYSDATE, '-1', v_version, SYSDATE, '-1',
437     '-1');
438     INSERT INTO ddr_ws_metadata
439     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
440     VALUES
441    ('BSNS_MNTH_CD', 'BUSINESS TIME', 'Business Month', 3, NULL,
442     'Y', 'N', -1, SYSDATE, '-1',
443     SYSDATE, '-1', v_version, SYSDATE, '-1',
444     '-1');
445     INSERT INTO ddr_ws_metadata
446     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
447     VALUES
448    ('BSNS_DAY_CD', 'BUSINESS TIME', 'Business Day', 1, NULL,
449     'Y', 'N', -1, SYSDATE, '-1',
450     SYSDATE, '-1', v_version, SYSDATE, '-1',
451     '-1');
452     INSERT INTO ddr_ws_metadata
453     (hrchy_lvl_cd, hrchy_lvl_name, hrchy_lvl_desc, lvl_rnk, lvl_grp, input, output, created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
454     VALUES
455     ('BSNS_WK_CD', 'BUSINESS TIME', 'Business Week', 2, 1,
456     'Y', 'Y', -1, SYSDATE, '-1',
457     SYSDATE, '-1', v_version, SYSDATE, '-1',
458     '-1');
459   END setup_ws_metadata;
460 
461   PROCEDURE setup_lookup_type IS
462   BEGIN
463     DELETE ddr_r_lkup_typ;
464     INSERT INTO ddr_r_lkup_typ
465     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
466     VALUES ('ADDR_TYP','Address Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
467     INSERT INTO ddr_r_lkup_typ
468     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
469     VALUES ('BRND','Item Brand',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
470     INSERT INTO ddr_r_lkup_typ
471     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
472     VALUES ('BSNS_UNIT_TYP','Business Unit Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
473     INSERT INTO ddr_r_lkup_typ
474     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
475     VALUES ('CHNL_TYP','Channel Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
476     INSERT INTO ddr_r_lkup_typ
477     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
478     VALUES ('COATING','Coating Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
479     INSERT INTO ddr_r_lkup_typ
480     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
481     VALUES ('COLOR','Color',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
482     INSERT INTO ddr_r_lkup_typ
483     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
484     VALUES ('DYE','Dye',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
485     INSERT INTO ddr_r_lkup_typ
486     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
487     VALUES ('ERR','Error',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
488     INSERT INTO ddr_r_lkup_typ
489     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
490     VALUES ('FABRIC','Fabric',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
491     INSERT INTO ddr_r_lkup_typ
492     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
493     VALUES ('FIBER','Fiber',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
494     INSERT INTO ddr_r_lkup_typ
495     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
496     VALUES ('GIID_TYP','GIID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
497     INSERT INTO ddr_r_lkup_typ
498     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
499     VALUES ('GLID_TYP','GLID Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
500     INSERT INTO ddr_r_lkup_typ
501     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
502     VALUES ('MEASURE','Measure Name',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
503     INSERT INTO ddr_r_lkup_typ
504     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
505     VALUES ('MEASURE_TYP','Measure Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
506     INSERT INTO ddr_r_lkup_typ
507     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
508     VALUES ('MFG_ITEM_LVL','Mfg Item Level Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
509     INSERT INTO ddr_r_lkup_typ
510     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
511     VALUES ('ORG_LVL','Organization Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
512     INSERT INTO ddr_r_lkup_typ
513     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
514     VALUES ('ORG_TYP','Organization Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
515     INSERT INTO ddr_r_lkup_typ
516     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
517     VALUES ('RPLNSHMNT_TYP','Replenishment Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
518     INSERT INTO ddr_r_lkup_typ
519     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
520     VALUES ('RTL_ITEM_LVL','Retailer Item Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
521     INSERT INTO ddr_r_lkup_typ
522     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
523     VALUES ('RTL_TYP','Retail Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
524     INSERT INTO ddr_r_lkup_typ
525     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
526     VALUES ('SKU_ITEM_STYLE','SKU Item Style',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
527     INSERT INTO ddr_r_lkup_typ
528     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
529     VALUES ('SKU_ITEM_TYP','SKU Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
530     INSERT INTO ddr_r_lkup_typ
531     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
532     VALUES ('SLNG_LOC_TYP','Selling Location Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
533     INSERT INTO ddr_r_lkup_typ
534     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
535     VALUES ('STCK_ITEM_TYP','Stock Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
536     INSERT INTO ddr_r_lkup_typ
537     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
538     VALUES ('SYS_PARAM','System Parameter',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
539     INSERT INTO ddr_r_lkup_typ
540     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
541     VALUES ('SZ_TYP','Size Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
542     INSERT INTO ddr_r_lkup_typ
543     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
544     VALUES ('TIME_LVL','Time Level',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
545     INSERT INTO ddr_r_lkup_typ
546     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
547     VALUES ('VRTY_TYP','Variety Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
548     INSERT INTO ddr_r_lkup_typ
549     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
550     VALUES ('WEAVE','Weave Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
551     INSERT INTO ddr_r_lkup_typ
552     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
553     VALUES ('PRMTN_FLAG','Promotion Flag',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
554     INSERT INTO ddr_r_lkup_typ
555     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
556     VALUES ('MKT_AREA_TYP','Market Area Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
557     INSERT INTO ddr_r_lkup_typ
558     (lkup_typ_cd,lkup_typ_name,src_sys_idnt,src_sys_dt,crtd_by_dsr,last_updt_by_dsr,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
559     VALUES ('ITM_TYP','Item Type',v_version,SYSDATE,'-1','-1','-1',SYSDATE,'-1',SYSDATE,'-1');
560   END setup_lookup_type;
561 END ddr_setup_util;