APPS.CSM_QUERY_INSTANCE_PKG dependencies on CSM_QUERY_PKG

Line 132: CSM_QUERY_PKG.VALIDATE_ACCESS( p_QUERY_ID => l_query_id,

128: l_responsibility_id := l_level_value;
129: END IF;
130: IF l_query_type ='SQL' THEN
131: --Validate the Access to a Query
132: CSM_QUERY_PKG.VALIDATE_ACCESS( p_QUERY_ID => l_query_id,
133: p_QUERY_TEXT1 => NULL,
134: p_QUERY_TEXT2 => NULL,
135: p_RESPONSIBILITY_ID => l_responsibility_id,
136: x_return_status => x_return_status,

Line 189: CSM_QUERY_PKG.EXECUTE_QUERY ( p_USER_ID => l_user_id,

185: --Query does not have any where condition so Execute and leave
186: IF l_variable_id_lst.COUNT = 0 THEN
187:
188: --Execute the Query
189: CSM_QUERY_PKG.EXECUTE_QUERY ( p_USER_ID => l_user_id,
190: p_QUERY_ID => l_query_id,
191: p_INSTANCE_ID => l_instance_id,
192: x_return_status => x_return_status,
193: x_error_message => l_error_msg,

Line 276: CSM_QUERY_PKG.EXECUTE_QUERY ( p_USER_ID => l_user_id,

272: END IF;
273: END LOOP;
274:
275: --Execute the Query
276: CSM_QUERY_PKG.EXECUTE_QUERY ( p_USER_ID => l_user_id,
277: p_QUERY_ID => l_query_id,
278: p_INSTANCE_ID => l_instance_id,
279: x_return_status => x_return_status,
280: x_error_message => l_error_msg,

Line 368: CSM_QUERY_PKG.DELETE_INSTANCE

364: RETURN;
365: END IF;
366:
367: --Calling Query instance Delete
368: CSM_QUERY_PKG.DELETE_INSTANCE
369: ( p_USER_ID => l_user_id,
370: p_QUERY_ID => l_query_id,
371: p_INSTANCE_ID => l_instance_id,
372: p_commit => fnd_api.G_FALSE,