DBA Data[Home] [Help]

APPS.CSM_MOBILE_QUERY_PKG dependencies on CSM_QUERY_PKG

Line 99: CSM_QUERY_PKG.VALIDATE_ACCESS( p_QUERY_ID => NULL,

95:
96: --Do the Validation only if query type is SQL
97: IF UPPER(P_QUERY_TYPE) ='SQL' THEN
98: --Validate the Access to a Query
99: CSM_QUERY_PKG.VALIDATE_ACCESS( p_QUERY_ID => NULL,
100: p_QUERY_TEXT1 => p_QUERY_TEXT1,
101: p_QUERY_TEXT2 => p_QUERY_TEXT2,
102: p_RESPONSIBILITY_ID => l_responsibility_id,
103: x_return_status => l_return_status,

Line 115: CSM_QUERY_PKG.VALIDATE_QUERY( p_QUERY_ID => NULL,

111: x_error_message := 'Query Validation failed : ' || l_return_message;
112: RETURN;
113: END IF;
114: --Validate the Query
115: CSM_QUERY_PKG.VALIDATE_QUERY( p_QUERY_ID => NULL,
116: p_QUERY_TEXT1 => p_QUERY_TEXT1,
117: p_QUERY_TEXT2 => p_QUERY_TEXT2,
118: x_return_status => l_return_status,
119: x_error_message => l_return_message);

Line 130: CSM_QUERY_PKG.VALIDATE_WORKFLOW

126: x_error_message := 'Query Validation failed : ' || l_return_message;
127: RETURN;
128: END IF;
129: ELSIF UPPER(P_QUERY_TYPE) ='WORKFLOW' THEN
130: CSM_QUERY_PKG.VALIDATE_WORKFLOW
131: ( p_QUERY_ID => p_QUERY_ID,
132: p_WORKFLOW => p_WORK_FLOW,
133: p_VARIABLE_NAME => p_VARIABLE_NAME,
134: x_return_status => l_return_status,