APPS.ITG_X_UTILS dependencies on FND_ID_FLEX_STRUCTURES

Line 247: l_flexNum fnd_id_flex_structures.id_flex_num%TYPE := flexNum;

243: segment25 IN VARCHAR2 := NULL, segment26 IN VARCHAR2 := NULL,
244: segment27 IN VARCHAR2 := NULL, segment28 IN VARCHAR2 := NULL,
245: segment29 IN VARCHAR2 := NULL, segment30 IN VARCHAR2 := NULL
246: ) RETURN varchar2 AS
247: l_flexNum fnd_id_flex_structures.id_flex_num%TYPE := flexNum;
248: CURSOR getFlexNum IS
249: SELECT id_flex_num
250: FROM fnd_id_flex_structures
251: WHERE application_id = appId

Line 250: FROM fnd_id_flex_structures

246: ) RETURN varchar2 AS
247: l_flexNum fnd_id_flex_structures.id_flex_num%TYPE := flexNum;
248: CURSOR getFlexNum IS
249: SELECT id_flex_num
250: FROM fnd_id_flex_structures
251: WHERE application_id = appId
252: AND id_flex_code = flexCode
253: AND enabled_flag = 'Y';
254: delim fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

Line 254: delim fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

250: FROM fnd_id_flex_structures
251: WHERE application_id = appId
252: AND id_flex_code = flexCode
253: AND enabled_flag = 'Y';
254: delim fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
255: CURSOR getFlexDelimiter is
256: SELECT concatenated_segment_delimiter
257: FROM fnd_id_flex_structures
258: WHERE application_id = appId

Line 257: FROM fnd_id_flex_structures

253: AND enabled_flag = 'Y';
254: delim fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
255: CURSOR getFlexDelimiter is
256: SELECT concatenated_segment_delimiter
257: FROM fnd_id_flex_structures
258: WHERE application_id = appId
259: AND id_flex_code = flexCode
260: AND id_flex_num = l_flexNum
261: AND enabled_flag = 'Y';