97:
98: PROCEDURE create_val_sets IS
99: BEGIN
100:
101: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
102:
103: /* delete valuesets if they exist */
104:
105: IF fnd_flex_val_api.valueset_exists('CPG_CO_CODE') THEN
101: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
102:
103: /* delete valuesets if they exist */
104:
105: IF fnd_flex_val_api.valueset_exists('CPG_CO_CODE') THEN
106: fnd_flex_val_api.delete_valueset('CPG_CO_CODE');
107: End IF;
108:
109: IF fnd_flex_val_api.valueset_exists('CPG_QC_GRADE') THEN
102:
103: /* delete valuesets if they exist */
104:
105: IF fnd_flex_val_api.valueset_exists('CPG_CO_CODE') THEN
106: fnd_flex_val_api.delete_valueset('CPG_CO_CODE');
107: End IF;
108:
109: IF fnd_flex_val_api.valueset_exists('CPG_QC_GRADE') THEN
110: fnd_flex_val_api.delete_valueset('CPG_QC_GRADE');
105: IF fnd_flex_val_api.valueset_exists('CPG_CO_CODE') THEN
106: fnd_flex_val_api.delete_valueset('CPG_CO_CODE');
107: End IF;
108:
109: IF fnd_flex_val_api.valueset_exists('CPG_QC_GRADE') THEN
110: fnd_flex_val_api.delete_valueset('CPG_QC_GRADE');
111: End IF;
112:
113: IF fnd_flex_val_api.valueset_exists('CPG_BASE_UOM') THEN
106: fnd_flex_val_api.delete_valueset('CPG_CO_CODE');
107: End IF;
108:
109: IF fnd_flex_val_api.valueset_exists('CPG_QC_GRADE') THEN
110: fnd_flex_val_api.delete_valueset('CPG_QC_GRADE');
111: End IF;
112:
113: IF fnd_flex_val_api.valueset_exists('CPG_BASE_UOM') THEN
114: fnd_flex_val_api.delete_valueset('CPG_BASE_UOM');
109: IF fnd_flex_val_api.valueset_exists('CPG_QC_GRADE') THEN
110: fnd_flex_val_api.delete_valueset('CPG_QC_GRADE');
111: End IF;
112:
113: IF fnd_flex_val_api.valueset_exists('CPG_BASE_UOM') THEN
114: fnd_flex_val_api.delete_valueset('CPG_BASE_UOM');
115: End IF;
116:
117: IF fnd_flex_val_api.valueset_exists('CPG_SEC_UOM') THEN
110: fnd_flex_val_api.delete_valueset('CPG_QC_GRADE');
111: End IF;
112:
113: IF fnd_flex_val_api.valueset_exists('CPG_BASE_UOM') THEN
114: fnd_flex_val_api.delete_valueset('CPG_BASE_UOM');
115: End IF;
116:
117: IF fnd_flex_val_api.valueset_exists('CPG_SEC_UOM') THEN
118: fnd_flex_val_api.delete_valueset('CPG_SEC_UOM');
113: IF fnd_flex_val_api.valueset_exists('CPG_BASE_UOM') THEN
114: fnd_flex_val_api.delete_valueset('CPG_BASE_UOM');
115: End IF;
116:
117: IF fnd_flex_val_api.valueset_exists('CPG_SEC_UOM') THEN
118: fnd_flex_val_api.delete_valueset('CPG_SEC_UOM');
119: End IF;
120:
121: IF fnd_flex_val_api.valueset_exists('CPG_PO_NO') THEN
114: fnd_flex_val_api.delete_valueset('CPG_BASE_UOM');
115: End IF;
116:
117: IF fnd_flex_val_api.valueset_exists('CPG_SEC_UOM') THEN
118: fnd_flex_val_api.delete_valueset('CPG_SEC_UOM');
119: End IF;
120:
121: IF fnd_flex_val_api.valueset_exists('CPG_PO_NO') THEN
122: fnd_flex_val_api.delete_valueset('CPG_PO_NO');
117: IF fnd_flex_val_api.valueset_exists('CPG_SEC_UOM') THEN
118: fnd_flex_val_api.delete_valueset('CPG_SEC_UOM');
119: End IF;
120:
121: IF fnd_flex_val_api.valueset_exists('CPG_PO_NO') THEN
122: fnd_flex_val_api.delete_valueset('CPG_PO_NO');
123: End IF;
124:
125: IF fnd_flex_val_api.valueset_exists('CPG_PO_QTY') THEN
118: fnd_flex_val_api.delete_valueset('CPG_SEC_UOM');
119: End IF;
120:
121: IF fnd_flex_val_api.valueset_exists('CPG_PO_NO') THEN
122: fnd_flex_val_api.delete_valueset('CPG_PO_NO');
123: End IF;
124:
125: IF fnd_flex_val_api.valueset_exists('CPG_PO_QTY') THEN
126: fnd_flex_val_api.delete_valueset('CPG_PO_QTY');
121: IF fnd_flex_val_api.valueset_exists('CPG_PO_NO') THEN
122: fnd_flex_val_api.delete_valueset('CPG_PO_NO');
123: End IF;
124:
125: IF fnd_flex_val_api.valueset_exists('CPG_PO_QTY') THEN
126: fnd_flex_val_api.delete_valueset('CPG_PO_QTY');
127: End IF;
128:
129: /* create value sets */
122: fnd_flex_val_api.delete_valueset('CPG_PO_NO');
123: End IF;
124:
125: IF fnd_flex_val_api.valueset_exists('CPG_PO_QTY') THEN
126: fnd_flex_val_api.delete_valueset('CPG_PO_QTY');
127: End IF;
128:
129: /* create value sets */
130:
127: End IF;
128:
129: /* create value sets */
130:
131: fnd_flex_val_api.create_valueset_table(
132: value_set_name => 'CPG_CO_CODE',
133: description => 'Displays co code',
134: security_available => 'N',
135: enable_longlist => 'Y',
153: id_column_type => NULL,
154: id_column_size => NULL,
155: where_order_by => 'Where co_code in (select co_code from gl_plcy_mst where org_id=:$PROFILES$.ORG_ID) Order by ORGN_CODE');
156:
157: fnd_flex_val_api.create_valueset_table(
158: value_set_name => 'CPG_PO_NO',
159: description => 'Displays Purchase Order Numbers',
160: security_available => 'N',
161: enable_longlist => 'Y',
181: where_order_by => 'Where POH.TYPE_LOOKUP_CODE in
182: (''STANDARD'', ''PLANNED'', ''BLANKET'')
183: AND POH.APPROVED_FLAG = ''Y''');
184:
185: fnd_flex_val_api.create_valueset_table(
186: value_set_name => 'CPG_QC_GRADE',
187: description => 'Displays qc grade',
188: security_available => 'N',
189: enable_longlist => 'Y',
207: id_column_type => NULL,
208: id_column_size => NULL,
209: where_order_by => 'Order by QC_GRADE');
210:
211: fnd_flex_val_api.create_valueset_table(
212: value_set_name => 'CPG_BASE_UOM',
213: description => 'Displays base uom',
214: security_available => 'N',
215: enable_longlist => 'Y',
230: id_column_type => NULL,
231: id_column_size => NULL,
232: where_order_by => 'where item_no=decode(:system.current_block, ''PO_LINES'', :po_lines.item_number, null)');
233:
234: fnd_flex_val_api.create_valueset_table(
235: value_set_name => 'CPG_SEC_UOM',
236: description => 'Displays secondary uom',
237: security_available => 'N',
238: enable_longlist => 'Y',
253: id_column_type => NULL,
254: id_column_size => NULL,
255: where_order_by => 'where item_no=decode(:system.current_block, ''PO_LINES'', :po_lines.item_number, null)');
256:
257: fnd_flex_val_api.create_valueset_none(
258: value_set_name => 'CPG_PO_QTY',
259: description => 'CPG Purchasing Base and Dual Qty',
260: security_available => 'N',
261: enable_longlist => 'N',