DBA Data[Home] [Help]

APPS.FND_ID_FLEX_STRUCTURES_PKG dependencies on FND_ID_FLEXS

Line 417: l_id_flex_code fnd_id_flexs.id_flex_code%TYPE;

413: x_description IN VARCHAR2,
414: x_shorthand_prompt IN VARCHAR2)
415: IS
416: l_application_id NUMBER;
417: l_id_flex_code fnd_id_flexs.id_flex_code%TYPE;
418: l_id_flex_num NUMBER;
419: l_rowid VARCHAR2(64);
420: BEGIN
421: SELECT application_id

Line 428: FROM fnd_id_flexs

424: WHERE application_short_name = x_application_short_name;
425:
426: SELECT id_flex_code
427: INTO l_id_flex_code
428: FROM fnd_id_flexs
429: WHERE application_id = l_application_id
430: AND id_flex_code = x_id_flex_code;
431:
432: BEGIN