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 7689: UPDATE fnd_flex_workflow_processes

7685:
7686: --
7687: -- Update Account Generator Processes
7688: --
7689: UPDATE fnd_flex_workflow_processes
7690: SET id_flex_num = p_id_flex_num_new
7691: WHERE application_id = p_application_id
7692: AND id_flex_code = p_id_flex_code
7693: AND id_flex_num = p_id_flex_num_old;

Line 8038: FROM fnd_flex_workflow_processes fwpx

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

Line 8047: FROM fnd_flex_workflow_processes fwp2

8043: AND fwp.application_id = ifst.application_id
8044: AND fwp.id_flex_code = ifst.id_flex_code
8045: AND NOT exists
8046: (SELECT NULL
8047: FROM fnd_flex_workflow_processes fwp2
8048: WHERE fwp2.application_id = ifst.application_id
8049: AND fwp2.id_flex_code = ifst.id_flex_code
8050: AND fwp2.id_flex_num = ifst.id_flex_num
8051: AND fwp2.wf_item_type = fwp.wf_item_type);

Line 9001: UPDATE fnd_flex_workflow_processes SET

8997:
8998: IF (g_debug_on) THEN
8999: debug(l_func_name, 'Updating KFF_WF_PROCESS.(no-TL)');
9000: END IF;
9001: UPDATE fnd_flex_workflow_processes SET
9002: last_updated_by = l_file_who.last_updated_by,
9003: last_update_date = l_file_who.last_update_date,
9004: last_update_login = l_file_who.last_update_login,
9005: wf_process_name = p_wf_process_name

Line 9015: INSERT INTO fnd_flex_workflow_processes

9011: IF (SQL%notfound) THEN
9012: IF (g_debug_on) THEN
9013: debug(l_func_name, 'Inserting KFF_WF_PROCESS.(no-TL)');
9014: END IF;
9015: INSERT INTO fnd_flex_workflow_processes
9016: (
9017: application_id,
9018: id_flex_code,
9019: id_flex_num,