APPS.FND_FLEX_KEY_API dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 52: FROM fnd_id_flex_structures_vl

48: CURSOR structure_c(flexfield IN flexfield_type,
49: enabled IN VARCHAR2 DEFAULT NULL) IS
50: SELECT id_flex_structure_name structure_name,
51: id_flex_num structure_number
52: FROM fnd_id_flex_structures_vl
53: WHERE application_id = flexfield.application_id
54: AND id_flex_code = flexfield.flex_code
55: AND (structure_c.enabled IS NULL OR enabled_flag = 'Y')
56: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL

Line 698: structure_name IN fnd_id_flex_structures_vl.id_flex_structure_name%TYPE)

694:
695: /* ------------------------------------------------------------ */
696: FUNCTION check_duplicate_structure(
697: flexfield IN flexfield_type,
698: structure_name IN fnd_id_flex_structures_vl.id_flex_structure_name%TYPE)
699: RETURN NUMBER
700: IS
701: row_count NUMBER;
702: BEGIN

Line 708: FROM fnd_id_flex_structures_vl

704: -- Check for duplicate structure name.
705: --
706: SELECT count(*)
707: INTO row_count
708: FROM fnd_id_flex_structures_vl
709: WHERE application_id = flexfield.application_id
710: AND id_flex_code = flexfield.flex_code
711: AND id_flex_structure_name = structure_name
712: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 2277: FROM fnd_id_flex_structures_vl

2273: shorthand_enabled_flag,
2274: shorthand_prompt,
2275: shorthand_length
2276: INTO structure
2277: FROM fnd_id_flex_structures_vl
2278: WHERE application_id = flexfield.application_id
2279: AND id_flex_code = flexfield.flex_code
2280: AND id_flex_structure_code = structure_code
2281: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 2321: FROM fnd_id_flex_structures_vl

2317: shorthand_enabled_flag,
2318: shorthand_prompt,
2319: shorthand_length
2320: INTO structure
2321: FROM fnd_id_flex_structures_vl
2322: WHERE application_id = flexfield.application_id
2323: AND id_flex_code = flexfield.flex_code
2324: AND id_flex_num = find_structure.structure_number
2325: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 3232: FROM fnd_id_flex_structures_vl

3228:
3229: IF(name = 'newstruct') THEN
3230: SELECT 'test' || To_char(MAX(To_number(Substr(id_flex_structure_name, 4))) + 1)
3231: INTO sname
3232: FROM fnd_id_flex_structures_vl
3233: WHERE application_id = 0
3234: AND id_flex_code = 'RW2'
3235: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3236: