DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB dependencies on FND_FLEX_EXT

Line 345: -- p_attribute_segments_tbl is required because the FND_FLEX_EXT package

341: -- Description:
342: -- Find the code combination ID number for the given set of key flexfield
343: -- segment values.
344: -- Notes:
345: -- p_attribute_segments_tbl is required because the FND_FLEX_EXT package
346: -- does not provide a "missing table" global variable. Instead, the
347: -- caller must pass in either an empty table, or a table with "missing"
348: -- strings.
349: --------------------------------------------------------------------------

Line 358: p_attribute_segments_tbl IN FND_FLEX_EXT.SegmentArray,

354: p_key_flex_code IN VARCHAR2,
355: p_structure_number IN NUMBER,
356: p_attribute_id IN NUMBER := FND_API.G_MISS_NUM,
357: p_attribute_conc_segs IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute_segments_tbl IN FND_FLEX_EXT.SegmentArray,
359: p_attribute_n_segments IN NUMBER := 0,
360: p_attribute_vals_or_ids IN VARCHAR2 := 'V',
361: p_data_set IN NUMBER := NULL,
362: p_resp_appl_id IN NUMBER := NULL,

Line 754: l_inventory_item_segments_tbl FND_FLEX_EXT.SegmentArray;

750:
751: l_inventory_org_id NUMBER := p_service_request_rec.inventory_org_id;
752: l_return_status VARCHAR2(1);
753: l_request_conv_rec Request_Conversion_Rec_Type;
754: l_inventory_item_segments_tbl FND_FLEX_EXT.SegmentArray;
755: i NUMBER := 0; -- counter
756: l_key_flex_code VARCHAR2(30);
757: l_inventory_item_id NUMBER;
758: l_request_rec cs_servicerequest_pvt.service_request_rec_type;

Line 2373: l_inventory_item_segments_tbl FND_FLEX_EXT.SegmentArray;

2369: l_update_desc_flex VARCHAR2(1) := FND_API.G_FALSE;
2370: l_request_id NUMBER;
2371:
2372: l_request_conv_rec Request_Conversion_Rec_Type;
2373: l_inventory_item_segments_tbl FND_FLEX_EXT.SegmentArray;
2374: i NUMBER := 0; -- counter
2375: l_key_flex_code VARCHAR2(30);
2376:
2377: -- Added for making call to private Update API which uses the private rec type -- anmukher -- 08/13/03

Line 4291: p_attribute_segments_tbl IN FND_FLEX_EXT.SegmentArray,

4287: p_key_flex_code IN VARCHAR2,
4288: p_structure_number IN NUMBER,
4289: p_attribute_id IN NUMBER := FND_API.G_MISS_NUM,
4290: p_attribute_conc_segs IN VARCHAR2 := FND_API.G_MISS_CHAR,
4291: p_attribute_segments_tbl IN FND_FLEX_EXT.SegmentArray,
4292: p_attribute_n_segments IN NUMBER := 0,
4293: p_attribute_vals_or_ids IN VARCHAR2 := 'V',
4294: p_data_set IN NUMBER := NULL,
4295: p_resp_appl_id IN NUMBER := NULL,

Line 4338: l_delimiter := FND_FLEX_EXT.Get_Delimiter

4334: ELSIF (p_attribute_n_segments <> 0) THEN
4335: -- If caller did not pass in the concatenated segments but passed in the
4336: -- individual segments instead, need to first convert them into a string
4337: -- of concatenated segments before finding the combination ID.
4338: l_delimiter := FND_FLEX_EXT.Get_Delimiter
4339: ( application_short_name => p_application_short_name,
4340: key_flex_code => p_key_flex_code,
4341: structure_number => p_structure_number
4342: );

Line 4343: l_attribute_conc_segs := FND_FLEX_EXT.Concatenate_Segments

4339: ( application_short_name => p_application_short_name,
4340: key_flex_code => p_key_flex_code,
4341: structure_number => p_structure_number
4342: );
4343: l_attribute_conc_segs := FND_FLEX_EXT.Concatenate_Segments
4344: ( n_segments => p_attribute_n_segments,
4345: segments => p_attribute_segments_tbl,
4346: delimiter => l_delimiter
4347: );