APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_WORKFLOW_PROCESSES

Line 44: SUBTYPE kff_fwp_type IS fnd_flex_workflow_processes%ROWTYPE;

40: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;
41: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;
42: SUBTYPE kff_cvi_type IS fnd_flex_include_rule_lines%ROWTYPE;
43: SUBTYPE kff_cve_type IS fnd_flex_exclude_rule_lines%ROWTYPE;
44: SUBTYPE kff_fwp_type IS fnd_flex_workflow_processes%ROWTYPE;
45:
46: -- ***************************************************************************
47: -- * Helper functions.
48: -- ***************************************************************************

Line 763: FROM fnd_flex_workflow_processes

759: IS
760: BEGIN
761: SELECT *
762: INTO x_kff_fwp
763: FROM fnd_flex_workflow_processes
764: WHERE application_id = p_kff_str.application_id
765: AND id_flex_code = p_kff_str.id_flex_code
766: AND id_flex_num = p_kff_str.id_flex_num
767: AND wf_item_type = p_wf_item_type;

Line 771: x_message := msg_uts('FND_FLEX_WORKFLOW_PROCESSES',

767: AND wf_item_type = p_wf_item_type;
768: RETURN(TRUE);
769: EXCEPTION
770: WHEN OTHERS THEN
771: x_message := msg_uts('FND_FLEX_WORKFLOW_PROCESSES',
772: 'application_id', p_kff_str.application_id,
773: 'id_flex_code', p_kff_str.id_flex_code,
774: 'id_flex_num', p_kff_str.id_flex_num,
775: 'wf_item_type', p_wf_item_type);

Line 3780: FROM fnd_flex_workflow_processes fwp

3776: l_return VARCHAR2(2000);
3777: BEGIN
3778: SELECT wf_item_type || '/' || wf_process_name
3779: INTO l_return
3780: FROM fnd_flex_workflow_processes fwp
3781: WHERE application_id = p_application_id
3782: AND id_flex_code = p_id_flex_code
3783: AND id_flex_num = p_id_flex_num
3784: AND wf_item_type = p_wf_item_type;

Line 6011: FROM fnd_flex_workflow_processes fwp

6007: -- FWPs without Structure.
6008: --
6009: BEGIN
6010: DELETE
6011: FROM fnd_flex_workflow_processes fwp
6012: WHERE application_id = p_application_id
6013: AND id_flex_code = p_id_flex_code
6014: AND id_flex_num = p_id_flex_num
6015: AND wf_item_type = p_wf_item_type

Line 6027: 'Unable to delete from FND_FLEX_WORKFLOW_PROCESSES. ' || Sqlerrm;

6023: GOTO return_success;
6024: EXCEPTION
6025: WHEN OTHERS THEN
6026: x_message :=
6027: 'Unable to delete from FND_FLEX_WORKFLOW_PROCESSES. ' || Sqlerrm;
6028: GOTO return_error;
6029: END;
6030: END IF;
6031:

Line 6038: FROM fnd_flex_workflow_processes fwp

6034: -- FWPs without WF Items.
6035: --
6036: BEGIN
6037: DELETE
6038: FROM fnd_flex_workflow_processes fwp
6039: WHERE application_id = p_application_id
6040: AND id_flex_code = p_id_flex_code
6041: AND id_flex_num = p_id_flex_num
6042: AND wf_item_type = p_wf_item_type

Line 6052: 'Unable to delete from FND_FLEX_WORKFLOW_PROCESSES. ' || Sqlerrm;

6048: GOTO return_success;
6049: EXCEPTION
6050: WHEN OTHERS THEN
6051: x_message :=
6052: 'Unable to delete from FND_FLEX_WORKFLOW_PROCESSES. ' || Sqlerrm;
6053: GOTO return_error;
6054: END;
6055: END IF;
6056: