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 7692: UPDATE fnd_id_flex_structures

7688:
7689: --
7690: -- Update structure
7691: --
7692: UPDATE fnd_id_flex_structures
7693: SET id_flex_num = p_id_flex_num_new
7694: WHERE application_id = p_application_id
7695: AND id_flex_code = p_id_flex_code
7696: AND id_flex_num = p_id_flex_num_old;

Line 7698: UPDATE fnd_id_flex_structures_tl

7694: WHERE application_id = p_application_id
7695: AND id_flex_code = p_id_flex_code
7696: AND id_flex_num = p_id_flex_num_old;
7697:
7698: UPDATE fnd_id_flex_structures_tl
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 7969: FROM fnd_id_flex_structures

7965: l_app);
7966:
7967: SELECT COUNT(*)
7968: INTO l_count
7969: FROM fnd_id_flex_structures
7970: WHERE application_id = l_app.application_id
7971: AND id_flex_code = p_id_flex_code;
7972:
7973: IF (l_count = 0) THEN

Line 8034: fnd_id_flex_structures ifst

8030: fwpx.id_flex_code,
8031: fwpx.wf_item_type
8032: FROM fnd_flex_workflow_processes fwpx
8033: ) fwp,
8034: fnd_id_flex_structures ifst
8035: WHERE ifst.application_id = p_application_id
8036: AND ifst.id_flex_code = p_id_flex_code
8037: AND fwp.application_id = ifst.application_id
8038: AND fwp.id_flex_code = ifst.id_flex_code

Line 8711: fnd_id_flex_structures_pkg.translate_row

8707:
8708: IF (g_debug_on) THEN
8709: debug(l_func_name, 'Translating KFF_STRUCTURE.(MLS)');
8710: END IF;
8711: fnd_id_flex_structures_pkg.translate_row
8712: (x_application_short_name => p_application_short_name,
8713: x_id_flex_code => p_id_flex_code,
8714: x_id_flex_structure_code => p_id_flex_structure_code,
8715: x_who => l_file_who,

Line 8754: FROM fnd_id_flex_structures

8750: IF (is_single_structure_kff(l_kff_flx)) THEN
8751:
8752: SELECT COUNT(*)
8753: INTO l_count
8754: FROM fnd_id_flex_structures
8755: WHERE application_id = l_kff_flx.application_id
8756: AND id_flex_code = l_kff_flx.id_flex_code;
8757:
8758: IF (l_count > 1) THEN

Line 8772: FROM fnd_id_flex_structures

8768: -- Make sure primary keys are right.
8769: --
8770: SELECT *
8771: INTO l_kff_str2
8772: FROM fnd_id_flex_structures
8773: WHERE application_id = l_kff_flx.application_id
8774: AND id_flex_code = l_kff_flx.id_flex_code;
8775:
8776: IF (l_kff_str2.id_flex_structure_code <> p_id_flex_structure_code) THEN

Line 8802: fnd_id_flex_structures_pkg.load_row

8798:
8799: IF (g_debug_on) THEN
8800: debug(l_func_name, 'Uploading KFF_STRUCTURE.(MLS)');
8801: END IF;
8802: fnd_id_flex_structures_pkg.load_row
8803: (x_application_short_name => p_application_short_name,
8804: x_id_flex_code => p_id_flex_code,
8805: x_id_flex_structure_code => p_id_flex_structure_code,
8806: x_who => l_file_who,

Line 9152: FROM fnd_id_flex_structures

9148: last_update_login = l_file_who.last_update_login,
9149: description = Nvl(p_description, description)
9150: WHERE ((application_id, id_flex_code, id_flex_num) =
9151: (SELECT application_id, id_flex_code, id_flex_num
9152: FROM fnd_id_flex_structures
9153: WHERE application_id = (SELECT application_id
9154: FROM fnd_application
9155: WHERE application_short_name = p_application_short_name)
9156: AND id_flex_code = p_id_flex_code

Line 9648: FROM fnd_id_flex_structures

9644: last_update_login = l_file_who.last_update_login,
9645: description = Nvl(p_description, description)
9646: WHERE ((application_id, id_flex_code, id_flex_num) =
9647: (SELECT application_id, id_flex_code, id_flex_num
9648: FROM fnd_id_flex_structures
9649: WHERE application_id = (SELECT application_id
9650: FROM fnd_application
9651: WHERE application_short_name = p_application_short_name)
9652: AND id_flex_code = p_id_flex_code