APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_WORKFLOW_PROCESSES

Line 95: SUBTYPE kff_wfp_type IS fnd_flex_workflow_processes%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;
99: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;

Line 2553: FROM fnd_flex_workflow_processes

2549: BEGIN
2550: l_func_name := g_api_name || 'get_kff_wfp(F)';
2551: SELECT *
2552: INTO x_kff_wfp
2553: FROM fnd_flex_workflow_processes
2554: WHERE application_id = p_kff_str.application_id
2555: AND id_flex_code = p_kff_str.id_flex_code
2556: AND id_flex_num = p_kff_str.id_flex_num
2557: AND wf_item_type = p_wf_item_type;

Line 7683: UPDATE fnd_flex_workflow_processes

7679:
7680: --
7681: -- Update Account Generator Processes
7682: --
7683: UPDATE fnd_flex_workflow_processes
7684: SET id_flex_num = p_id_flex_num_new
7685: WHERE application_id = p_application_id
7686: AND id_flex_code = p_id_flex_code
7687: AND id_flex_num = p_id_flex_num_old;

Line 8032: FROM fnd_flex_workflow_processes fwpx

8028: FROM (SELECT DISTINCT
8029: fwpx.application_id,
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

Line 8041: FROM fnd_flex_workflow_processes fwp2

8037: AND fwp.application_id = ifst.application_id
8038: AND fwp.id_flex_code = ifst.id_flex_code
8039: AND NOT exists
8040: (SELECT NULL
8041: FROM fnd_flex_workflow_processes fwp2
8042: WHERE fwp2.application_id = ifst.application_id
8043: AND fwp2.id_flex_code = ifst.id_flex_code
8044: AND fwp2.id_flex_num = ifst.id_flex_num
8045: AND fwp2.wf_item_type = fwp.wf_item_type);

Line 8995: UPDATE fnd_flex_workflow_processes SET

8991:
8992: IF (g_debug_on) THEN
8993: debug(l_func_name, 'Updating KFF_WF_PROCESS.(no-TL)');
8994: END IF;
8995: UPDATE fnd_flex_workflow_processes SET
8996: last_updated_by = l_file_who.last_updated_by,
8997: last_update_date = l_file_who.last_update_date,
8998: last_update_login = l_file_who.last_update_login,
8999: wf_process_name = p_wf_process_name

Line 9009: INSERT INTO fnd_flex_workflow_processes

9005: IF (SQL%notfound) THEN
9006: IF (g_debug_on) THEN
9007: debug(l_func_name, 'Inserting KFF_WF_PROCESS.(no-TL)');
9008: END IF;
9009: INSERT INTO fnd_flex_workflow_processes
9010: (
9011: application_id,
9012: id_flex_code,
9013: id_flex_num,