DBA Data[Home] [Help]

APPS.INV_FLEXNUM dependencies on FND_FLEX_KEY_API

Line 7: flexff fnd_flex_key_api.flexfield_type ;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_FLEXNUM';
5:
6: Function INV_GETNUM return VARCHAR2 IS
7: flexff fnd_flex_key_api.flexfield_type ;
8: strcff fnd_flex_key_api.structure_type ;
9: numsegs number ;
10: seglist fnd_flex_key_api.segment_list ;
11: segtype fnd_flex_key_api.segment_type ;

Line 8: strcff fnd_flex_key_api.structure_type ;

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_FLEXNUM';
5:
6: Function INV_GETNUM return VARCHAR2 IS
7: flexff fnd_flex_key_api.flexfield_type ;
8: strcff fnd_flex_key_api.structure_type ;
9: numsegs number ;
10: seglist fnd_flex_key_api.segment_list ;
11: segtype fnd_flex_key_api.segment_type ;
12: i NUMBER;

Line 10: seglist fnd_flex_key_api.segment_list ;

6: Function INV_GETNUM return VARCHAR2 IS
7: flexff fnd_flex_key_api.flexfield_type ;
8: strcff fnd_flex_key_api.structure_type ;
9: numsegs number ;
10: seglist fnd_flex_key_api.segment_list ;
11: segtype fnd_flex_key_api.segment_type ;
12: i NUMBER;
13: d VARCHAR2(100);
14: begin

Line 11: segtype fnd_flex_key_api.segment_type ;

7: flexff fnd_flex_key_api.flexfield_type ;
8: strcff fnd_flex_key_api.structure_type ;
9: numsegs number ;
10: seglist fnd_flex_key_api.segment_list ;
11: segtype fnd_flex_key_api.segment_type ;
12: i NUMBER;
13: d VARCHAR2(100);
14: begin
15: fnd_flex_key_api.set_session_mode('seed_data');

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

11: segtype fnd_flex_key_api.segment_type ;
12: i NUMBER;
13: d VARCHAR2(100);
14: begin
15: fnd_flex_key_api.set_session_mode('seed_data');
16: flexff := fnd_flex_key_api.find_flexfield('INV','MTLL') ;
17: strcff := fnd_flex_key_api.find_structure(flexff,101) ;
18: fnd_flex_key_api.get_segments(flexff,strcff,TRUE,numsegs,seglist) ;
19: i := 1;

Line 16: flexff := fnd_flex_key_api.find_flexfield('INV','MTLL') ;

12: i NUMBER;
13: d VARCHAR2(100);
14: begin
15: fnd_flex_key_api.set_session_mode('seed_data');
16: flexff := fnd_flex_key_api.find_flexfield('INV','MTLL') ;
17: strcff := fnd_flex_key_api.find_structure(flexff,101) ;
18: fnd_flex_key_api.get_segments(flexff,strcff,TRUE,numsegs,seglist) ;
19: i := 1;
20: d := 'ALL';

Line 17: strcff := fnd_flex_key_api.find_structure(flexff,101) ;

13: d VARCHAR2(100);
14: begin
15: fnd_flex_key_api.set_session_mode('seed_data');
16: flexff := fnd_flex_key_api.find_flexfield('INV','MTLL') ;
17: strcff := fnd_flex_key_api.find_structure(flexff,101) ;
18: fnd_flex_key_api.get_segments(flexff,strcff,TRUE,numsegs,seglist) ;
19: i := 1;
20: d := 'ALL';
21: WHILE (i <= numsegs) LOOP

Line 18: fnd_flex_key_api.get_segments(flexff,strcff,TRUE,numsegs,seglist) ;

14: begin
15: fnd_flex_key_api.set_session_mode('seed_data');
16: flexff := fnd_flex_key_api.find_flexfield('INV','MTLL') ;
17: strcff := fnd_flex_key_api.find_structure(flexff,101) ;
18: fnd_flex_key_api.get_segments(flexff,strcff,TRUE,numsegs,seglist) ;
19: i := 1;
20: d := 'ALL';
21: WHILE (i <= numsegs) LOOP
22: segtype := fnd_flex_key_api.find_segment(flexff,strcff,seglist(i)) ;

Line 22: segtype := fnd_flex_key_api.find_segment(flexff,strcff,seglist(i)) ;

18: fnd_flex_key_api.get_segments(flexff,strcff,TRUE,numsegs,seglist) ;
19: i := 1;
20: d := 'ALL';
21: WHILE (i <= numsegs) LOOP
22: segtype := fnd_flex_key_api.find_segment(flexff,strcff,seglist(i)) ;
23: IF (segtype.column_name = 'SEGMENT19') THEN
24: d := d || '\\0' || i;
25: ELSIF (segtype.column_name = 'SEGMENT20') THEN
26: d := d || '\\0' || i;