APPS.AMS_DELIVKITITEM_PVT dependencies on AMS_DELIV_KIT_ITEMS

Line 45: SELECT ams_deliv_kit_items_s.NEXTVAL

41: l_kit_flag VARCHAR2(1);
42: l_kit_part_count NUMBER;
43:
44: CURSOR c_deliv_kit_item_seq IS
45: SELECT ams_deliv_kit_items_s.NEXTVAL
46: FROM DUAL;
47:
48: CURSOR c_deliv_kit_item_count(deliv_kit_item_id IN NUMBER) IS
49: SELECT COUNT(*)

Line 50: FROM ams_deliv_kit_items

46: FROM DUAL;
47:
48: CURSOR c_deliv_kit_item_count(deliv_kit_item_id IN NUMBER) IS
49: SELECT COUNT(*)
50: FROM ams_deliv_kit_items
51: WHERE deliverable_kit_item_id = deliv_kit_item_id;
52:
53: -- AMS_KIT_PART_CANNOT_BE_KIT
54: CURSOR c_deliv_kit_part_flag(deliv_kit_item_id IN NUMBER) IS

Line 63: FROM ams_deliv_kit_items

59: -- AMS_KIT_CANNOT_BE_KIT_PART
60: /*
61: CURSOR c_deliv_kit_part_count(deliv_kit_id IN NUMBER) IS
62: SELECT COUNT(*)
63: FROM ams_deliv_kit_items
64: WHERE deliverable_kit_part_id = deliv_kit_id;*/
65:
66: BEGIN
67:

Line 165: INSERT INTO ams_deliv_kit_items

161: EXIT WHEN l_deliv_kit_item_count = 0;
162: END LOOP;
163: END IF;
164:
165: INSERT INTO ams_deliv_kit_items
166: (
167: deliverable_kit_item_id,
168: last_update_date,
169: last_updated_by,

Line 356: FROM ams_deliv_kit_items

352: l_kit_id NUMBER;
353:
354: CURSOR c_kit_count(kit_item_id IN NUMBER) IS
355: SELECT COUNT(*)
356: FROM ams_deliv_kit_items
357: WHERE deliverable_kit_id =
358: ( SELECT deliverable_kit_id
359: FROM ams_deliv_kit_items
360: WHERE deliverable_kit_item_id = kit_item_id);

Line 359: FROM ams_deliv_kit_items

355: SELECT COUNT(*)
356: FROM ams_deliv_kit_items
357: WHERE deliverable_kit_id =
358: ( SELECT deliverable_kit_id
359: FROM ams_deliv_kit_items
360: WHERE deliverable_kit_item_id = kit_item_id);
361:
362: CURSOR c_kit_id(kit_item_id IN NUMBER) IS
363: SELECT deliverable_kit_id

Line 364: FROM ams_deliv_kit_items

360: WHERE deliverable_kit_item_id = kit_item_id);
361:
362: CURSOR c_kit_id(kit_item_id IN NUMBER) IS
363: SELECT deliverable_kit_id
364: FROM ams_deliv_kit_items
365: WHERE deliverable_kit_item_id = kit_item_id;
366:
367: BEGIN
368:

Line 409: DELETE FROM ams_deliv_kit_items

405: OPEN c_kit_count(p_deliv_kit_item_id);
406: FETCH c_kit_count INTO l_kit_count;
407: CLOSE c_kit_count;
408:
409: DELETE FROM ams_deliv_kit_items
410: WHERE deliverable_kit_item_id = p_deliv_kit_item_id
411: AND object_version_number = p_object_version;
412:
413: IF (SQL%NOTFOUND) THEN

Line 559: FROM ams_deliv_kit_items

555: l_deliv_kit_item_id NUMBER;
556:
557: CURSOR c_deliv_kit_item IS
558: SELECT deliverable_kit_item_id
559: FROM ams_deliv_kit_items
560: WHERE deliverable_kit_item_id = p_deliv_kit_item_id
561: AND object_version_number = p_object_version
562: FOR UPDATE OF deliverable_kit_item_id NOWAIT;
563:

Line 771: UPDATE ams_deliv_kit_items SET

767:
768: AMS_Utility_PVT.debug_message(l_full_name ||': update');
769: END IF;
770:
771: UPDATE ams_deliv_kit_items SET
772: last_update_date = SYSDATE,
773: last_updated_by = FND_GLOBAL.user_id,
774: last_update_login = FND_GLOBAL.conc_login_id,
775: object_version_number = l_deliv_kit_item_rec.object_version_number + 1,

Line 1075: 'ams_deliv_kit_items',

1071: IF p_validation_mode = JTF_PLSQL_API.g_create
1072: AND p_deliv_kit_item_rec.deliverable_kit_item_id IS NOT NULL
1073: THEN
1074: IF AMS_Utility_PVT.check_uniqueness(
1075: 'ams_deliv_kit_items',
1076: 'deliverable_kit_item_id = ' || p_deliv_kit_item_rec.deliverable_kit_item_id
1077: ) = FND_API.g_false
1078: THEN
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1462: FROM ams_deliv_kit_items

1458: IS
1459:
1460: CURSOR c_deliv_kit_item IS
1461: SELECT *
1462: FROM ams_deliv_kit_items
1463: WHERE deliverable_kit_item_id = p_deliv_kit_item_rec.deliverable_kit_item_id;
1464:
1465: l_deliv_kit_item_rec c_deliv_kit_item%ROWTYPE;
1466: