APPS.EGO_SEARCH_FWK_PUB dependencies on AK_CRITERIA

Line 883: AK_CRITERIA

879: AND REGION_CODE = X_REGION_CODE;
880:
881: DELETE
882: FROM
883: AK_CRITERIA
884: WHERE
885: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
886: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
887: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2566: AK_CRITERIA_PKG.insert_row

2562: IF FND_API.To_Boolean(x_init_msg_list) THEN
2563: FND_MSG_PUB.Initialize;
2564: END IF;
2565:
2566: AK_CRITERIA_PKG.insert_row
2567: (
2568: X_ROWID,
2569: X_CUSTOMIZATION_APPLICATION_ID,
2570: X_CUSTOMIZATION_CODE,

Line 2591: AK_CRITERIA_PKG.insert_row

2587: );
2588:
2589: -- Now we see if we need to insert another (for between operators)
2590: IF (X_SECOND_VALUE_NUMBER IS NOT NULL OR X_SECOND_VALUE_DATE IS NOT NULL OR X_SECOND_VALUE_VARCHAR2 IS NOT NULL) THEN
2591: AK_CRITERIA_PKG.insert_row
2592: (
2593: X_ROWID,
2594: X_CUSTOMIZATION_APPLICATION_ID,
2595: X_CUSTOMIZATION_CODE,

Line 2699: AK_CRITERIA_PKG.update_row

2695: IF FND_API.To_Boolean(x_init_msg_list) THEN
2696: FND_MSG_PUB.Initialize;
2697: END IF;
2698:
2699: AK_CRITERIA_PKG.update_row
2700: (
2701: X_CUSTOMIZATION_APPLICATION_ID,
2702: X_CUSTOMIZATION_CODE,
2703: X_REGION_APPLICATION_ID,

Line 2724: AK_CRITERIA

2720:
2721: SELECT
2722: COUNT(*) INTO l_count
2723: FROM
2724: AK_CRITERIA
2725: WHERE
2726: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2727: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2728: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2740: AK_CRITERIA_PKG.insert_row

2736: BEGIN
2737:
2738: IF (l_count = 0) THEN
2739:
2740: AK_CRITERIA_PKG.insert_row
2741: (
2742: X_ROWID,
2743: X_CUSTOMIZATION_APPLICATION_ID,
2744: X_CUSTOMIZATION_CODE,

Line 2766: AK_CRITERIA

2762:
2763: ELSE
2764:
2765: UPDATE
2766: AK_CRITERIA
2767: SET
2768: VALUE_VARCHAR2 = X_SECOND_VALUE_VARCHAR2,
2769: VALUE_NUMBER = X_SECOND_VALUE_NUMBER,
2770: VALUE_DATE = X_SECOND_VALUE_DATE

Line 2794: AK_CRITERIA

2790:
2791: IF (l_count > 0) THEN
2792:
2793: DELETE FROM
2794: AK_CRITERIA
2795: WHERE
2796: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2797: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2798: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2895: AK_CRITERIA_PKG.delete_row

2891: IF FND_API.To_Boolean(x_init_msg_list) THEN
2892: FND_MSG_PUB.Initialize;
2893: END IF;
2894:
2895: AK_CRITERIA_PKG.delete_row
2896: (
2897: X_CUSTOMIZATION_APPLICATION_ID,
2898: X_CUSTOMIZATION_CODE,
2899: X_REGION_APPLICATION_ID,

Line 2909: AK_CRITERIA

2905:
2906: SELECT
2907: COUNT(*) INTO l_count
2908: FROM
2909: AK_CRITERIA
2910: WHERE
2911: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2912: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
2913: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 2920: AK_CRITERIA_PKG.delete_row

2916: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
2917: AND SEQUENCE_NUMBER = -1*X_SEQUENCE_NUMBER;
2918:
2919: IF (l_count > 0) THEN
2920: AK_CRITERIA_PKG.delete_row
2921: (
2922: X_CUSTOMIZATION_APPLICATION_ID,
2923: X_CUSTOMIZATION_CODE,
2924: X_REGION_APPLICATION_ID,