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.

[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on FND_FLEX_KEY_API

Line 57: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;

53:
54: Procedure Create_Category_Sets IS
55:
56: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
57: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
58: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
59: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
60: l_segment FND_FLEX_KEY_API.segment_type;
61: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;

Line 58: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;

54: Procedure Create_Category_Sets IS
55:
56: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
57: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
58: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
59: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
60: l_segment FND_FLEX_KEY_API.segment_type;
61: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
62: l_flex_exists Boolean;

Line 59: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;

55:
56: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
57: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
58: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
59: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
60: l_segment FND_FLEX_KEY_API.segment_type;
61: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
62: l_flex_exists Boolean;
63: l_structure_exists Boolean;

Line 60: l_segment FND_FLEX_KEY_API.segment_type;

56: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
57: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
58: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
59: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
60: l_segment FND_FLEX_KEY_API.segment_type;
61: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
62: l_flex_exists Boolean;
63: l_structure_exists Boolean;
64: l_segment_exists Boolean;

Line 61: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;

57: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
58: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
59: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
60: l_segment FND_FLEX_KEY_API.segment_type;
61: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
62: l_flex_exists Boolean;
63: l_structure_exists Boolean;
64: l_segment_exists Boolean;
65: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;

Line 65: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;

61: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
62: l_flex_exists Boolean;
63: l_structure_exists Boolean;
64: l_segment_exists Boolean;
65: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;
66: msg VARCHAR2(1000);
67: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;
68:
69: l_structure_id NUMBER;

Line 76: fnd_flex_key_api.set_session_mode('seed_data');

72: l_next_val NUMBER;
73:
74: Begin
75:
76: fnd_flex_key_api.set_session_mode('seed_data');
77: l_flex_exists:= FALSE;
78:
79: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
80:

Line 79: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');

75:
76: fnd_flex_key_api.set_session_mode('seed_data');
77: l_flex_exists:= FALSE;
78:
79: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
80:
81: If l_flex_exists Then
82: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
83:

Line 82: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');

78:
79: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
80:
81: If l_flex_exists Then
82: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
83:
84: BEGIN
85: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'STATISTICAL_CODE');
86: l_structure_exists:=TRUE;

Line 85: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'STATISTICAL_CODE');

81: If l_flex_exists Then
82: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
83:
84: BEGIN
85: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'STATISTICAL_CODE');
86: l_structure_exists:=TRUE;
87:
88: EXCEPTION
89: WHEN OTHERS THEN

Line 90: msg := 'ERROR: struct not found' || fnd_flex_key_api.message;

86: l_structure_exists:=TRUE;
87:
88: EXCEPTION
89: WHEN OTHERS THEN
90: msg := 'ERROR: struct not found' || fnd_flex_key_api.message;
91: l_structure_exists:=FALSE;
92: END;
93:
94: IF NOT l_structure_exists THEN

Line 96: p_StatCode_struct:=fnd_flex_key_api.new_structure(flexfield => p_flexfield,

92: END;
93:
94: IF NOT l_structure_exists THEN
95: BEGIN
96: p_StatCode_struct:=fnd_flex_key_api.new_structure(flexfield => p_flexfield,
97: structure_code => 'STATISTICAL_CODE',
98: structure_title => 'Statistical Code',
99: description => 'Statistical Code',
100: view_name => NULL,

Line 111: fnd_flex_key_api.add_structure(p_flexfield,p_StatCode_struct);

107: shorthand_enabled_flag => 'N',
108: shorthand_prompt => NULL,
109: shorthand_length => NULL );
110:
111: fnd_flex_key_api.add_structure(p_flexfield,p_StatCode_struct);
112:
113:
114: BEGIN
115: -- Coded needed to instantiate the Structure

Line 116: p_statcode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'STATISTICAL_CODE');

112:
113:
114: BEGIN
115: -- Coded needed to instantiate the Structure
116: p_statcode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'STATISTICAL_CODE');
117: l_structure_exists:=TRUE;
118:
119: EXCEPTION
120: WHEN OTHERS THEN

Line 121: msg := SUBSTR('ERROR: struct not found' || fnd_flex_key_api.message,1,225);

