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_DIAGNOSE dependencies on FND_ID_FLEX_STRUCTURES

Line 34: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;

30: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%ROWTYPE;
31: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;
32:
33: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
34: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
35: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
36: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
37: SUBTYPE kff_qlv_type IS fnd_segment_attribute_values%ROWTYPE;
38: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;

Line 503: FROM fnd_id_flex_structures

499: IS
500: BEGIN
501: SELECT *
502: INTO x_kff_str
503: FROM fnd_id_flex_structures
504: WHERE application_id = p_kff_flx.application_id
505: AND id_flex_code = p_kff_flx.id_flex_code
506: AND id_flex_num = p_id_flex_num;
507: RETURN(TRUE);

Line 510: x_message := msg_uts('FND_ID_FLEX_STRUCTURES',

506: AND id_flex_num = p_id_flex_num;
507: RETURN(TRUE);
508: EXCEPTION
509: WHEN OTHERS THEN
510: x_message := msg_uts('FND_ID_FLEX_STRUCTURES',
511: 'application_id', p_kff_flx.application_id,
512: 'id_flex_code', p_kff_flx.id_flex_code,
513: 'id_flex_num', p_id_flex_num);
514: RETURN(FALSE);

Line 3516: FROM fnd_id_flex_structures_vl

3512: freeze_flex_definition_flag || '/' ||
3513: concatenated_segment_delimiter || '/' ||
3514: id_flex_structure_name
3515: INTO l_return
3516: FROM fnd_id_flex_structures_vl
3517: WHERE application_id = p_application_id
3518: AND id_flex_code = p_id_flex_code
3519: AND id_flex_num = p_id_flex_num;
3520: RETURN(line_return(l_return));

Line 4296: FROM fnd_id_flex_structures

4292: -- No structures.
4293: --
4294: SELECT COUNT(*)
4295: INTO l_count
4296: FROM fnd_id_flex_structures
4297: WHERE application_id = l_kff_flx.application_id
4298: AND id_flex_code = l_kff_flx.id_flex_code;
4299:
4300: IF (l_count > 0) THEN

Line 4315: fnd_id_flex_structures_pkg.insert_row

4311: x_message)) THEN
4312: --
4313: -- 101 structure doesn't exist, insert it.
4314: --
4315: fnd_id_flex_structures_pkg.insert_row
4316: (x_rowid => l_rowid,
4317: x_application_id => l_kff_flx.application_id,
4318: x_id_flex_code => l_kff_flx.id_flex_code,
4319: x_id_flex_num => 101,

Line 4411: FROM fnd_id_flex_structures ifst

4407: -- Structure without KFF.
4408: --
4409: BEGIN
4410: DELETE
4411: FROM fnd_id_flex_structures ifst
4412: WHERE application_id = p_application_id
4413: AND id_flex_code = p_id_flex_code
4414: AND id_flex_num = p_id_flex_num
4415: AND NOT EXISTS

Line 4425: 'Unable to delete from FND_ID_FLEX_STRUCTURES. ' || Sqlerrm;

4421: GOTO return_success;
4422: EXCEPTION
4423: WHEN OTHERS THEN
4424: x_message :=
4425: 'Unable to delete from FND_ID_FLEX_STRUCTURES. ' || Sqlerrm;
4426: GOTO return_error;
4427: END;
4428: END IF;
4429:

Line 4442: FROM fnd_id_flex_structures ifst

4438: AND id_flex_code = p_id_flex_code
4439: AND id_flex_num = p_id_flex_num
4440: AND NOT EXISTS
4441: (SELECT null
4442: FROM fnd_id_flex_structures ifst
4443: WHERE ifst.application_id = cifs.application_id
4444: AND ifst.id_flex_code = cifs.id_flex_code
4445: AND ifst.id_flex_num = cifs.id_flex_num);
4446: x_message := SQL%rowcount || ' row(s) deleted.';

Line 4532: UPDATE fnd_id_flex_structures SET

4528: l_kff_str.shorthand_enabled_flag := 'N';
4529: END IF;
4530:
4531: BEGIN
4532: UPDATE fnd_id_flex_structures SET
4533: cross_segment_validation_flag = l_kff_str.cross_segment_validation_flag,
4534: dynamic_inserts_allowed_flag = l_kff_str.dynamic_inserts_allowed_flag,
4535: enabled_flag = l_kff_str.enabled_flag,
4536: freeze_flex_definition_flag = l_kff_str.freeze_flex_definition_flag,

Line 4549: 'Unable to update FND_ID_FLEX_STRUCTURES. ' || Sqlerrm;

4545: GOTO return_success;
4546: EXCEPTION
4547: WHEN OTHERS THEN
4548: x_message :=
4549: 'Unable to update FND_ID_FLEX_STRUCTURES. ' || Sqlerrm;
4550: GOTO return_error;
4551: END;
4552: END IF;
4553:

Line 4600: FROM fnd_id_flex_structures ifst

4596: AND id_flex_num = p_id_flex_num
4597: AND application_column_name = p_application_column_name
4598: AND NOT EXISTS
4599: (SELECT null
4600: FROM fnd_id_flex_structures ifst
4601: WHERE ifst.application_id = ifsg.application_id
4602: AND ifst.id_flex_code = ifsg.id_flex_code
4603: AND ifst.id_flex_num = ifsg.id_flex_num);
4604: x_message := SQL%rowcount || ' row(s) deleted.';

Line 4801: FROM fnd_id_flex_structures ifst

4797: AND id_flex_num = p_id_flex_num
4798: AND alias_name = p_alias_name
4799: AND NOT EXISTS
4800: (SELECT null
4801: FROM fnd_id_flex_structures ifst
4802: WHERE ifst.application_id = sfa.application_id
4803: AND ifst.id_flex_code = sfa.id_flex_code
4804: AND ifst.id_flex_num = sfa.id_flex_num);
4805: x_message := SQL%rowcount || ' row(s) deleted.';

Line 4907: FROM fnd_id_flex_structures ifst

4903: AND id_flex_num = p_id_flex_num
4904: AND flex_validation_rule_name = p_flex_validation_rule_name
4905: AND NOT EXISTS
4906: (SELECT null
4907: FROM fnd_id_flex_structures ifst
4908: WHERE ifst.application_id = fvr.application_id
4909: AND ifst.id_flex_code = fvr.id_flex_code
4910: AND ifst.id_flex_num = fvr.id_flex_num);
4911: x_message := SQL%rowcount || ' row(s) deleted.';

Line 5262: FROM fnd_id_flex_structures

5258: l_kff_str kff_str_type;
5259:
5260: CURSOR kff_str_cur IS
5261: SELECT *
5262: FROM fnd_id_flex_structures
5263: ORDER BY application_id, id_flex_code, id_flex_num;
5264: BEGIN
5265:
5266: IF (p_rule IN ('G.06', 'H.03')) THEN

Line 6018: FROM fnd_id_flex_structures ifst

6014: AND id_flex_num = p_id_flex_num
6015: AND wf_item_type = p_wf_item_type
6016: AND NOT EXISTS
6017: (SELECT null
6018: FROM fnd_id_flex_structures ifst
6019: WHERE ifst.application_id = fwp.application_id
6020: AND ifst.id_flex_code = fwp.id_flex_code
6021: AND ifst.id_flex_num = fwp.id_flex_num);
6022: x_message := SQL%rowcount || ' row(s) deleted.';