eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_SEARCH_FWK_PUB dependencies on EGO_CUSTOMIZATION_RF

Line 814: EGO_CUSTOMIZATION_RF

810: COUNT(*)
811: INTO
812: l_count
813: FROM
814: EGO_CUSTOMIZATION_RF
815: WHERE
816: RF_CUSTOMIZATION_APPL_ID = X_CUSTOMIZATION_APPLICATION_ID
817: AND RF_CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
818: AND RF_REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 842: EGO_CUSTOMIZATION_RF

838: AND REGION_CODE = X_REGION_CODE;
839:
840: DELETE
841: FROM
842: EGO_CUSTOMIZATION_RF
843: WHERE
844: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
845: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
846: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1023: INSERT INTO EGO_CUSTOMIZATION_RF

1019: END IF;
1020:
1021: IF (X_RF_CUSTOMIZATION_CODE IS NOT NULL) THEN
1022:
1023: INSERT INTO EGO_CUSTOMIZATION_RF
1024: (
1025: CUSTOMIZATION_APPLICATION_ID,
1026: CUSTOMIZATION_CODE,
1027: REGION_APPLICATION_ID,

Line 1098: EGO_CUSTOMIZATION_RF

1094:
1095: SELECT
1096: COUNT(*) INTO l_count
1097: FROM
1098: EGO_CUSTOMIZATION_RF
1099: WHERE
1100: CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1101: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1102: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1122: UPDATE EGO_CUSTOMIZATION_RF SET

1118: );
1119: ELSE
1120:
1121:
1122: UPDATE EGO_CUSTOMIZATION_RF SET
1123: RF_CUSTOMIZATION_APPL_ID = X_RF_CUSTOMIZATION_APPL_ID,
1124: RF_CUSTOMIZATION_CODE = X_RF_CUSTOMIZATION_CODE,
1125: RF_REGION_APPLICATION_ID = X_RF_REGION_APPLICATION_ID,
1126: RF_REGION_CODE = X_RF_REGION_CODE,

Line 1172: EGO_CUSTOMIZATION_RF

1168:
1169: SELECT
1170: COUNT(*) INTO l_count
1171: FROM
1172: EGO_CUSTOMIZATION_RF
1173: WHERE
1174: CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1175: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1176: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1182: DELETE FROM EGO_CUSTOMIZATION_RF

1178: AND RF_TAG = X_RF_TAG;
1179:
1180: IF (l_count > 0) THEN
1181:
1182: DELETE FROM EGO_CUSTOMIZATION_RF
1183: WHERE
1184: CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1185: AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1186: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID