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.

APPS.GL_REP_ATTRIBUTES dependencies on FND_FLEX_KEY_API

Line 10: lseg_gl_segs fnd_flex_key_api.segment_type; -- Segment Type

6: p_chart_of_accounts_id IN NUMBER) is
7: ---------------------
8: -- Flexfield API type
9: ---------------------
10: lseg_gl_segs fnd_flex_key_api.segment_type; -- Segment Type
11: lseg_glat_segs fnd_flex_key_api.segment_type; -- Segment Type
12: lseg_new_seg fnd_flex_key_api.segment_type;
13: lseg_att_new_seg fnd_flex_key_api.segment_type;
14: --

Line 11: lseg_glat_segs fnd_flex_key_api.segment_type; -- Segment Type

7: ---------------------
8: -- Flexfield API type
9: ---------------------
10: lseg_gl_segs fnd_flex_key_api.segment_type; -- Segment Type
11: lseg_glat_segs fnd_flex_key_api.segment_type; -- Segment Type
12: lseg_new_seg fnd_flex_key_api.segment_type;
13: lseg_att_new_seg fnd_flex_key_api.segment_type;
14: --
15: lstr_gl_struc fnd_flex_key_api.structure_type; -- Structure Type

Line 12: lseg_new_seg fnd_flex_key_api.segment_type;

8: -- Flexfield API type
9: ---------------------
10: lseg_gl_segs fnd_flex_key_api.segment_type; -- Segment Type
11: lseg_glat_segs fnd_flex_key_api.segment_type; -- Segment Type
12: lseg_new_seg fnd_flex_key_api.segment_type;
13: lseg_att_new_seg fnd_flex_key_api.segment_type;
14: --
15: lstr_gl_struc fnd_flex_key_api.structure_type; -- Structure Type
16: lstr_new_struc fnd_flex_key_api.structure_type;

Line 13: lseg_att_new_seg fnd_flex_key_api.segment_type;

9: ---------------------
10: lseg_gl_segs fnd_flex_key_api.segment_type; -- Segment Type
11: lseg_glat_segs fnd_flex_key_api.segment_type; -- Segment Type
12: lseg_new_seg fnd_flex_key_api.segment_type;
13: lseg_att_new_seg fnd_flex_key_api.segment_type;
14: --
15: lstr_gl_struc fnd_flex_key_api.structure_type; -- Structure Type
16: lstr_new_struc fnd_flex_key_api.structure_type;
17: lstr_glat_struc fnd_flex_key_api.structure_type;

Line 15: lstr_gl_struc fnd_flex_key_api.structure_type; -- Structure Type

11: lseg_glat_segs fnd_flex_key_api.segment_type; -- Segment Type
12: lseg_new_seg fnd_flex_key_api.segment_type;
13: lseg_att_new_seg fnd_flex_key_api.segment_type;
14: --
15: lstr_gl_struc fnd_flex_key_api.structure_type; -- Structure Type
16: lstr_new_struc fnd_flex_key_api.structure_type;
17: lstr_glat_struc fnd_flex_key_api.structure_type;
18: --
19: lflx_gl_flex fnd_flex_key_api.flexfield_type; -- Flexfield Type

Line 16: lstr_new_struc fnd_flex_key_api.structure_type;

12: lseg_new_seg fnd_flex_key_api.segment_type;
13: lseg_att_new_seg fnd_flex_key_api.segment_type;
14: --
15: lstr_gl_struc fnd_flex_key_api.structure_type; -- Structure Type
16: lstr_new_struc fnd_flex_key_api.structure_type;
17: lstr_glat_struc fnd_flex_key_api.structure_type;
18: --
19: lflx_gl_flex fnd_flex_key_api.flexfield_type; -- Flexfield Type
20: lflx_new_flex fnd_flex_key_api.flexfield_type;

Line 17: lstr_glat_struc fnd_flex_key_api.structure_type;

