APPS.AMS_EVENTHEADER_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

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 333: INSERT INTO ams_event_headers_all_b(

329: l_ovn := 2;
330: END IF;
331:
332:
333: INSERT INTO ams_event_headers_all_b(
334: event_header_id
335: ,setup_type_id
336: ,last_update_date
337: ,last_updated_by

Line 699: FROM ams_event_headers_all_b

695: WHERE user_id = l_user_id;
696:
697: CURSOR get_parent_header_info(l_evh_id IN NUMBER) IS
698: SELECT event_level,parent_event_header_id
699: FROM ams_event_headers_all_b
700: WHERE event_header_id = l_evh_id
701: and event_level = 'SUB';
702:
703: BEGIN

Line 765: UPDATE ams_event_headers_all_b

761:
762: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
763: END IF;
764:
765: UPDATE ams_event_headers_all_b
766: SET active_flag = 'N'
767: WHERE event_header_id = p_evh_id
768: AND object_version_number = p_object_version;
769:

Line 876: FROM ams_event_headers_all_b

872: l_evh_id NUMBER;
873:
874: CURSOR c_evh_b IS
875: SELECT event_header_id
876: FROM ams_event_headers_all_b
877: WHERE event_header_id = p_evh_id
878: AND object_version_number = p_object_version
879: FOR UPDATE OF event_header_id NOWAIT;
880:

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,

Line 3335: from ams_event_headers_all_b

3331: -- change odf files now.. add new cursor to get setup from table...
3332: -- need to change ams_event_headers_vl later to include setup_id
3333: CURSOR c_setup IS
3334: select setup_type_id
3335: from ams_event_headers_all_b
3336: where event_header_id = p_evh_rec.event_header_id;
3337:
3338: l_setup NUMBER;
3339:

Line 3741: l_evh_id AMS_EVENT_HEADERS_ALL_B.event_header_id%type;

3737: l_evh_rec AMS_EVENTHEADER_PVT.evh_rec_type;
3738: l_return_status VARCHAR2(1);
3739: l_msg_count NUMBER;
3740: l_msg_data VARCHAR2(200);
3741: l_evh_id AMS_EVENT_HEADERS_ALL_B.event_header_id%type;
3742:
3743: BEGIN
3744:
3745: l_evh_rec.event_header_id := 10009 ;