DBA Data[Home] [Help]

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on FND_FLEX_KEY_API

Line 1131: lr_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

1127: ,p_cat_struct_id IN NUMBER
1128: )
1129: RETURN VARCHAR2
1130: IS
1131: lr_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1132: lr_structure_rec FND_FLEX_KEY_API.structure_type;
1133: lr_segment_rec FND_FLEX_KEY_API.segment_type;
1134: lt_segment_rec FND_FLEX_KEY_API.segment_list;
1135: ln_segment_number NUMBER;

Line 1132: lr_structure_rec FND_FLEX_KEY_API.structure_type;

1128: )
1129: RETURN VARCHAR2
1130: IS
1131: lr_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1132: lr_structure_rec FND_FLEX_KEY_API.structure_type;
1133: lr_segment_rec FND_FLEX_KEY_API.segment_type;
1134: lt_segment_rec FND_FLEX_KEY_API.segment_list;
1135: ln_segment_number NUMBER;
1136: lc_segment_number VARCHAR2 (850);

Line 1133: lr_segment_rec FND_FLEX_KEY_API.segment_type;

1129: RETURN VARCHAR2
1130: IS
1131: lr_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1132: lr_structure_rec FND_FLEX_KEY_API.structure_type;
1133: lr_segment_rec FND_FLEX_KEY_API.segment_type;
1134: lt_segment_rec FND_FLEX_KEY_API.segment_list;
1135: ln_segment_number NUMBER;
1136: lc_segment_number VARCHAR2 (850);
1137: lc_mcat_segs VARCHAR2 (2000);

Line 1134: lt_segment_rec FND_FLEX_KEY_API.segment_list;

1130: IS
1131: lr_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1132: lr_structure_rec FND_FLEX_KEY_API.structure_type;
1133: lr_segment_rec FND_FLEX_KEY_API.segment_type;
1134: lt_segment_rec FND_FLEX_KEY_API.segment_list;
1135: ln_segment_number NUMBER;
1136: lc_segment_number VARCHAR2 (850);
1137: lc_mcat_segs VARCHAR2 (2000);
1138:

Line 1141: FND_FLEX_KEY_API.set_session_mode ('customer_data');

1137: lc_mcat_segs VARCHAR2 (2000);
1138:
1139: BEGIN
1140:
1141: FND_FLEX_KEY_API.set_session_mode ('customer_data');
1142:
1143: IF p_type = 'ITEM' THEN -- Retrieve system item concatenated flexfield
1144: lc_segment_number := '';
1145: lr_flexfield_rec := FND_FLEX_KEY_API.find_flexfield ('INV', 'MSTK');

Line 1145: lr_flexfield_rec := FND_FLEX_KEY_API.find_flexfield ('INV', 'MSTK');

1141: FND_FLEX_KEY_API.set_session_mode ('customer_data');
1142:
1143: IF p_type = 'ITEM' THEN -- Retrieve system item concatenated flexfield
1144: lc_segment_number := '';
1145: lr_flexfield_rec := FND_FLEX_KEY_API.find_flexfield ('INV', 'MSTK');
1146: lr_structure_rec := FND_FLEX_KEY_API.find_structure (lr_flexfield_rec, p_cat_struct_id);
1147: FND_FLEX_KEY_API.get_segments (
1148: flexfield => lr_flexfield_rec
1149: ,structure => lr_structure_rec

Line 1146: lr_structure_rec := FND_FLEX_KEY_API.find_structure (lr_flexfield_rec, p_cat_struct_id);

1142:
1143: IF p_type = 'ITEM' THEN -- Retrieve system item concatenated flexfield
1144: lc_segment_number := '';
1145: lr_flexfield_rec := FND_FLEX_KEY_API.find_flexfield ('INV', 'MSTK');
1146: lr_structure_rec := FND_FLEX_KEY_API.find_structure (lr_flexfield_rec, p_cat_struct_id);
1147: FND_FLEX_KEY_API.get_segments (
1148: flexfield => lr_flexfield_rec
1149: ,structure => lr_structure_rec
1150: ,nsegments => ln_segment_number

Line 1147: FND_FLEX_KEY_API.get_segments (

1143: IF p_type = 'ITEM' THEN -- Retrieve system item concatenated flexfield
1144: lc_segment_number := '';
1145: lr_flexfield_rec := FND_FLEX_KEY_API.find_flexfield ('INV', 'MSTK');
1146: lr_structure_rec := FND_FLEX_KEY_API.find_structure (lr_flexfield_rec, p_cat_struct_id);
1147: FND_FLEX_KEY_API.get_segments (
1148: flexfield => lr_flexfield_rec
1149: ,structure => lr_structure_rec
1150: ,nsegments => ln_segment_number
1151: ,segments => lt_segment_rec

Line 1155: lr_segment_rec := FND_FLEX_KEY_API.find_segment (

1151: ,segments => lt_segment_rec
1152: );
1153:
1154: FOR l_idx IN 1..ln_segment_number LOOP
1155: lr_segment_rec := FND_FLEX_KEY_API.find_segment (
1156: lr_flexfield_rec
1157: ,lr_structure_rec
1158: ,lt_segment_rec (l_idx)
1159: );

Line 1174: lr_flexfield_rec := FND_FLEX_KEY_API.find_flexfield ('INV', 'MCAT');

1170: END IF;
1171:
1172: IF p_type = 'CAT' THEN -- Retrieve Item Category concatenated flexfield
1173: lc_mcat_segs := '';
1174: lr_flexfield_rec := FND_FLEX_KEY_API.find_flexfield ('INV', 'MCAT');
1175: lr_structure_rec := FND_FLEX_KEY_API.find_structure (
1176: lr_flexfield_rec
1177: ,p_cat_struct_id
1178: );

Line 1175: lr_structure_rec := FND_FLEX_KEY_API.find_structure (

1171:
1172: IF p_type = 'CAT' THEN -- Retrieve Item Category concatenated flexfield
1173: lc_mcat_segs := '';
1174: lr_flexfield_rec := FND_FLEX_KEY_API.find_flexfield ('INV', 'MCAT');
1175: lr_structure_rec := FND_FLEX_KEY_API.find_structure (
1176: lr_flexfield_rec
1177: ,p_cat_struct_id
1178: );
1179: FND_FLEX_KEY_API.get_segments (

Line 1179: FND_FLEX_KEY_API.get_segments (

1175: lr_structure_rec := FND_FLEX_KEY_API.find_structure (
1176: lr_flexfield_rec
1177: ,p_cat_struct_id
1178: );
1179: FND_FLEX_KEY_API.get_segments (
1180: flexfield => lr_flexfield_rec
1181: ,structure => lr_structure_rec
1182: ,nsegments => ln_segment_number
1183: ,segments => lt_segment_rec

Line 1187: lr_segment_rec := FND_FLEX_KEY_API.find_segment (

1183: ,segments => lt_segment_rec
1184: );
1185:
1186: FOR l_idx IN 1..ln_segment_number LOOP
1187: lr_segment_rec := FND_FLEX_KEY_API.find_segment (
1188: lr_flexfield_rec
1189: ,lr_structure_rec
1190: ,lt_segment_rec (l_idx)
1191: );