13: lseg_att_new_seg fnd_flex_key_api.segment_type;
14: --
15: lstr_gl_struc fnd_flex_key_api.structure_type; -- Structure Type
16: lstr_new_struc fnd_flex_key_api.structure_type;
17: lstr_glat_struc fnd_flex_key_api.structure_type;
18: --
19: lflx_gl_flex fnd_flex_key_api.flexfield_type; -- Flexfield Type
20: lflx_new_flex fnd_flex_key_api.flexfield_type;
21: lflx_glat_flex fnd_flex_key_api.flexfield_type;

Line 19: lflx_gl_flex fnd_flex_key_api.flexfield_type; -- Flexfield Type

15: lstr_gl_struc fnd_flex_key_api.structure_type; -- Structure Type
16: lstr_new_struc fnd_flex_key_api.structure_type;
17: lstr_glat_struc fnd_flex_key_api.structure_type;
18: --
19: lflx_gl_flex fnd_flex_key_api.flexfield_type; -- Flexfield Type
20: lflx_new_flex fnd_flex_key_api.flexfield_type;
21: lflx_glat_flex fnd_flex_key_api.flexfield_type;
22: --
23: llst_gl_seg_list fnd_flex_key_api.segment_list; -- Segment List

Line 20: lflx_new_flex fnd_flex_key_api.flexfield_type;

16: lstr_new_struc fnd_flex_key_api.structure_type;
17: lstr_glat_struc fnd_flex_key_api.structure_type;
18: --
19: lflx_gl_flex fnd_flex_key_api.flexfield_type; -- Flexfield Type
20: lflx_new_flex fnd_flex_key_api.flexfield_type;
21: lflx_glat_flex fnd_flex_key_api.flexfield_type;
22: --
23: llst_gl_seg_list fnd_flex_key_api.segment_list; -- Segment List
24: llst_glat_seg_list fnd_flex_key_api.segment_list;

Line 21: lflx_glat_flex fnd_flex_key_api.flexfield_type;

17: lstr_glat_struc fnd_flex_key_api.structure_type;
18: --
19: lflx_gl_flex fnd_flex_key_api.flexfield_type; -- Flexfield Type
20: lflx_new_flex fnd_flex_key_api.flexfield_type;
21: lflx_glat_flex fnd_flex_key_api.flexfield_type;
22: --
23: llst_gl_seg_list fnd_flex_key_api.segment_list; -- Segment List
24: llst_glat_seg_list fnd_flex_key_api.segment_list;
25: ---------------------

Line 23: llst_gl_seg_list fnd_flex_key_api.segment_list; -- Segment List

19: lflx_gl_flex fnd_flex_key_api.flexfield_type; -- Flexfield Type
20: lflx_new_flex fnd_flex_key_api.flexfield_type;
21: lflx_glat_flex fnd_flex_key_api.flexfield_type;
22: --
23: llst_gl_seg_list fnd_flex_key_api.segment_list; -- Segment List
24: llst_glat_seg_list fnd_flex_key_api.segment_list;
25: ---------------------
26: -- Value set API
27: ---------------------

Line 24: llst_glat_seg_list fnd_flex_key_api.segment_list;

20: lflx_new_flex fnd_flex_key_api.flexfield_type;
21: lflx_glat_flex fnd_flex_key_api.flexfield_type;
22: --
23: llst_gl_seg_list fnd_flex_key_api.segment_list; -- Segment List
24: llst_glat_seg_list fnd_flex_key_api.segment_list;
25: ---------------------
26: -- Value set API
27: ---------------------
28: lval_valueset fnd_vset.valueset_r;

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

