DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_FLEX_KEY_API

Line 919: l_flexfield fnd_flex_key_api.flexfield_type;

915: ,p_shorthand_prompt in varchar2 default null
916: ,p_shorthand_length in number default null)
917: RETURN NUMBER IS
918:
919: l_flexfield fnd_flex_key_api.flexfield_type;
920: l_structure fnd_flex_key_api.structure_type;
921: l_application_id number(15);
922: l_proc varchar2(80) := g_package || 'create_key_flexfield';
923: l_log_message varchar2(360);

Line 920: l_structure fnd_flex_key_api.structure_type;

916: ,p_shorthand_length in number default null)
917: RETURN NUMBER IS
918:
919: l_flexfield fnd_flex_key_api.flexfield_type;
920: l_structure fnd_flex_key_api.structure_type;
921: l_application_id number(15);
922: l_proc varchar2(80) := g_package || 'create_key_flexfield';
923: l_log_message varchar2(360);
924:

Line 928: fnd_flex_key_api.set_session_mode('customer_data');

924:
925: BEGIN
926: hr_utility.set_location('Entering:'|| l_proc, 10);
927:
928: fnd_flex_key_api.set_session_mode('customer_data');
929:
930: l_flexfield := fnd_flex_key_api.find_flexfield
931: (appl_short_name => p_appl_short_name
932: ,flex_code => p_flex_code );

Line 930: l_flexfield := fnd_flex_key_api.find_flexfield

926: hr_utility.set_location('Entering:'|| l_proc, 10);
927:
928: fnd_flex_key_api.set_session_mode('customer_data');
929:
930: l_flexfield := fnd_flex_key_api.find_flexfield
931: (appl_short_name => p_appl_short_name
932: ,flex_code => p_flex_code );
933:
934: hr_utility.set_location(l_proc, 20);

Line 937: l_structure := fnd_flex_key_api.find_structure

933:
934: hr_utility.set_location(l_proc, 20);
935:
936: BEGIN
937: l_structure := fnd_flex_key_api.find_structure
938: (flexfield => l_flexfield,
939: structure_code => p_structure_code );
940:
941: return l_structure.structure_number;

Line 946: l_structure:=fnd_flex_key_api.new_structure

942: hr_utility.set_location('Entering:'|| l_proc, 30);
943: EXCEPTION
944: WHEN NO_DATA_FOUND THEN
945: hr_utility.set_location(l_proc, 40);
946: l_structure:=fnd_flex_key_api.new_structure
947: (flexfield => l_flexfield,
948: structure_code => p_structure_code,
949: structure_title => p_structure_title,
950: description => p_description,

Line 974: fnd_flex_key_api.add_structure

970: WHERE ifs.application_id = l_application_id
971: AND ifs.id_flex_code = p_flex_code
972: AND ifs.id_flex_num < 101;
973:
974: fnd_flex_key_api.add_structure
975: ( flexfield => l_flexfield,
976: structure => l_structure );
977:
978: RETURN l_structure.structure_number;

Line 1026: l_flexfield fnd_flex_key_api.flexfield_type;

1022: ,p_window_prompt in varchar2
1023: ,p_segment_type in varchar2 default 'CHAR'
1024: ,p_fed_seg_attribute in varchar2 default 'N') IS
1025:
1026: l_flexfield fnd_flex_key_api.flexfield_type;
1027: l_structure fnd_flex_key_api.structure_type;
1028: l_application_id number(15);
1029: l_flex_num number(15);
1030: l_segment fnd_flex_key_api.segment_type;

Line 1027: l_structure fnd_flex_key_api.structure_type;

1023: ,p_segment_type in varchar2 default 'CHAR'
1024: ,p_fed_seg_attribute in varchar2 default 'N') IS
1025:
1026: l_flexfield fnd_flex_key_api.flexfield_type;
1027: l_structure fnd_flex_key_api.structure_type;
1028: l_application_id number(15);
1029: l_flex_num number(15);
1030: l_segment fnd_flex_key_api.segment_type;
1031: l_valueset_seq number(9);

Line 1030: l_segment fnd_flex_key_api.segment_type;

1026: l_flexfield fnd_flex_key_api.flexfield_type;
1027: l_structure fnd_flex_key_api.structure_type;
1028: l_application_id number(15);
1029: l_flex_num number(15);
1030: l_segment fnd_flex_key_api.segment_type;
1031: l_valueset_seq number(9);
1032: l_valueset_name fnd_flex_value_sets.flex_value_set_name%type;
1033:
1034: l_proc varchar2(80) := g_package || 'create_flex_segments';

