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 88: SELECT OZF_OFFERS_s.NEXTVAL

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

Line 93: FROM OZF_OFFERS

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

Line 408: FROM ozf_offers

404: IS
405:
406: CURSOR c_complete IS
407: SELECT *
408: FROM ozf_offers
409: WHERE qp_list_header_id = p_offers_rec.qp_list_header_id;
410: l_offers_rec c_complete%ROWTYPE;
411: BEGIN
412: x_complete_rec := p_offers_rec;

Line 704: FROM OZF_OFFERS

700: IS
701:
702: CURSOR c_get_offers(p_offer_id NUMBER) IS
703: SELECT object_version_number
704: FROM OZF_OFFERS
705: WHERE qp_list_header_id = p_offer_id;
706: -- Hint: Developer need to provide Where clause
707:
708: CURSOR c_get_old_owner(l_list_header_id NUMBER) IS

Line 710: FROM ozf_offers

706: -- Hint: Developer need to provide Where clause
707:
708: CURSOR c_get_old_owner(l_list_header_id NUMBER) IS
709: SELECT owner_id
710: FROM ozf_offers
711: WHERE qp_list_header_id = l_list_header_id;
712:
713: CURSOR c_get_start_date IS
714: SELECT q.start_date_active, o.start_date

Line 715: FROM qp_list_headers_b q, ozf_offers o

711: WHERE qp_list_header_id = l_list_header_id;
712:
713: CURSOR c_get_start_date IS
714: SELECT q.start_date_active, o.start_date
715: FROM qp_list_headers_b q, ozf_offers o
716: WHERE o.qp_list_header_id = q.list_header_id
717: AND q.list_header_id = p_offers_rec.qp_list_header_id;
718:
719: l_api_name CONSTANT VARCHAR2(30) := 'Update_Offers';

Line 1098: FROM OZF_OFFERS

1094: l_OFFER_ID NUMBER;
1095:
1096: CURSOR c_Offers IS
1097: SELECT OFFER_ID
1098: FROM OZF_OFFERS
1099: WHERE OFFER_ID = p_OFFER_ID
1100: AND object_version_number = p_object_version
1101: FOR UPDATE NOWAIT;
1102:

Line 1202: 'OZF_OFFERS',

1198: x_return_status := FND_API.g_ret_sts_success;
1199: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1200:
1201: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1202: 'OZF_OFFERS',
1203: 'OFFER_ID = '|| p_offers_rec.OFFER_ID
1204: );
1205:
1206: END IF;

Line 1217: 'OZF_OFFERS',

1213:
1214: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1215:
1216: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1217: 'OZF_OFFERS',
1218: 'qp_list_header_id = '|| p_offers_rec.qp_list_header_id
1219: );
1220:
1221: END IF;

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

1249: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1250:
1251:
1252: IF p_offers_rec.offer_id = FND_API.g_miss_num OR p_offers_rec.offer_id IS NULL THEN
1253: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');
1254: x_return_status := FND_API.g_ret_sts_error;
1255: RETURN;
1256: END IF;
1257:

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

1256: END IF;
1257:
1258:
1259: IF p_offers_rec.qp_list_header_id = FND_API.g_miss_num OR p_offers_rec.qp_list_header_id IS NULL THEN
1260: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');
1261: x_return_status := FND_API.g_ret_sts_error;
1262: RETURN;
1263: END IF;
1264:

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

1263: END IF;
1264:
1265:
1266: IF p_offers_rec.offer_type = FND_API.g_miss_char OR p_offers_rec.offer_type IS NULL THEN
1267: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');
1268: x_return_status := FND_API.g_ret_sts_error;
1269: RETURN;
1270: END IF;
1271:

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

1270: END IF;
1271:
1272:
1273: IF p_offers_rec.offer_code = FND_API.g_miss_char OR p_offers_rec.offer_code IS NULL THEN
1274: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');
1275: x_return_status := FND_API.g_ret_sts_error;
1276: RETURN;
1277: END IF;
1278:

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

1276: RETURN;
1277: END IF;
1278:
1279: IF p_offers_rec.user_status_id = FND_API.g_miss_num OR p_offers_rec.user_status_id IS NULL THEN
1280: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_USER_STATUS_ID');
1281: x_return_status := FND_API.g_ret_sts_error;
1282: RETURN;
1283: END IF;
1284:

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

1283: END IF;
1284:
1285: IF p_offers_rec.offer_type = 'SCAN_DATA' THEN
1286: IF p_offers_rec.activity_media_id = FND_API.g_miss_num OR p_offers_rec.activity_media_id IS NULL THEN
1287: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');
1288: x_return_status := FND_API.g_ret_sts_error;
1289: RETURN;
1290: END IF;
1291: END IF;

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

1337: ELSE
1338:
1339:
1340: IF p_offers_rec.offer_id IS NULL THEN
1341: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_ID');
1342: x_return_status := FND_API.g_ret_sts_error;
1343: RETURN;
1344: END IF;
1345:

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

1344: END IF;
1345:
1346:
1347: IF p_offers_rec.qp_list_header_id IS NULL THEN
1348: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_LIST_HEADER_ID');
1349: x_return_status := FND_API.g_ret_sts_error;
1350: RETURN;
1351: END IF;
1352:

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

1351: END IF;
1352:
1353:
1354: IF p_offers_rec.offer_type IS NULL THEN
1355: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_TYPE');
1356: x_return_status := FND_API.g_ret_sts_error;
1357: RETURN;
1358: END IF;
1359:

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

1358: END IF;
1359:
1360:
1361: IF p_offers_rec.offer_code IS NULL THEN
1362: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_OFFER_CODE');
1363: x_return_status := FND_API.g_ret_sts_error;
1364: RETURN;
1365: END IF;
1366:

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

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

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

1371: END IF;
1372:
1373: IF p_offers_rec.offer_type = 'SCAN_DATA' THEN
1374: IF p_offers_rec.activity_media_id IS NULL OR p_offers_rec.activity_media_id = FND_API.g_miss_num THEN
1375: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFERS_NO_ACTIVITY');
1376: x_return_status := FND_API.g_ret_sts_error;
1377: RETURN;
1378: END IF;
1379: END IF;