APPS.FND_FLEX_LOADER_APIS dependencies on FND_ID_FLEX_STRUCTURES

Line 93: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;

89: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
90: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
91: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;
92: SUBTYPE kff_sgq_tl_type IS fnd_val_attribute_types_tl%ROWTYPE;
93: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
94: SUBTYPE kff_str_tl_type IS fnd_id_flex_structures_tl%ROWTYPE;
95: SUBTYPE kff_wfp_type IS fnd_flex_workflow_processes%ROWTYPE;
96: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;
97: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;

Line 94: SUBTYPE kff_str_tl_type IS fnd_id_flex_structures_tl%ROWTYPE;

90: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
91: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;
92: SUBTYPE kff_sgq_tl_type IS fnd_val_attribute_types_tl%ROWTYPE;
93: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
94: SUBTYPE kff_str_tl_type IS fnd_id_flex_structures_tl%ROWTYPE;
95: SUBTYPE kff_wfp_type IS fnd_flex_workflow_processes%ROWTYPE;
96: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;
97: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;
98: SUBTYPE kff_cvr_tl_type IS fnd_flex_vdation_rules_tl%ROWTYPE;

Line 2422: FROM fnd_id_flex_structures

2418: BEGIN
2419: l_func_name := g_api_name || 'get_kff_str(code,F)';
2420: SELECT *
2421: INTO x_kff_str
2422: FROM fnd_id_flex_structures
2423: WHERE application_id = p_kff_flx.application_id
2424: AND id_flex_code = p_kff_flx.id_flex_code
2425: AND id_flex_structure_code = p_id_flex_structure_code;
2426: RETURN TRUE;

Line 2473: FROM fnd_id_flex_structures

2469: BEGIN
2470: l_func_name := g_api_name || 'get_kff_str(num,F)';
2471: SELECT *
2472: INTO x_kff_str
2473: FROM fnd_id_flex_structures
2474: WHERE application_id = p_kff_flx.application_id
2475: AND id_flex_code = p_kff_flx.id_flex_code
2476: AND id_flex_num = p_id_flex_num;
2477: RETURN TRUE;

Line 2524: FROM fnd_id_flex_structures_tl

2520: BEGIN
2521: l_func_name := g_api_name || 'get_kff_str_tl(F)';
2522: SELECT *
2523: INTO x_kff_str_tl
2524: FROM fnd_id_flex_structures_tl
2525: WHERE application_id = p_kff_str.application_id
2526: AND id_flex_code = p_kff_str.id_flex_code
2527: AND id_flex_num = p_kff_str.id_flex_num
2528: AND language = p_language;

Line 7698: UPDATE fnd_id_flex_structures

7694:
7695: --
7696: -- Update structure
7697: --
7698: UPDATE fnd_id_flex_structures
7699: SET id_flex_num = p_id_flex_num_new
7700: WHERE application_id = p_application_id
7701: AND id_flex_code = p_id_flex_code
7702: AND id_flex_num = p_id_flex_num_old;

Line 7704: UPDATE fnd_id_flex_structures_tl

7700: WHERE application_id = p_application_id
7701: AND id_flex_code = p_id_flex_code
7702: AND id_flex_num = p_id_flex_num_old;
7703:
7704: UPDATE fnd_id_flex_structures_tl
7705: SET id_flex_num = p_id_flex_num_new
7706: WHERE application_id = p_application_id
7707: AND id_flex_code = p_id_flex_code
7708: AND id_flex_num = p_id_flex_num_old;

Line 7975: FROM fnd_id_flex_structures

7971: l_app);
7972:
7973: SELECT COUNT(*)
7974: INTO l_count
7975: FROM fnd_id_flex_structures
7976: WHERE application_id = l_app.application_id
7977: AND id_flex_code = p_id_flex_code;
7978:
7979: IF (l_count = 0) THEN

Line 8040: fnd_id_flex_structures ifst

8036: fwpx.id_flex_code,
8037: fwpx.wf_item_type
8038: FROM fnd_flex_workflow_processes fwpx
8039: ) fwp,
8040: fnd_id_flex_structures ifst
8041: WHERE ifst.application_id = p_application_id
8042: AND ifst.id_flex_code = p_id_flex_code
8043: AND fwp.application_id = ifst.application_id
8044: AND fwp.id_flex_code = ifst.id_flex_code

Line 8717: fnd_id_flex_structures_pkg.translate_row

8713:
8714: IF (g_debug_on) THEN
8715: debug(l_func_name, 'Translating KFF_STRUCTURE.(MLS)');
8716: END IF;
8717: fnd_id_flex_structures_pkg.translate_row
8718: (x_application_short_name => p_application_short_name,
8719: x_id_flex_code => p_id_flex_code,
8720: x_id_flex_structure_code => p_id_flex_structure_code,
8721: x_who => l_file_who,

Line 8760: FROM fnd_id_flex_structures

8756: IF (is_single_structure_kff(l_kff_flx)) THEN
8757:
8758: SELECT COUNT(*)
8759: INTO l_count
8760: FROM fnd_id_flex_structures
8761: WHERE application_id = l_kff_flx.application_id
8762: AND id_flex_code = l_kff_flx.id_flex_code;
8763:
8764: IF (l_count > 1) THEN

Line 8778: FROM fnd_id_flex_structures

8774: -- Make sure primary keys are right.
8775: --
8776: SELECT *
8777: INTO l_kff_str2
8778: FROM fnd_id_flex_structures
8779: WHERE application_id = l_kff_flx.application_id
8780: AND id_flex_code = l_kff_flx.id_flex_code;
8781:
8782: IF (l_kff_str2.id_flex_structure_code <> p_id_flex_structure_code) THEN

Line 8808: fnd_id_flex_structures_pkg.load_row

8804:
8805: IF (g_debug_on) THEN
8806: debug(l_func_name, 'Uploading KFF_STRUCTURE.(MLS)');
8807: END IF;
8808: fnd_id_flex_structures_pkg.load_row
8809: (x_application_short_name => p_application_short_name,
8810: x_id_flex_code => p_id_flex_code,
8811: x_id_flex_structure_code => p_id_flex_structure_code,
8812: x_who => l_file_who,

Line 9158: FROM fnd_id_flex_structures

9154: last_update_login = l_file_who.last_update_login,
9155: description = Nvl(p_description, description)
9156: WHERE ((application_id, id_flex_code, id_flex_num) =
9157: (SELECT application_id, id_flex_code, id_flex_num
9158: FROM fnd_id_flex_structures
9159: WHERE application_id = (SELECT application_id
9160: FROM fnd_application
9161: WHERE application_short_name = p_application_short_name)
9162: AND id_flex_code = p_id_flex_code

Line 9654: FROM fnd_id_flex_structures

9650: last_update_login = l_file_who.last_update_login,
9651: description = Nvl(p_description, description)
9652: WHERE ((application_id, id_flex_code, id_flex_num) =
9653: (SELECT application_id, id_flex_code, id_flex_num
9654: FROM fnd_id_flex_structures
9655: WHERE application_id = (SELECT application_id
9656: FROM fnd_application
9657: WHERE application_short_name = p_application_short_name)
9658: AND id_flex_code = p_id_flex_code