eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_KEY_API dependencies on FND_ID_FLEX_STRUCTURES

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 1104: fnd_id_flex_structures_pkg.insert_row(

1100: BEGIN
1101: message_init;
1102: application_id_i := application_id_f(appl_short_name);
1103:
1104: fnd_id_flex_structures_pkg.insert_row(
1105: X_ROWID => rowid_i,
1106: X_APPLICATION_ID => application_id_i,
1107: X_ID_FLEX_CODE => flex_code,
1108: X_ID_FLEX_NUM => flex_num,

Line 2208: SELECT fnd_id_flex_structures_s.NEXTVAL

2204: message_init;
2205: check_instantiated(flexfield);
2206:
2207: IF customer_mode THEN
2208: SELECT fnd_id_flex_structures_s.NEXTVAL
2209: INTO structure.structure_number
2210: FROM dual;
2211: ELSE
2212: SELECT NVL(MAX(ifs.id_flex_num),0) + 1

Line 2214: FROM fnd_id_flex_structures ifs

2210: FROM dual;
2211: ELSE
2212: SELECT NVL(MAX(ifs.id_flex_num),0) + 1
2213: INTO structure.structure_number
2214: FROM fnd_id_flex_structures ifs
2215: WHERE ifs.application_id = flexfield.application_id
2216: AND ifs.id_flex_code = flexfield.flex_code
2217: AND ifs.id_flex_num < 101
2218: 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 2453: fnd_id_flex_structures_pkg.update_row

2449:
2450: structure := compose(original, modified);
2451: validate_structure(flexfield,structure);
2452:
2453: fnd_id_flex_structures_pkg.update_row
2454: (X_APPLICATION_ID => flexfield.application_id,
2455: X_ID_FLEX_CODE => flexfield.flex_code,
2456: X_ID_FLEX_NUM => structure.structure_number,
2457: X_ID_FLEX_STRUCTURE_CODE => structure.structure_code,

Line 2563: DELETE FROM fnd_id_flex_structures_tl

2559: AND id_flex_code = flexfield.flex_code
2560: AND id_flex_num = structure.structure_number
2561: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2562:
2563: DELETE FROM fnd_id_flex_structures_tl
2564: WHERE application_id = flexfield.application_id
2565: AND id_flex_code = flexfield.flex_code
2566: AND id_flex_num = structure.structure_number
2567: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 2569: DELETE FROM fnd_id_flex_structures

2565: AND id_flex_code = flexfield.flex_code
2566: AND id_flex_num = structure.structure_number
2567: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2568:
2569: DELETE FROM fnd_id_flex_structures
2570: WHERE application_id = flexfield.application_id
2571: AND id_flex_code = flexfield.flex_code
2572: AND id_flex_num = structure.structure_number
2573: 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:

Line 4072: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE)

4068:
4069: PROCEDURE delete_compiled_definition
4070: (p_application_id IN fnd_application.application_id%TYPE,
4071: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
4072: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE)
4073: IS
4074: BEGIN
4075:
4076: DELETE FROM fnd_compiled_id_flexs