Line 1041: fnd_flex_key_api.set_session_mode('customer_data');

1037: BEGIN
1038:
1039: hr_utility.set_location('Entering:'|| l_proc, 10);
1040:
1041: fnd_flex_key_api.set_session_mode('customer_data');
1042:
1043: l_flexfield := fnd_flex_key_api.find_flexfield
1044: (appl_short_name => p_appl_short_name
1045: ,flex_code => p_flex_code );

Line 1043: l_flexfield := fnd_flex_key_api.find_flexfield

1039: hr_utility.set_location('Entering:'|| l_proc, 10);
1040:
1041: fnd_flex_key_api.set_session_mode('customer_data');
1042:
1043: l_flexfield := fnd_flex_key_api.find_flexfield
1044: (appl_short_name => p_appl_short_name
1045: ,flex_code => p_flex_code );
1046:
1047: hr_utility.set_location(l_proc, 20);

Line 1049: l_structure := fnd_flex_key_api.find_structure

1045: ,flex_code => p_flex_code );
1046:
1047: hr_utility.set_location(l_proc, 20);
1048:
1049: l_structure := fnd_flex_key_api.find_structure
1050: (flexfield => l_flexfield
1051: ,structure_code => p_structure_code );
1052: BEGIN
1053: hr_utility.trace(p_segment_name);

Line 1054: l_segment := fnd_flex_key_api.find_segment

1050: (flexfield => l_flexfield
1051: ,structure_code => p_structure_code );
1052: BEGIN
1053: hr_utility.trace(p_segment_name);
1054: l_segment := fnd_flex_key_api.find_segment
1055: (flexfield => l_flexfield
1056: ,structure => l_structure
1057: ,segment_name => p_segment_name);
1058: hr_utility.set_location('Entering:'|| l_proc, 30);

Line 1083: l_segment:= fnd_flex_key_api.new_segment

1079: if p_fed_seg_attribute = 'Y' then
1080: l_valueset_name := p_value_set;
1081: end if;
1082:
1083: l_segment:= fnd_flex_key_api.new_segment
1084: (flexfield => l_flexfield
1085: ,structure => l_structure
1086: ,segment_name => p_segment_name
1087: ,description => null

Line 1109: fnd_flex_key_api.add_segment(flexfield => l_flexfield

1105:
1106: hr_utility.trace(p_segment_name);
1107: BEGIN
1108: hr_utility.set_location(l_proc, 110);
1109: fnd_flex_key_api.add_segment(flexfield => l_flexfield
1110: ,structure => l_structure
1111: ,segment => l_segment);
1112: --
1113: --assign qualifiers for CMP and COST KF.

Line 1118: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,

1114: --
1115:
1116: if p_flex_code = 'CMP' and p_appl_short_name = 'PER' then
1117: hr_utility.trace('Assigning Qualifiers 111');
1118: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,
1119: structure => l_structure,
1120: segment => l_segment,
1121: flexfield_qualifier => 'Default Attribute',
1122: enable_flag => 'Y');

Line 1125: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,

1121: flexfield_qualifier => 'Default Attribute',
1122: enable_flag => 'Y');
1123: hr_utility.trace('Assigned Qualifier CMP : Default Attribute');
1124:
1125: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,
1126: structure => l_structure,
1127: segment => l_segment,
1128: flexfield_qualifier => 'Others',
1129: enable_flag => 'Y');

Line 1133: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,

1129: enable_flag => 'Y');
1130: end if;
1131:
1132: if p_flex_code = 'COST' and p_appl_short_name = 'PAY' then
1133: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,
1134: structure => l_structure,
1135: segment => l_segment,
1136: flexfield_qualifier => 'ASSIGNMENT',
1137: enable_flag => 'Y');

Line 1140: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,

1136: flexfield_qualifier => 'ASSIGNMENT',
1137: enable_flag => 'Y');
1138: hr_utility.trace('assigned qualifier COST : ASSIGNMENT');
1139:
1140: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,
1141: structure => l_structure,
1142: segment => l_segment,
1143: flexfield_qualifier => 'BALANCING',
1144: enable_flag => 'Y');

Line 1147: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,

1143: flexfield_qualifier => 'BALANCING',
1144: enable_flag => 'Y');
1145: hr_utility.trace('assigned qualifier COST : BALANCING');
1146:
1147: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,
1148: structure => l_structure,
1149: segment => l_segment,
1150: flexfield_qualifier => 'ELEMENT',
1151: enable_flag => 'Y');

Line 1154: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,

