APPS.OKC_PROCESS_PVT dependencies on WF_ACTIVITIES_VL

Line 763: | (WF_NAME and WF_PROCESS_NAME) exists in the WF_ACTIVITIES_VL) |

759: /* ===========================================================================
760: | PROCEDURE validate_dbnames |
761: | INPUT: process defintion record pdpv_rec_type |
762: | PROCESS: validates that either the workflow name and process name |
763: | (WF_NAME and WF_PROCESS_NAME) exists in the WF_ACTIVITIES_VL) |
764: | OR package/procedure name exists in ALL_ATTRIBUTES. |
765: | OUTPUT: error message |
766: | OKC_INVALID_WF_NAME
767: | OKC_INVALID_PACK_NAME

Line 781: FROM wf_activities_vl w

777: p_pdfv_rec IN pdfv_rec_type) IS
778:
779: CURSOR wf (wfname VARCHAR2, wfproc VARCHAR2) IS
780: SELECT RUNNABLE_FLAG
781: FROM wf_activities_vl w
782: WHERE w.item_type = UPPER(wfname)
783: AND w.name = UPPER(wfproc)
784: AND w.version = (SELECT max(version)
785: FROM wf_activities_vl sq

Line 785: FROM wf_activities_vl sq

781: FROM wf_activities_vl w
782: WHERE w.item_type = UPPER(wfname)
783: AND w.name = UPPER(wfproc)
784: AND w.version = (SELECT max(version)
785: FROM wf_activities_vl sq
786: WHERE sq.item_type = UPPER(wfname)
787: AND sq.name = UPPER(wfproc) );
788:
789: CURSOR pp (packname VARCHAR2, procname VARCHAR2) IS