DBA Data[Home] [Help]

APPS.GML_PO_CREATE_FLEXFIELDS dependencies on FND_FLEX_VAL_API

Line 101: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');

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

Line 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

Line 106: fnd_flex_val_api.delete_valueset('CPG_CO_CODE');

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');

Line 109: IF fnd_flex_val_api.valueset_exists('CPG_QC_GRADE') THEN

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

Line 110: fnd_flex_val_api.delete_valueset('CPG_QC_GRADE');

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');

Line 113: IF fnd_flex_val_api.valueset_exists('CPG_BASE_UOM') THEN

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

Line 114: fnd_flex_val_api.delete_valueset('CPG_BASE_UOM');

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');

Line 117: IF fnd_flex_val_api.valueset_exists('CPG_SEC_UOM') THEN

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

Line 118: fnd_flex_val_api.delete_valueset('CPG_SEC_UOM');

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');

Line 121: IF fnd_flex_val_api.valueset_exists('CPG_PO_NO') THEN

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

Line 122: fnd_flex_val_api.delete_valueset('CPG_PO_NO');

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');

Line 125: IF fnd_flex_val_api.valueset_exists('CPG_PO_QTY') THEN

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 */

Line 126: fnd_flex_val_api.delete_valueset('CPG_PO_QTY');

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:

Line 131: fnd_flex_val_api.create_valueset_table(

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',

Line 157: fnd_flex_val_api.create_valueset_table(

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',

Line 185: fnd_flex_val_api.create_valueset_table(

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',

Line 211: fnd_flex_val_api.create_valueset_table(

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',

Line 234: fnd_flex_val_api.create_valueset_table(

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',

Line 257: fnd_flex_val_api.create_valueset_none(

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',