1150: flexfield_qualifier => 'ELEMENT',
1151: enable_flag => 'Y');
1152: hr_utility.trace('assigned qualifier COST : ELEMENT');
1153:
1154: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,
1155: structure => l_structure,
1156: segment => l_segment,
1157: flexfield_qualifier => 'ELEMENT ENTRY',
1158: enable_flag => 'Y');

Line 1161: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,

1157: flexfield_qualifier => 'ELEMENT ENTRY',
1158: enable_flag => 'Y');
1159: hr_utility.trace('assigned qualifier COST : ELEMENT ENTRY');
1160:
1161: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,
1162: structure => l_structure,
1163: segment => l_segment,
1164: flexfield_qualifier => 'ORGANIZATION',
1165: enable_flag => 'Y');

Line 1168: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,

1164: flexfield_qualifier => 'ORGANIZATION',
1165: enable_flag => 'Y');
1166: hr_utility.trace('assigned qualifier COST : ORGANIZATION');
1167:
1168: fnd_flex_key_api.assign_qualifier(flexfield => l_flexfield,
1169: structure => l_structure,
1170: segment => l_segment,
1171: flexfield_qualifier => 'PAYROLL',
1172: enable_flag => 'Y');

Line 1178: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));

1174: end if;
1175:
1176: EXCEPTION
1177: when others then
1178: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1179: END;
1180:
1181: END;
1182:

Line 1951: l_flexfield fnd_flex_key_api.flexfield_type;

1947:
1948: l_proc varchar2(72) := g_package || 'freeze_and_compile_flexfield';
1949: l_error_message varchar2(360);
1950: l_log_message varchar2(360);
1951: l_flexfield fnd_flex_key_api.flexfield_type;
1952: l_structure fnd_flex_key_api.structure_type;
1953: l_new_structure fnd_flex_key_api.structure_type;
1954: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;
1955: l_request_id number(9);

Line 1952: l_structure fnd_flex_key_api.structure_type;

1948: l_proc varchar2(72) := g_package || 'freeze_and_compile_flexfield';
1949: l_error_message varchar2(360);
1950: l_log_message varchar2(360);
1951: l_flexfield fnd_flex_key_api.flexfield_type;
1952: l_structure fnd_flex_key_api.structure_type;
1953: l_new_structure fnd_flex_key_api.structure_type;
1954: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;
1955: l_request_id number(9);
1956:

Line 1953: l_new_structure fnd_flex_key_api.structure_type;

1949: l_error_message varchar2(360);
1950: l_log_message varchar2(360);
1951: l_flexfield fnd_flex_key_api.flexfield_type;
1952: l_structure fnd_flex_key_api.structure_type;
1953: l_new_structure fnd_flex_key_api.structure_type;
1954: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;
1955: l_request_id number(9);
1956:
1957: BEGIN

Line 1964: fnd_flex_key_api.set_session_mode('customer_data');

1960: open flex_num_cursor;
1961: fetch flex_num_cursor into l_id_flex_num;
1962: close flex_num_cursor;
1963:
1964: fnd_flex_key_api.set_session_mode('customer_data');
1965:
1966: l_flexfield := fnd_flex_key_api.find_flexfield
1967: (appl_short_name => p_appl_short_name
1968: ,flex_code => p_flex_code );

Line 1966: l_flexfield := fnd_flex_key_api.find_flexfield

1962: close flex_num_cursor;
1963:
1964: fnd_flex_key_api.set_session_mode('customer_data');
1965:
1966: l_flexfield := fnd_flex_key_api.find_flexfield
1967: (appl_short_name => p_appl_short_name
1968: ,flex_code => p_flex_code );
1969:
1970: hr_utility.set_location(l_proc, 20);

Line 1972: l_structure := fnd_flex_key_api.find_structure

1968: ,flex_code => p_flex_code );
1969:
1970: hr_utility.set_location(l_proc, 20);
1971:
1972: l_structure := fnd_flex_key_api.find_structure
1973: (flexfield => l_flexfield
1974: ,structure_code => p_structure_code );
1975:
1976: hr_utility.set_location(l_proc, 30);

Line 1987: fnd_flex_key_api.modify_structure(l_flexfield, l_structure,l_new_structure);

1983: l_new_structure.freeze_flag := 'Y';
1984:
1985: hr_utility.set_location('Entering:'|| l_proc, 30);
1986:
1987: fnd_flex_key_api.modify_structure(l_flexfield, l_structure,l_new_structure);
1988:
1989: --
1990: -- compile flexfield
1991: --