APPS.GMA_WFSTD_P dependencies on GMA_PROCDEF_WF

Line 1132: l_enable_flag GMA_PROCDEF_WF.enable_flag%TYPE;

1128: end check_activity_approval_req;
1129: /******************************************************************************************/
1130: FUNCTION check_process_enabled(p_wf_item_type VARCHAR2,
1131: p_Process_name VARCHAR2) RETURN BOOLEAN IS
1132: l_enable_flag GMA_PROCDEF_WF.enable_flag%TYPE;
1133: BEGIN
1134: SELECT enable_flag INTO l_enable_flag
1135: FROM GMA_PROCDEF_WF
1136: WHERE wf_item_type = p_wf_item_type AND

Line 1135: FROM GMA_PROCDEF_WF

1131: p_Process_name VARCHAR2) RETURN BOOLEAN IS
1132: l_enable_flag GMA_PROCDEF_WF.enable_flag%TYPE;
1133: BEGIN
1134: SELECT enable_flag INTO l_enable_flag
1135: FROM GMA_PROCDEF_WF
1136: WHERE wf_item_type = p_wf_item_type AND
1137: process_name = p_process_name;
1138: IF l_enable_flag = 'Y' THEN
1139: RETURN TRUE;

Line 1238: FROM GMA_PROCDEF_WF

1234: Raise WF_ERROR;
1235: END IF;
1236: IF P_ACTIVITY_NAME IS NULL THEN
1237: SELECT column_data_sql into l_sql_stmt
1238: FROM GMA_PROCDEF_WF
1239: WHERE WF_ITEM_TYPE = P_WF_ITEM_TYPE AND
1240: PROCESS_NAME = p_PROCESS_NAME;
1241: ELSE
1242: SELECT column_data_sql,activity_id into l_sql_stmt,l_activity_id