DBA Data[Home] [Help]

APPS.RMA_UPDATE dependencies on FND_FLEX_EXT

Line 226: segs FND_FLEX_EXT.SegmentArray;

222: Procedure gen_sales_order_id(r_number varchar2, r_type varchar2,
223: r_source_code varchar2, r_id OUT NOCOPY /* file.sql.39 change */ number) IS
224: success boolean := TRUE ;
225: xchar_formatted_date varchar2(200);
226: segs FND_FLEX_EXT.SegmentArray;
227: BEGIN
228:
229: /*
230: package is fnd_flex_ext

Line 230: package is fnd_flex_ext

226: segs FND_FLEX_EXT.SegmentArray;
227: BEGIN
228:
229: /*
230: package is fnd_flex_ext
231: FUNCTION get_combination_id(application_short_name IN VARCHAR2,
232: key_flex_code IN VARCHAR2,
233: structure_number IN NUMBER,
234: validation_date IN DATE,

Line 243: success := fnd_flex_ext.get_combination_id('INV', 'MKTS', 101,

239: segs(1) := r_number ;
240: segs(2) := r_type ;
241: segs(3) := r_source_code ;
242: xchar_formatted_date := to_char(Sysdate, 'YYYY/MM/DD');
243: success := fnd_flex_ext.get_combination_id('INV', 'MKTS', 101,
244: TO_DATE(xchar_formatted_date,'YYYY/MM/DD'), 3, segs, r_id) ;
245: if not success then
246: r_id := -9999 ;
247: end if;