DBA Data[Home] [Help]

APPS.HR_UTIL_FLEX_WEB dependencies on FND_FLEX_KEY_API

Line 40: l_flexfield_rec fnd_flex_key_api.flexfield_type;

36: --
37: l_mapped_col_name1 varchar2(30) default null;
38: l_mapped_col_name2 varchar2(30) default null;
39: --
40: l_flexfield_rec fnd_flex_key_api.flexfield_type;
41: l_structure_rec fnd_flex_key_api.structure_type;
42: l_segment_rec1 fnd_flex_key_api.segment_type;
43: l_segment_rec2 fnd_flex_key_api.segment_type;
44: l_length number;

Line 41: l_structure_rec fnd_flex_key_api.structure_type;

37: l_mapped_col_name1 varchar2(30) default null;
38: l_mapped_col_name2 varchar2(30) default null;
39: --
40: l_flexfield_rec fnd_flex_key_api.flexfield_type;
41: l_structure_rec fnd_flex_key_api.structure_type;
42: l_segment_rec1 fnd_flex_key_api.segment_type;
43: l_segment_rec2 fnd_flex_key_api.segment_type;
44: l_length number;
45: l_index binary_integer default 0;

Line 42: l_segment_rec1 fnd_flex_key_api.segment_type;

38: l_mapped_col_name2 varchar2(30) default null;
39: --
40: l_flexfield_rec fnd_flex_key_api.flexfield_type;
41: l_structure_rec fnd_flex_key_api.structure_type;
42: l_segment_rec1 fnd_flex_key_api.segment_type;
43: l_segment_rec2 fnd_flex_key_api.segment_type;
44: l_length number;
45: l_index binary_integer default 0;
46:

Line 43: l_segment_rec2 fnd_flex_key_api.segment_type;

39: --
40: l_flexfield_rec fnd_flex_key_api.flexfield_type;
41: l_structure_rec fnd_flex_key_api.structure_type;
42: l_segment_rec1 fnd_flex_key_api.segment_type;
43: l_segment_rec2 fnd_flex_key_api.segment_type;
44: l_length number;
45: l_index binary_integer default 0;
46:
47: --

Line 358: fnd_flex_key_api.flexfield_type

354: ,p_id_flex_num in number
355: ,p_segment_name_valid out varchar2
356: ,p_tbl_col_name_used out varchar2
357: ,p_flexfield_rec out
358: fnd_flex_key_api.flexfield_type
359: ,p_structure_rec out
360: fnd_flex_key_api.structure_type) IS
361:
362: l_flexfield_rec fnd_flex_key_api.flexfield_type;

Line 360: fnd_flex_key_api.structure_type) IS

356: ,p_tbl_col_name_used out varchar2
357: ,p_flexfield_rec out
358: fnd_flex_key_api.flexfield_type
359: ,p_structure_rec out
360: fnd_flex_key_api.structure_type) IS
361:
362: l_flexfield_rec fnd_flex_key_api.flexfield_type;
363: l_structure_rec fnd_flex_key_api.structure_type;
364: l_segment_list fnd_flex_key_api.segment_list;

Line 362: l_flexfield_rec fnd_flex_key_api.flexfield_type;

358: fnd_flex_key_api.flexfield_type
359: ,p_structure_rec out
360: fnd_flex_key_api.structure_type) IS
361:
362: l_flexfield_rec fnd_flex_key_api.flexfield_type;
363: l_structure_rec fnd_flex_key_api.structure_type;
364: l_segment_list fnd_flex_key_api.segment_list;
365: l_index binary_integer default 0;
366: l_num_of_segments number default 0;

Line 363: l_structure_rec fnd_flex_key_api.structure_type;

359: ,p_structure_rec out
360: fnd_flex_key_api.structure_type) IS
361:
362: l_flexfield_rec fnd_flex_key_api.flexfield_type;
363: l_structure_rec fnd_flex_key_api.structure_type;
364: l_segment_list fnd_flex_key_api.segment_list;
365: l_index binary_integer default 0;
366: l_num_of_segments number default 0;
367: l_length number default 0;

Line 364: l_segment_list fnd_flex_key_api.segment_list;

360: fnd_flex_key_api.structure_type) IS
361:
362: l_flexfield_rec fnd_flex_key_api.flexfield_type;
363: l_structure_rec fnd_flex_key_api.structure_type;
364: l_segment_list fnd_flex_key_api.segment_list;
365: l_index binary_integer default 0;
366: l_num_of_segments number default 0;
367: l_length number default 0;
368: l_seg_name_tmp varchar2(100) default null;

Line 445: l_flexfield_rec := fnd_flex_key_api.find_flexfield

441: --
442: close csr_chk_flex_app_col_name;
443: --
444: ELSE -- check user segment name entered by the user
445: l_flexfield_rec := fnd_flex_key_api.find_flexfield
446: (p_app_short_name, p_flex_code);
447: --
448: l_structure_rec := fnd_flex_key_api.find_structure
449: (l_flexfield_rec, p_id_flex_num);

Line 448: l_structure_rec := fnd_flex_key_api.find_structure

444: ELSE -- check user segment name entered by the user
445: l_flexfield_rec := fnd_flex_key_api.find_flexfield
446: (p_app_short_name, p_flex_code);
447: --
448: l_structure_rec := fnd_flex_key_api.find_structure
449: (l_flexfield_rec, p_id_flex_num);
450: --
451: fnd_flex_key_api.get_segments(flexfield => l_flexfield_rec
452: ,structure => l_structure_rec

Line 451: fnd_flex_key_api.get_segments(flexfield => l_flexfield_rec

447: --
448: l_structure_rec := fnd_flex_key_api.find_structure
449: (l_flexfield_rec, p_id_flex_num);
450: --
451: fnd_flex_key_api.get_segments(flexfield => l_flexfield_rec
452: ,structure => l_structure_rec
453: ,enabled_only => True
454: ,nsegments => l_num_of_segments
455: ,segments => l_segment_list);

Line 516: fnd_flex_key_api.flexfield_type

512: ,p_segment_name2 in varchar2 default null
513: ,p_mapped_tbl_col_name1 out varchar2
514: ,p_mapped_tbl_col_name2 out varchar2
515: ,p_flexfield_rec in
516: fnd_flex_key_api.flexfield_type
517: ,p_structure_rec in
518: fnd_flex_key_api.structure_type) IS
519: --
520: -- ---------------------------------------------------------------------

Line 518: fnd_flex_key_api.structure_type) IS

514: ,p_mapped_tbl_col_name2 out varchar2
515: ,p_flexfield_rec in
516: fnd_flex_key_api.flexfield_type
517: ,p_structure_rec in
518: fnd_flex_key_api.structure_type) IS
519: --
520: -- ---------------------------------------------------------------------
521: -- Parameters values:
522: -- 1) p_app_short_name - 'PER' or 'PAY'

Line 532: l_flexfield_rec fnd_flex_key_api.flexfield_type;

528: -- ---------------------------------------------------------------------
529: l_mapped_col_name1 varchar2(30) default null;
530: l_mapped_col_name2 varchar2(30) default null;
531: --
532: l_flexfield_rec fnd_flex_key_api.flexfield_type;
533: l_structure_rec fnd_flex_key_api.structure_type;
534: l_segment_rec1 fnd_flex_key_api.segment_type;
535: l_segment_rec2 fnd_flex_key_api.segment_type;
536:

Line 533: l_structure_rec fnd_flex_key_api.structure_type;

529: l_mapped_col_name1 varchar2(30) default null;
530: l_mapped_col_name2 varchar2(30) default null;
531: --
532: l_flexfield_rec fnd_flex_key_api.flexfield_type;
533: l_structure_rec fnd_flex_key_api.structure_type;
534: l_segment_rec1 fnd_flex_key_api.segment_type;
535: l_segment_rec2 fnd_flex_key_api.segment_type;
536:
537: --

Line 534: l_segment_rec1 fnd_flex_key_api.segment_type;

530: l_mapped_col_name2 varchar2(30) default null;
531: --
532: l_flexfield_rec fnd_flex_key_api.flexfield_type;
533: l_structure_rec fnd_flex_key_api.structure_type;
534: l_segment_rec1 fnd_flex_key_api.segment_type;
535: l_segment_rec2 fnd_flex_key_api.segment_type;
536:
537: --
538: Begin

Line 535: l_segment_rec2 fnd_flex_key_api.segment_type;

531: --
532: l_flexfield_rec fnd_flex_key_api.flexfield_type;
533: l_structure_rec fnd_flex_key_api.structure_type;
534: l_segment_rec1 fnd_flex_key_api.segment_type;
535: l_segment_rec2 fnd_flex_key_api.segment_type;
536:
537: --
538: Begin
539: IF p_segment_name1 is not null THEN

Line 540: l_segment_rec1 := fnd_flex_key_api.find_segment

536:
537: --
538: Begin
539: IF p_segment_name1 is not null THEN
540: l_segment_rec1 := fnd_flex_key_api.find_segment
541: (p_flexfield_rec, p_structure_rec,
542: p_segment_name1);
543: l_mapped_col_name1 := l_segment_rec1.column_name;
544: p_mapped_tbl_col_name1 := l_mapped_col_name1;

Line 548: l_segment_rec2 := fnd_flex_key_api.find_segment

544: p_mapped_tbl_col_name1 := l_mapped_col_name1;
545: END IF;
546: --
547: IF p_segment_name2 is not null THEN
548: l_segment_rec2 := fnd_flex_key_api.find_segment
549: (p_flexfield_rec, p_structure_rec,
550: p_segment_name2);
551: l_mapped_col_name2 := l_segment_rec2.column_name;
552: p_mapped_tbl_col_name2 := l_mapped_col_name2;