DBA Data[Home] [Help]

APPS.EGO_SEARCH_FWK_PUB dependencies on EGO_CRITERIA_TEMPLATES_V

Line 200: EGO_CRITERIA_TEMPLATES_V

196: COUNT(*)
197: INTO
198: l_count
199: FROM
200: EGO_CRITERIA_TEMPLATES_V
201: WHERE
202: NAME = X_NAME
203: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
204: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 219: EGO_CRITERIA_TEMPLATES_V

215: COUNT(*)
216: INTO
217: l_count
218: FROM
219: EGO_CRITERIA_TEMPLATES_V
220: WHERE
221: NAME = X_NAME
222: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
223: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 241: EGO_CRITERIA_TEMPLATES_V

237: COUNT(*)
238: INTO
239: l_count
240: FROM
241: EGO_CRITERIA_TEMPLATES_V
242: WHERE
243: NAME = X_NAME
244: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
245: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 259: EGO_CRITERIA_TEMPLATES_V

255: COUNT(*)
256: INTO
257: l_count
258: FROM
259: EGO_CRITERIA_TEMPLATES_V
260: WHERE
261: NAME = X_NAME
262: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
263: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 815: EGO_CRITERIA_TEMPLATES_V

811: IF (X_REGION_CODE = 'EGO_ITEM_MATCH_RULE_REGION') THEN
812: SELECT
813: CLASSIFICATION1, NAME INTO l_classification1, l_name
814: FROM
815: EGO_CRITERIA_TEMPLATES_V
816: WHERE
817: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
818: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
819: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 897: EGO_CRITERIA_TEMPLATES_V

893:
894: SELECT
895: NAME INTO l_name
896: FROM
897: EGO_CRITERIA_TEMPLATES_V
898: WHERE
899: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
900: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
901: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID