APPS.AMS_EVENTHEADER_PVT dependencies on AMS_EVENT_HEADERS_ALL_B_S

Line 78: SELECT ams_event_headers_all_b_s.NEXTVAL

74: l_ovn NUMBER(9) := 1;
75:
76:
77: CURSOR c_evh_seq IS
78: SELECT ams_event_headers_all_b_s.NEXTVAL
79: FROM DUAL;
80:
81: CURSOR c_evh_count(evh_id IN NUMBER) IS
82: SELECT COUNT(*)

Line 1520: UPDATE ams_event_headers_all_b SET

1516: -- is straight-forward.
1517:
1518: IF l_evh_rec.event_level = 'MAIN' THEN
1519:
1520: UPDATE ams_event_headers_all_b SET
1521: last_update_date = SYSDATE,
1522: last_updated_by = FND_GLOBAL.user_id,
1523: last_update_login = FND_GLOBAL.conc_login_id,
1524: object_version_number = l_evh_rec.object_version_number + 1,

Line 1602: UPDATE ams_event_headers_all_b SET

1598: AND object_version_number = l_evh_rec.object_version_number;
1599:
1600: ELSIF l_evh_rec.event_level = 'SUB' THEN
1601:
1602: UPDATE ams_event_headers_all_b SET
1603: last_update_date = SYSDATE,
1604: last_updated_by = FND_GLOBAL.user_id,
1605: last_update_login = FND_GLOBAL.conc_login_id,
1606: object_version_number = l_evh_rec.object_version_number + 1,