117: l_structure_exists:=TRUE;
118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: msg := SUBSTR('ERROR: struct not found' || fnd_flex_key_api.message,1,225);
122: END;
123:
124: EXCEPTION
125: WHEN OTHERS THEN

Line 126: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);

122: END;
123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);
127: END;
128:
129: END IF;
130:

Line 134: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Code');

130:
131: IF l_structure_exists THEN
132:
133: BEGIN
134: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Code');
135: l_segment_exists:=TRUE;
136: EXCEPTION
137: WHEN OTHERS THEN
138: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);

Line 138: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);

134: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Code');
135: l_segment_exists:=TRUE;
136: EXCEPTION
137: WHEN OTHERS THEN
138: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);
139: l_segment_exists:=FALSE;
140: END;
141:
142: IF NOT l_segment_exists THEN

Line 144: p_StatCode_Segment:= fnd_flex_key_api.new_segment(flexfield => p_flexfield,

140: END;
141:
142: IF NOT l_segment_exists THEN
143: BEGIN
144: p_StatCode_Segment:= fnd_flex_key_api.new_segment(flexfield => p_flexfield,
145: structure => p_StatCode_struct,
146: segment_name => 'Code',
147: description => 'Code',
148: column_name => 'SEGMENT1',

Line 169: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

165: additional_where_clause => NULL);
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
170: END;
171:
172: BEGIN
173: fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);

Line 173: fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);

169: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
170: END;
171:
172: BEGIN
173: fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);
174: l_segment_exists:=TRUE;
175: EXCEPTION
176: WHEN OTHERS THEN
177: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

Line 177: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

173: fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);
174: l_segment_exists:=TRUE;
175: EXCEPTION
176: WHEN OTHERS THEN
177: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
178: l_segment_exists:=FALSE;
179: END;
180: END IF;
181:

Line 247: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;

243: p_category_set_desc IN VARCHAR2 )
244: IS
245:
246: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
247: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
248: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
249: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
250: l_segment FND_FLEX_KEY_API.segment_type;
251: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;

Line 248: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;

244: IS
245:
246: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
247: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
248: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
249: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
250: l_segment FND_FLEX_KEY_API.segment_type;
251: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
252: l_flex_exists Boolean;

Line 249: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;

245:
246: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
247: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
248: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
249: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
250: l_segment FND_FLEX_KEY_API.segment_type;
251: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
252: l_flex_exists Boolean;
253: l_structure_exists Boolean;

Line 250: l_segment FND_FLEX_KEY_API.segment_type;

246: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
247: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
248: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
249: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
250: l_segment FND_FLEX_KEY_API.segment_type;
251: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
252: l_flex_exists Boolean;
253: l_structure_exists Boolean;
254: l_segment_exists Boolean;

Line 251: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;

247: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
248: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
249: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
250: l_segment FND_FLEX_KEY_API.segment_type;
251: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
252: l_flex_exists Boolean;
253: l_structure_exists Boolean;
254: l_segment_exists Boolean;
255: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;

Line 255: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;

251: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
252: l_flex_exists Boolean;
253: l_structure_exists Boolean;
254: l_segment_exists Boolean;
255: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;
256: msg VARCHAR2(1000);
257: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;
258:
259: l_structure_id NUMBER;

Line 266: fnd_flex_key_api.set_session_mode('seed_data');

262: l_next_val NUMBER;
263:
264: Begin
265:
266: fnd_flex_key_api.set_session_mode('seed_data');
267: l_flex_exists:= FALSE;
268:
269: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
270:

Line 269: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');

265:
266: fnd_flex_key_api.set_session_mode('seed_data');
267: l_flex_exists:= FALSE;
268:
269: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
270:
271: If l_flex_exists Then
272: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
273:

Line 272: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');

268:
269: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
270:
271: If l_flex_exists Then
272: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
273:
274: BEGIN
275: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,p_structure_code);
276: l_structure_exists:=TRUE;

Line 275: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,p_structure_code);

271: If l_flex_exists Then
272: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
273:
274: BEGIN
275: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,p_structure_code);
276: l_structure_exists:=TRUE;
277:
278: EXCEPTION
279: WHEN OTHERS THEN

Line 280: msg := 'ERROR: struct not found' || fnd_flex_key_api.message;

276: l_structure_exists:=TRUE;
277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: msg := 'ERROR: struct not found' || fnd_flex_key_api.message;
281: l_structure_exists:=FALSE;
282: END;
283:
284: IF NOT l_structure_exists THEN

Line 286: p_StatCode_struct:=fnd_flex_key_api.new_structure(flexfield => p_flexfield,

282: END;
283:
284: IF NOT l_structure_exists THEN
285: BEGIN
286: p_StatCode_struct:=fnd_flex_key_api.new_structure(flexfield => p_flexfield,
287: structure_code => p_structure_code,
288: structure_title => p_structure_desc,
289: description => p_structure_desc,
290: view_name => NULL,

Line 301: fnd_flex_key_api.add_structure(p_flexfield,p_StatCode_struct);

297: shorthand_enabled_flag => 'N',
298: shorthand_prompt => NULL,
299: shorthand_length => NULL );
300:
301: fnd_flex_key_api.add_structure(p_flexfield,p_StatCode_struct);
302:
303:
304: BEGIN
305: -- Code needed to instantiate the Structure

Line 306: p_statcode_struct:= fnd_flex_key_api.find_structure(p_flexfield,p_structure_code);

302:
303:
304: BEGIN
305: -- Code needed to instantiate the Structure
306: p_statcode_struct:= fnd_flex_key_api.find_structure(p_flexfield,p_structure_code);
307: l_structure_exists:=TRUE;
308:
309: EXCEPTION
310: WHEN OTHERS THEN

Line 311: msg := SUBSTR('ERROR: struct not found' || fnd_flex_key_api.message,1,225);

307: l_structure_exists:=TRUE;
308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: msg := SUBSTR('ERROR: struct not found' || fnd_flex_key_api.message,1,225);
312: END;
313:
314: EXCEPTION
315: WHEN OTHERS THEN

Line 316: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);

312: END;
313:
314: EXCEPTION
315: WHEN OTHERS THEN
316: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);
317: END;
318:
319: END IF;
320:

Line 324: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Code');

320:
321: IF l_structure_exists THEN
322:
323: BEGIN
324: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Code');
325: l_segment_exists:=TRUE;
326: EXCEPTION
327: WHEN OTHERS THEN
328: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);

Line 328: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);

324: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Code');
325: l_segment_exists:=TRUE;
326: EXCEPTION
327: WHEN OTHERS THEN
328: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);
329: l_segment_exists:=FALSE;
330: END;
331:
332: IF NOT l_segment_exists THEN

Line 334: p_StatCode_Segment:= fnd_flex_key_api.new_segment(flexfield => p_flexfield,

330: END;
331:
332: IF NOT l_segment_exists THEN
333: BEGIN
334: p_StatCode_Segment:= fnd_flex_key_api.new_segment(flexfield => p_flexfield,
335: structure => p_StatCode_struct,
336: segment_name => 'Code',
337: description => 'Code',
338: column_name => 'SEGMENT1',

Line 359: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

355: additional_where_clause => NULL);
356:
357: EXCEPTION
358: WHEN OTHERS THEN
359: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
360: END;
361:
362: BEGIN
363: fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);

Line 363: fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);

359: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
360: END;
361:
362: BEGIN
363: fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);
364: l_segment_exists:=TRUE;
365: EXCEPTION
366: WHEN OTHERS THEN
367: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

Line 367: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

363: fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);
364: l_segment_exists:=TRUE;
365: EXCEPTION
366: WHEN OTHERS THEN
367: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
368: l_segment_exists:=FALSE;
369: END;
370: END IF;
371:

Line 638: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;

634: +===========================================================================*/
635:
636: PROCEDURE MTL_SYSTEM_ITEMS IS
637:
638: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
639:
640: l_structure_id mtl_category_sets_b.structure_id%TYPE;
641: l_category_status VARCHAR2(200);
642: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;

Line 1077: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;

1073:
1074: l_LANGUAGE zx_fc_types_tl.language%type;
1075: l_fc_id zx_fc_codes_b.classification_id%type;
1076: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;
1077: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1078: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1079: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1080: v_classification_code zx_fc_codes_b.classification_code%type;
1081: v_classification_name zx_fc_codes_tl.classification_name%type;

Line 1078: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;

1074: l_LANGUAGE zx_fc_types_tl.language%type;
1075: l_fc_id zx_fc_codes_b.classification_id%type;
1076: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;
1077: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1078: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1079: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1080: v_classification_code zx_fc_codes_b.classification_code%type;
1081: v_classification_name zx_fc_codes_tl.classification_name%type;
1082: v_effective_from date;

Line 1079: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;

1075: l_fc_id zx_fc_codes_b.classification_id%type;
1076: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;
1077: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1078: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1079: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1080: v_classification_code zx_fc_codes_b.classification_code%type;
1081: v_classification_name zx_fc_codes_tl.classification_name%type;
1082: v_effective_from date;
1083: v_effective_to date;

Line 4600: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;

4596: END CREATE_SEEDED_FC_TYPES;
4597:
4598:
4599: PROCEDURE OKL_MIGRATION IS
4600: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
4601: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4602: l_category_status VARCHAR2(200);
4603: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4604: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

Line 4621: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;

4617: -- l_errorcode number;
4618: -- l_msg_count number;
4619: -- l_MSG_DATA varchar2(200);
4620: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4621: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
4622: l_segment FND_FLEX_KEY_API.segment_type;
4623: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
4624: p_StatCode_Segmentnew FND_FLEX_KEY_API.segment_type;
4625: l_flex_exists Boolean;

Line 4622: l_segment FND_FLEX_KEY_API.segment_type;

4618: -- l_msg_count number;
4619: -- l_MSG_DATA varchar2(200);
4620: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4621: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
4622: l_segment FND_FLEX_KEY_API.segment_type;
4623: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
4624: p_StatCode_Segmentnew FND_FLEX_KEY_API.segment_type;
4625: l_flex_exists Boolean;
4626: l_structure_exists Boolean;

Line 4623: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;

4619: -- l_MSG_DATA varchar2(200);
4620: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4621: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
4622: l_segment FND_FLEX_KEY_API.segment_type;
4623: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
4624: p_StatCode_Segmentnew FND_FLEX_KEY_API.segment_type;
4625: l_flex_exists Boolean;
4626: l_structure_exists Boolean;
4627: l_segment_exists Boolean;

Line 4624: p_StatCode_Segmentnew FND_FLEX_KEY_API.segment_type;

4620: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4621: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
4622: l_segment FND_FLEX_KEY_API.segment_type;
4623: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
4624: p_StatCode_Segmentnew FND_FLEX_KEY_API.segment_type;
4625: l_flex_exists Boolean;
4626: l_structure_exists Boolean;
4627: l_segment_exists Boolean;
4628: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;

Line 4628: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;

4624: p_StatCode_Segmentnew FND_FLEX_KEY_API.segment_type;
4625: l_flex_exists Boolean;
4626: l_structure_exists Boolean;
4627: l_segment_exists Boolean;
4628: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;
4629: msg VARCHAR2(1000);
4630: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;
4631: -- l_control_level NUMBER;
4632: -- l_row_id VARCHAR2(100);

Line 4697: fnd_flex_key_api.set_session_mode('seed_data');

4693:
4694: -- Disable Lookup Type
4695: -- Change the Flexfield Structure Segment value Set.
4696: BEGIN
4697: fnd_flex_key_api.set_session_mode('seed_data');
4698: l_flex_exists:= FALSE;
4699:
4700: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
4701:

Line 4700: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');

4696: BEGIN
4697: fnd_flex_key_api.set_session_mode('seed_data');
4698: l_flex_exists:= FALSE;
4699:
4700: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
4701:
4702: If l_flex_exists Then
4703: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
4704:

Line 4703: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');

4699:
4700: l_flex_exists:= fnd_flex_key_api.flexfield_exists(appl_short_name => 'INV',flex_code => 'MCAT',flex_title => 'Item Categories');
4701:
4702: If l_flex_exists Then
4703: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
4704:
4705: BEGIN
4706: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'AR_TAX_PRODUCT_FISCAL_CLASS');
4707: l_structure_exists:=TRUE;

Line 4706: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'AR_TAX_PRODUCT_FISCAL_CLASS');

4702: If l_flex_exists Then
4703: p_flexfield:= fnd_flex_key_api.find_flexfield(appl_short_name => 'INV',flex_code => 'MCAT');
4704:
4705: BEGIN
4706: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'AR_TAX_PRODUCT_FISCAL_CLASS');
4707: l_structure_exists:=TRUE;
4708: EXCEPTION
4709: WHEN OTHERS THEN
4710: msg := 'ERROR: struct not found' || fnd_flex_key_api.message;

Line 4710: msg := 'ERROR: struct not found' || fnd_flex_key_api.message;

4706: p_StatCode_struct:= fnd_flex_key_api.find_structure(p_flexfield,'AR_TAX_PRODUCT_FISCAL_CLASS');
4707: l_structure_exists:=TRUE;
4708: EXCEPTION
4709: WHEN OTHERS THEN
4710: msg := 'ERROR: struct not found' || fnd_flex_key_api.message;
4711: l_structure_exists:=FALSE;
4712: END;
4713:
4714: IF l_structure_exists THEN

Line 4717: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Product Fiscal Classification');

4713:
4714: IF l_structure_exists THEN
4715: -- find current segment
4716: BEGIN
4717: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Product Fiscal Classification');
4718: l_segment_exists:=TRUE;
4719: EXCEPTION
4720: WHEN OTHERS THEN
4721: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);

Line 4721: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);

4717: p_StatCode_Segment:= fnd_flex_key_api.find_segment(flexfield=> p_flexfield,structure=> p_StatCode_struct,segment_name=>'Product Fiscal Classification');
4718: l_segment_exists:=TRUE;
4719: EXCEPTION
4720: WHEN OTHERS THEN
4721: msg := substr('ERROR: ' || fnd_flex_key_api.message,1,225);
4722: l_segment_exists:=FALSE;
4723: END;
4724:
4725: IF l_segment_exists THEN

Line 4728: p_StatCode_Segment:= fnd_flex_key_api.new_segment(flexfield => p_flexfield,

4724:
4725: IF l_segment_exists THEN
4726: -- Create new segment wich will replace the definition of current.
4727: BEGIN
4728: p_StatCode_Segment:= fnd_flex_key_api.new_segment(flexfield => p_flexfield,
4729: structure => p_StatCode_struct,
4730: segment_name => 'Product Fiscal Classification',
4731: description => 'Product Fiscal Classification',
4732: column_name => 'SEGMENT1',

Line 4752: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

4748: additional_where_clause => NULL);
4749:
4750: EXCEPTION
4751: WHEN OTHERS THEN
4752: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
4753: END;
4754:
4755: BEGIN
4756: -- fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);

Line 4756: -- fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);

4752: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
4753: END;
4754:
4755: BEGIN
4756: -- fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);
4757: fnd_flex_key_api.modify_segment(p_flexfield, p_StatCode_struct, p_StatCode_Segment, p_StatCode_Segmentnew);
4758: l_segment_exists:=TRUE;
4759: EXCEPTION
4760: WHEN OTHERS THEN

Line 4757: fnd_flex_key_api.modify_segment(p_flexfield, p_StatCode_struct, p_StatCode_Segment, p_StatCode_Segmentnew);

4753: END;
4754:
4755: BEGIN
4756: -- fnd_flex_key_api.add_segment(p_flexfield,p_StatCode_struct,p_StatCode_Segment);
4757: fnd_flex_key_api.modify_segment(p_flexfield, p_StatCode_struct, p_StatCode_Segment, p_StatCode_Segmentnew);
4758: l_segment_exists:=TRUE;
4759: EXCEPTION
4760: WHEN OTHERS THEN
4761: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

Line 4761: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);

4757: fnd_flex_key_api.modify_segment(p_flexfield, p_StatCode_struct, p_StatCode_Segment, p_StatCode_Segmentnew);
4758: l_segment_exists:=TRUE;
4759: EXCEPTION
4760: WHEN OTHERS THEN
4761: msg := SUBSTR('ERROR: ' || fnd_flex_key_api.message,1,225);
4762: l_segment_exists:=FALSE;
4763: END;
4764:
4765: END IF; -- Segment