APPS.FA_RX_FLEX_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 280: from fnd_id_flex_structures

276: return p_id_flex_num;
277: end if;
278:
279: select id_flex_num into l_id_flex_num
280: from fnd_id_flex_structures
281: where application_id = p_application_id
282: and id_flex_code = p_id_flex_code;
283:
284: return l_id_flex_num;

Line 320: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;

316: p_application_id in number,
317: p_id_flex_code in varchar2,
318: p_id_flex_num in number) return varchar2
319: is
320: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
321: begin
322: select concatenated_segment_delimiter into sep
323: from fnd_id_flex_structures
324: where application_id = p_application_id

Line 323: from fnd_id_flex_structures

319: is
320: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
321: begin
322: select concatenated_segment_delimiter into sep
323: from fnd_id_flex_structures
324: where application_id = p_application_id
325: and id_flex_code = p_id_flex_code
326: and id_flex_num = p_id_flex_num;
327:

Line 402: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;

398: segnum fnd_id_flex_segments.segment_num%type;
399: colname fnd_id_flex_segments.application_column_name%type;
400: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
401:
402: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
403: op1 seg_array;
404: op2 seg_array;
405:
406: i number;

Line 595: l_sep fnd_id_flex_structures.concatenated_segment_delimiter%type;

591: sqlstmt varchar2(2000);
592:
593: l_table_name varchar2(30);
594: l_unique_id_column_name varchar2(30);
595: l_sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
596: c integer;
597: rows integer;
598: segnum fnd_id_flex_segments.segment_num%type;
599: colname fnd_id_flex_segments.application_column_name%type;

Line 853: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;

849: p_data in varchar2) return varchar2
850: is
851: segments seg_array;
852: err_num number;
853: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
854:
855: segnum fnd_id_flex_segments.segment_num%type;
856: colname fnd_id_flex_segments.application_column_name%type;
857: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;