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.

APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on OZF_OFFERS

Line 90: SELECT OZF_OFFERS_s.NEXTVAL

86: l_offer_id NUMBER;
87: l_dummy NUMBER;
88:
89: CURSOR c_id IS
90: SELECT OZF_OFFERS_s.NEXTVAL
91: FROM dual;
92:
93: CURSOR c_id_exists (l_id IN NUMBER) IS
94: SELECT 1

Line 95: FROM OZF_OFFERS

91: FROM dual;
92:
93: CURSOR c_id_exists (l_id IN NUMBER) IS
94: SELECT 1
95: FROM OZF_OFFERS
96: WHERE OFFER_ID = l_id;
97:
98: l_status_code VARCHAR2(30);
99: l_status_id NUMBER;

Line 412: FROM ozf_offers

408: IS
409:
410: CURSOR c_complete IS
411: SELECT *
412: FROM ozf_offers
413: WHERE qp_list_header_id = p_offers_rec.qp_list_header_id;
414: l_offers_rec c_complete%ROWTYPE;
415: BEGIN
416: x_complete_rec := p_offers_rec;

Line 713: FROM OZF_OFFERS

709: IS
710:
711: CURSOR c_get_offers(p_offer_id NUMBER) IS
712: SELECT object_version_number
713: FROM OZF_OFFERS
714: WHERE qp_list_header_id = p_offer_id;
715: -- Hint: Developer need to provide Where clause
716:
717: CURSOR c_get_old_owner(l_list_header_id NUMBER) IS

Line 719: FROM ozf_offers

715: -- Hint: Developer need to provide Where clause
716:
717: CURSOR c_get_old_owner(l_list_header_id NUMBER) IS
718: SELECT owner_id
719: FROM ozf_offers
720: WHERE qp_list_header_id = l_list_header_id;
721:
722: CURSOR c_get_start_date IS
723: SELECT q.start_date_active, o.start_date

Line 724: FROM qp_list_headers_b q, ozf_offers o

720: WHERE qp_list_header_id = l_list_header_id;
721:
722: CURSOR c_get_start_date IS
723: SELECT q.start_date_active, o.start_date
724: FROM qp_list_headers_b q, ozf_offers o
725: WHERE o.qp_list_header_id = q.list_header_id
726: AND q.list_header_id = p_offers_rec.qp_list_header_id;
727:
728: l_api_name CONSTANT VARCHAR2(30) := 'Update_Offers';

Line 1110: FROM OZF_OFFERS

1106: l_OFFER_ID NUMBER;
1107:
1108: CURSOR c_Offers IS
1109: SELECT OFFER_ID
1110: FROM OZF_OFFERS
1111: WHERE OFFER_ID = p_OFFER_ID
1112: AND object_version_number = p_object_version
1113: FOR UPDATE NOWAIT;
1114:

Line 1214: 'OZF_OFFERS',

1210: x_return_status := FND_API.g_ret_sts_success;
1211: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1212:
1213: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1214: 'OZF_OFFERS',
1215: 'OFFER_ID = '|| p_offers_rec.OFFER_ID
1216: );
1217:
1218: END IF;

Line 1229: 'OZF_OFFERS',

1225:
1226: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1227:
1228: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1229: 'OZF_OFFERS',
1230: 'qp_list_header_id = '|| p_offers_rec.qp_list_header_id
1231: );
1232:
1233: END IF;

Line 1265: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');

1261: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1262:
1263:
1264: IF p_offers_rec.offer_id = FND_API.g_miss_num OR p_offers_rec.offer_id IS NULL THEN
1265: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');
1266: x_return_status := FND_API.g_ret_sts_error;
1267: RETURN;
1268: END IF;
1269:

Line 1272: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');

1268: END IF;
1269:
1270:
1271: IF p_offers_rec.qp_list_header_id = FND_API.g_miss_num OR p_offers_rec.qp_list_header_id IS NULL THEN
1272: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');
1273: x_return_status := FND_API.g_ret_sts_error;
1274: RETURN;
1275: END IF;
1276:

Line 1279: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');

1275: END IF;
1276:
1277:
1278: IF p_offers_rec.offer_type = FND_API.g_miss_char OR p_offers_rec.offer_type IS NULL THEN
1279: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');
1280: x_return_status := FND_API.g_ret_sts_error;
1281: RETURN;
1282: END IF;
1283:

Line 1286: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');

1282: END IF;
1283:
1284:
1285: IF p_offers_rec.offer_code = FND_API.g_miss_char OR p_offers_rec.offer_code IS NULL THEN
1286: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');
1287: x_return_status := FND_API.g_ret_sts_error;
1288: RETURN;
1289: END IF;
1290:

Line 1292: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');

1288: RETURN;
1289: END IF;
1290:
1291: IF p_offers_rec.user_status_id = FND_API.g_miss_num OR p_offers_rec.user_status_id IS NULL THEN
1292: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');
1293: x_return_status := FND_API.g_ret_sts_error;
1294: RETURN;
1295: END IF;
1296:

Line 1299: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');

1295: END IF;
1296:
1297: IF p_offers_rec.offer_type = 'SCAN_DATA' THEN
1298: IF p_offers_rec.activity_media_id = FND_API.g_miss_num OR p_offers_rec.activity_media_id IS NULL THEN
1299: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');
1300: x_return_status := FND_API.g_ret_sts_error;
1301: RETURN;
1302: END IF;
1303: END IF;

Line 1353: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');

1349: ELSE
1350:
1351:
1352: IF p_offers_rec.offer_id IS NULL THEN
1353: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');
1354: x_return_status := FND_API.g_ret_sts_error;
1355: RETURN;
1356: END IF;
1357:

Line 1360: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');

1356: END IF;
1357:
1358:
1359: IF p_offers_rec.qp_list_header_id IS NULL THEN
1360: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');
1361: x_return_status := FND_API.g_ret_sts_error;
1362: RETURN;
1363: END IF;
1364:

Line 1367: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');

1363: END IF;
1364:
1365:
1366: IF p_offers_rec.offer_type IS NULL THEN
1367: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');
1368: x_return_status := FND_API.g_ret_sts_error;
1369: RETURN;
1370: END IF;
1371:

Line 1374: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');

1370: END IF;
1371:
1372:
1373: IF p_offers_rec.offer_code IS NULL THEN
1374: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');
1375: x_return_status := FND_API.g_ret_sts_error;
1376: RETURN;
1377: END IF;
1378:

Line 1380: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');

1376: RETURN;
1377: END IF;
1378:
1379: IF p_offers_rec.user_status_id IS NULL THEN
1380: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');
1381: x_return_status := FND_API.g_ret_sts_error;
1382: RETURN;
1383: END IF;
1384:

Line 1387: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');

1383: END IF;
1384:
1385: IF p_offers_rec.offer_type = 'SCAN_DATA' THEN
1386: IF p_offers_rec.activity_media_id IS NULL OR p_offers_rec.activity_media_id = FND_API.g_miss_num THEN
1387: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');
1388: x_return_status := FND_API.g_ret_sts_error;
1389: RETURN;
1390: END IF;
1391: END IF;