DBA Data[Home] [Help]

APPS.EGO_SEARCH_FWK_PUB dependencies on EGO_CUSTOMIZATION_RF

Line 846: EGO_CUSTOMIZATION_RF

842: COUNT(*)
843: INTO
844: l_count
845: FROM
846: EGO_CUSTOMIZATION_RF
847: WHERE
848: RF_CUSTOMIZATION_APPL_ID = X_CUSTOMIZATION_APPLICATION_ID
849: AND RF_CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
850: AND RF_REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 874: EGO_CUSTOMIZATION_RF

870: AND REGION_CODE = X_REGION_CODE;
871:
872: DELETE
873: FROM
874: EGO_CUSTOMIZATION_RF
875: WHERE
876: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
877: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
878: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1055: INSERT INTO EGO_CUSTOMIZATION_RF

1051: END IF;
1052:
1053: IF (X_RF_CUSTOMIZATION_CODE IS NOT NULL) THEN
1054:
1055: INSERT INTO EGO_CUSTOMIZATION_RF
1056: (
1057: CUSTOMIZATION_APPLICATION_ID,
1058: CUSTOMIZATION_CODE,
1059: REGION_APPLICATION_ID,

Line 1130: EGO_CUSTOMIZATION_RF

1126:
1127: SELECT
1128: COUNT(*) INTO l_count
1129: FROM
1130: EGO_CUSTOMIZATION_RF
1131: WHERE
1132: CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1133: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1134: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1154: UPDATE EGO_CUSTOMIZATION_RF SET

1150: );
1151: ELSE
1152:
1153:
1154: UPDATE EGO_CUSTOMIZATION_RF SET
1155: RF_CUSTOMIZATION_APPL_ID = X_RF_CUSTOMIZATION_APPL_ID,
1156: RF_CUSTOMIZATION_CODE = X_RF_CUSTOMIZATION_CODE,
1157: RF_REGION_APPLICATION_ID = X_RF_REGION_APPLICATION_ID,
1158: RF_REGION_CODE = X_RF_REGION_CODE,

Line 1204: EGO_CUSTOMIZATION_RF

1200:
1201: SELECT
1202: COUNT(*) INTO l_count
1203: FROM
1204: EGO_CUSTOMIZATION_RF
1205: WHERE
1206: CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1207: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1208: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1214: DELETE FROM EGO_CUSTOMIZATION_RF

1210: AND RF_TAG = X_RF_TAG;
1211:
1212: IF (l_count > 0) THEN
1213:
1214: DELETE FROM EGO_CUSTOMIZATION_RF
1215: WHERE
1216: CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1217: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1218: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID