DBA Data[Home] [Help]

APPS.AMS_DELIVKITITEM_PVT dependencies on AMS_DELIV_KIT_ITEMS_S

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 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,