199: --Find the Structure and Segments for the entered
200: --chart of accounts ID
201: --------------------------------------------------
202: BEGIN
203: fnd_flex_key_api.set_session_mode('seed_data');
204: --
205: lflx_gl_flex := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
206: lstr_gl_struc := fnd_flex_key_api.find_structure(lflx_gl_flex,p_coa_id);
207: fnd_flex_key_api.get_segments(flexfield=>lflx_gl_flex,

Line 205: lflx_gl_flex := fnd_flex_key_api.find_flexfield('SQLGL','GL#');

201: --------------------------------------------------
202: BEGIN
203: fnd_flex_key_api.set_session_mode('seed_data');
204: --
205: lflx_gl_flex := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
206: lstr_gl_struc := fnd_flex_key_api.find_structure(lflx_gl_flex,p_coa_id);
207: fnd_flex_key_api.get_segments(flexfield=>lflx_gl_flex,
208: structure=>lstr_gl_struc,
209: nsegments=>ln_gl_nsegs, --nseg stores the number of segments

Line 206: lstr_gl_struc := fnd_flex_key_api.find_structure(lflx_gl_flex,p_coa_id);

202: BEGIN
203: fnd_flex_key_api.set_session_mode('seed_data');
204: --
205: lflx_gl_flex := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
206: lstr_gl_struc := fnd_flex_key_api.find_structure(lflx_gl_flex,p_coa_id);
207: fnd_flex_key_api.get_segments(flexfield=>lflx_gl_flex,
208: structure=>lstr_gl_struc,
209: nsegments=>ln_gl_nsegs, --nseg stores the number of segments
210: segments=>llst_gl_seg_list);

Line 207: fnd_flex_key_api.get_segments(flexfield=>lflx_gl_flex,

203: fnd_flex_key_api.set_session_mode('seed_data');
204: --
205: lflx_gl_flex := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
206: lstr_gl_struc := fnd_flex_key_api.find_structure(lflx_gl_flex,p_coa_id);
207: fnd_flex_key_api.get_segments(flexfield=>lflx_gl_flex,
208: structure=>lstr_gl_struc,
209: nsegments=>ln_gl_nsegs, --nseg stores the number of segments
210: segments=>llst_gl_seg_list);
211: END;

Line 223: lflx_glat_flex :=fnd_flex_key_api.find_flexfield('SQLGL',

219: --delete records for GLAT Flexfield
220: --Also set the flag for new GLAT flexfield
221: ---------------------------------------------
222: BEGIN
223: lflx_glat_flex :=fnd_flex_key_api.find_flexfield('SQLGL',
224: 'GLAT');
225: EXCEPTION WHEN no_data_found THEN
226: lflx_new_flex := fnd_flex_key_api.new_flexfield
227: (appl_short_name =>lflx_gl_flex.appl_short_name,

Line 226: lflx_new_flex := fnd_flex_key_api.new_flexfield

222: BEGIN
223: lflx_glat_flex :=fnd_flex_key_api.find_flexfield('SQLGL',
224: 'GLAT');
225: EXCEPTION WHEN no_data_found THEN
226: lflx_new_flex := fnd_flex_key_api.new_flexfield
227: (appl_short_name =>lflx_gl_flex.appl_short_name,
228: flex_code =>'GLAT',
229: flex_title =>substr('Reporting Attributes:'||lflx_gl_flex.flex_title,1,30),
230: description =>substr('Reporting Attributes:'||lflx_gl_flex.description,1,240),

Line 241: fnd_flex_key_api.register(flexfield =>lflx_new_flex,

237: index_flag =>lflx_gl_flex.index_flag,
238: concat_seg_len_max =>lflx_gl_flex.concat_seg_len_max,
239: concat_len_warning =>lflx_gl_flex.concat_len_warning);
240: --
241: fnd_flex_key_api.register(flexfield =>lflx_new_flex,
242: enable_columns => 'Y');
243: --
244: lflx_glat_flex :=fnd_flex_key_api.find_flexfield('SQLGL',
245: 'GLAT');

Line 244: lflx_glat_flex :=fnd_flex_key_api.find_flexfield('SQLGL',

240: --
241: fnd_flex_key_api.register(flexfield =>lflx_new_flex,
242: enable_columns => 'Y');
243: --
244: lflx_glat_flex :=fnd_flex_key_api.find_flexfield('SQLGL',
245: 'GLAT');
246: --
247: lc_new_flex_flag :='Y';
248: END;

Line 265: lseg_gl_segs:=fnd_flex_key_api.find_segment(lflx_gl_flex,

261: -------------------------------------------------
262: ln_segs_ctr := 1;
263: ln_seg_num := 1;
264: WHILE ln_segs_ctr<=ln_gl_nsegs LOOP
265: lseg_gl_segs:=fnd_flex_key_api.find_segment(lflx_gl_flex,
266: lstr_gl_struc,
267: llst_gl_seg_list(ln_segs_ctr));
268: BEGIN
269: lstr_glat_struc:=fnd_flex_key_api.find_structure

Line 269: lstr_glat_struc:=fnd_flex_key_api.find_structure

265: lseg_gl_segs:=fnd_flex_key_api.find_segment(lflx_gl_flex,
266: lstr_gl_struc,
267: llst_gl_seg_list(ln_segs_ctr));
268: BEGIN
269: lstr_glat_struc:=fnd_flex_key_api.find_structure
270: (flexfield =>lflx_glat_flex,
271: structure_number=>p_coa_id);
272: EXCEPTION WHEN no_data_found THEN
273: --

Line 289: fnd_flex_key_api.add_structure(flexfield=>lflx_glat_flex,

285: lstr_new_struc.shorthand_enabled_flag:=lstr_gl_struc.shorthand_enabled_flag;
286: lstr_new_struc.shorthand_prompt :=lstr_gl_struc.shorthand_prompt;
287: lstr_new_struc.shorthand_length :=lstr_gl_struc.shorthand_length;
288: --
289: fnd_flex_key_api.add_structure(flexfield=>lflx_glat_flex,
290: structure=>lstr_new_struc);
291: --
292: lstr_glat_struc :=fnd_flex_key_api.find_structure(flexfield=>lflx_glat_flex,
293: structure_number=>p_coa_id);

Line 292: lstr_glat_struc :=fnd_flex_key_api.find_structure(flexfield=>lflx_glat_flex,

288: --
289: fnd_flex_key_api.add_structure(flexfield=>lflx_glat_flex,
290: structure=>lstr_new_struc);
291: --
292: lstr_glat_struc :=fnd_flex_key_api.find_structure(flexfield=>lflx_glat_flex,
293: structure_number=>p_coa_id);
294: END;
295:
296:

Line 307: ln_func:=fnd_flex_key_api.delete_flex_qualifier

303: FOR cv_del_seg_attr_cur in seg_attr_cur(p_coa_id,
304: 'GL#',
305: 101,
306: lseg_gl_segs.column_name) LOOP
307: ln_func:=fnd_flex_key_api.delete_flex_qualifier
308: (flexfield=>lflx_glat_flex,
309: qualifier_name=>cv_del_seg_attr_cur.segment_attribute_type);
310: END LOOP;
311: --

Line 312: fnd_flex_key_api.delete_structure(lflx_glat_flex,

308: (flexfield=>lflx_glat_flex,
309: qualifier_name=>cv_del_seg_attr_cur.segment_attribute_type);
310: END LOOP;
311: --
312: fnd_flex_key_api.delete_structure(lflx_glat_flex,
313: lstr_glat_struc);
314: ---------------------------------------
315: -- Create New structure for GLAT Flexfield
316: ----------------------------------------

Line 317: lflx_glat_flex :=fnd_flex_key_api.find_flexfield('SQLGL',

313: lstr_glat_struc);
314: ---------------------------------------
315: -- Create New structure for GLAT Flexfield
316: ----------------------------------------
317: lflx_glat_flex :=fnd_flex_key_api.find_flexfield('SQLGL',
318: 'GLAT');
319: --
320: lstr_new_struc.structure_number :=p_coa_id;
321: lstr_new_struc.structure_code :=lstr_gl_struc.structure_code;

Line 337: fnd_flex_key_api.add_structure(flexfield=>lflx_glat_flex,

333: lstr_new_struc.shorthand_length :=lstr_gl_struc.shorthand_length;
334: -------------------
335: --Add new structure
336: -------------------
337: fnd_flex_key_api.add_structure(flexfield=>lflx_glat_flex,
338: structure=>lstr_new_struc);
339: lstr_glat_struc:=fnd_flex_key_api.find_structure(flexfield=>lflx_glat_flex,
340: structure_number=>p_coa_id);
341: -- Set the flag so that this executes only once

Line 339: lstr_glat_struc:=fnd_flex_key_api.find_structure(flexfield=>lflx_glat_flex,

335: --Add new structure
336: -------------------
337: fnd_flex_key_api.add_structure(flexfield=>lflx_glat_flex,
338: structure=>lstr_new_struc);
339: lstr_glat_struc:=fnd_flex_key_api.find_structure(flexfield=>lflx_glat_flex,
340: structure_number=>p_coa_id);
341: -- Set the flag so that this executes only once
342: lc_new_flex_flag :='E';
343: END IF;

Line 364: lseg_new_seg:= fnd_flex_key_api.new_segment

360:
361: --
362:
363:
364: lseg_new_seg:= fnd_flex_key_api.new_segment
365: (flexfield =>lflx_glat_flex,
366: structure =>lstr_glat_struc,
367: segment_name =>lseg_gl_segs.segment_name,
368: description =>lseg_gl_segs.description,

Line 388: fnd_flex_key_api.add_segment(flexfield =>lflx_glat_flex,

384: window_prompt =>lseg_gl_segs.window_prompt);
385: --------------------------------------
386: --Add a new segment for GLAT Flexfield
387: --------------------------------------
388: fnd_flex_key_api.add_segment(flexfield =>lflx_glat_flex,
389: structure =>lstr_glat_struc,
390: segment =>lseg_new_seg);
391: ln_seg_num:=ln_seg_num+1;
392: END;

Line 403: lseg_att_new_seg:= fnd_flex_key_api.new_segment

399: FOR c_rep_attr_cur IN rep_attr_cur(lseg_gl_segs.column_name,lc_flex_val_set_name,101) LOOP
400: -------------------------------
401: --Create corresponding segments
402: -------------------------------
403: lseg_att_new_seg:= fnd_flex_key_api.new_segment
404: (flexfield =>lflx_glat_flex,
405: structure =>lstr_glat_struc,
406: segment_name =>c_rep_attr_cur.application_column_name,
407: description =>c_rep_attr_cur.description,

Line 426: fnd_flex_key_api.enable_column

422: lov_prompt =>c_rep_attr_cur.form_above_prompt,
423: window_prompt => c_rep_attr_cur.form_left_prompt);
424: --Enable SEGMENT_ATTRIBUTE columns
425: BEGIN
426: fnd_flex_key_api.enable_column
427: (lflx_glat_flex,lseg_att_new_seg.column_name);
428: EXCEPTION WHEN no_data_found THEN
429: null;
430: END;

Line 432: fnd_flex_key_api.add_segment(flexfield =>lflx_glat_flex,

428: EXCEPTION WHEN no_data_found THEN
429: null;
430: END;
431: --Add the Segments
432: fnd_flex_key_api.add_segment(flexfield =>lflx_glat_flex,
433: structure =>lstr_glat_struc,
434: segment =>lseg_att_new_seg);
435: ln_seg_num:=ln_seg_num+1;
436: END LOOP;

Line 447: fnd_flex_key_api.get_segments(flexfield=>lflx_glat_flex,

443: -----------------------------------------
444: -- Add the qualifiers for each segment
445: -----------------------------------------
446: BEGIN
447: fnd_flex_key_api.get_segments(flexfield=>lflx_glat_flex,
448: structure=>lstr_glat_struc,
449: nsegments=>ln_glat_nsegs,
450: segments=>llst_glat_seg_list);
451:

Line 455: lseg_glat_segs:=fnd_flex_key_api.find_segment(lflx_glat_flex,

451:
452:
453: ln_glat_segs_ctr := 1;
454: WHILE ln_glat_segs_ctr<=ln_glat_nsegs LOOP
455: lseg_glat_segs:=fnd_flex_key_api.find_segment(lflx_glat_flex,
456: lstr_glat_struc,
457: llst_glat_seg_list(ln_glat_segs_ctr));
458: FOR cv_seg_attr_cur in seg_attr_cur(p_coa_id,
459: 'GL#',

Line 463: fnd_flex_key_api.add_flex_qualifier

459: 'GL#',
460: 101,
461: lseg_glat_segs.column_name) LOOP
462: IF ln_flex_attr_flag=0 THEN
463: fnd_flex_key_api.add_flex_qualifier
464: (flexfield =>lflx_glat_flex,
465: qualifier_name=>cv_seg_attr_cur.segment_attribute_type,
466: prompt =>cv_seg_attr_cur.segment_prompt,
467: description =>cv_seg_attr_cur.description,

Line 472: fnd_flex_key_api.assign_qualifier

468: global_flag =>cv_seg_attr_cur.global_flag,
469: required_flag =>cv_seg_attr_cur.required_flag,
470: unique_flag =>cv_seg_attr_cur.unique_flag);
471: END IF;
472: fnd_flex_key_api.assign_qualifier
473: (flexfield =>lflx_glat_flex,
474: structure=>lstr_glat_struc,
475: segment=>lseg_glat_segs,
476: flexfield_qualifier=>cv_seg_attr_cur.segment_attribute_type,

Line 500: lstr_glat_struc:=fnd_flex_key_api.find_structure

496: FOR coa_cntr IN c_other_coas
497: LOOP
498: fnd_file.put_line(fnd_file.log, 'Processing chart of account : '||coa_cntr.id_flex_num);
499: BEGIN
500: lstr_glat_struc:=fnd_flex_key_api.find_structure
501: (flexfield => lflx_glat_flex,
502: structure_number=> coa_cntr.id_flex_num);
503:
504: fnd_flex_key_api.get_segments(flexfield=>lflx_glat_flex,

Line 504: fnd_flex_key_api.get_segments(flexfield=>lflx_glat_flex,

500: lstr_glat_struc:=fnd_flex_key_api.find_structure
501: (flexfield => lflx_glat_flex,
502: structure_number=> coa_cntr.id_flex_num);
503:
504: fnd_flex_key_api.get_segments(flexfield=>lflx_glat_flex,
505: structure=>lstr_glat_struc,
506: nsegments=>ln_glat_nsegs,
507: segments=>llst_glat_seg_list);
508:

Line 511: lseg_glat_segs:=fnd_flex_key_api.find_segment(lflx_glat_flex,

507: segments=>llst_glat_seg_list);
508:
509: ln_glat_segs_ctr := 1;
510: WHILE ln_glat_segs_ctr <= ln_glat_nsegs LOOP
511: lseg_glat_segs:=fnd_flex_key_api.find_segment(lflx_glat_flex,
512: lstr_glat_struc,
513: llst_glat_seg_list(ln_glat_segs_ctr));
514: FOR cv_seg_attr_cur in seg_attr_cur(coa_cntr.id_flex_num,
515: 'GL#',

Line 520: fnd_flex_key_api.assign_qualifier

516: 101,
517: lseg_glat_segs.column_name)
518: LOOP
519:
520: fnd_flex_key_api.assign_qualifier
521: (flexfield =>lflx_glat_flex,
522: structure=>lstr_glat_struc,
523: segment=>lseg_glat_segs,
524: flexfield_qualifier=>cv_seg_attr_cur.segment_attribute_type,

Line 557: lc_api_message:=fnd_flex_key_api.message;

553: fnd_file.put_line(FND_FILE.LOG,'ERROR :'||lc_err_message);
554: retcode := -1;
555: errbuf := null;
556: WHEN others THEN
557: lc_api_message:=fnd_flex_key_api.message;
558: fnd_file.put_line(FND_FILE.LOG,'Error:'||substr(lc_api_message,1,250));
559: retcode := -1;
560: errbuf := null;
561: END gl_preparation ;