APPS.AMS_VENUES_PKG dependencies on AMS_VENUES_B

Line 49: cursor C is select ROWID from AMS_VENUES_B

45: X_LAST_UPDATE_DATE in DATE,
46: X_LAST_UPDATED_BY in NUMBER,
47: X_LAST_UPDATE_LOGIN in NUMBER
48: ) is
49: cursor C is select ROWID from AMS_VENUES_B
50: where VENUE_ID = X_VENUE_ID
51: ;
52: begin
53: insert into AMS_VENUES_B (

Line 53: insert into AMS_VENUES_B (

49: cursor C is select ROWID from AMS_VENUES_B
50: where VENUE_ID = X_VENUE_ID
51: ;
52: begin
53: insert into AMS_VENUES_B (
54: --SECURITY_GROUP_ID,
55: ATTRIBUTE10,
56: ATTRIBUTE11,
57: ATTRIBUTE12,

Line 257: from AMS_VENUES_B

253: ATTRIBUTE6,
254: ATTRIBUTE7,
255: ATTRIBUTE8,
256: ATTRIBUTE9
257: from AMS_VENUES_B
258: where VENUE_ID = X_VENUE_ID
259: for update of VENUE_ID nowait;
260: recinfo c%rowtype;
261:

Line 410: update AMS_VENUES_B set

406: X_LAST_UPDATED_BY in NUMBER,
407: X_LAST_UPDATE_LOGIN in NUMBER
408: ) is
409: begin
410: update AMS_VENUES_B set
411: --SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
412: ATTRIBUTE10 = X_ATTRIBUTE10,
413: ATTRIBUTE11 = X_ATTRIBUTE11,
414: ATTRIBUTE12 = X_ATTRIBUTE12,

Line 481: delete from AMS_VENUES_B

477: if (sql%notfound) then
478: raise no_data_found;
479: end if;
480:
481: delete from AMS_VENUES_B
482: where VENUE_ID = X_VENUE_ID;
483:
484: if (sql%notfound) then
485: raise no_data_found;

Line 495: from AMS_VENUES_B B

491: begin
492: delete from AMS_VENUES_TL T
493: where not exists
494: (select NULL
495: from AMS_VENUES_B B
496: where B.VENUE_ID = T.VENUE_ID
497: );
498:
499: update AMS_VENUES_TL T set (

Line 624: from AMS_VENUES_B

620: l_row_id varchar2(100);
621:
622: cursor c_obj_verno (id_in in NUMBER) is
623: select object_version_number
624: from AMS_VENUES_B
625: where VENUE_ID = id_in;
626:
627: cursor c_chk_vnu_exists (id_in in NUMBER) is
628: select 'x'

Line 629: from AMS_VENUES_B

625: where VENUE_ID = id_in;
626:
627: cursor c_chk_vnu_exists (id_in in NUMBER) is
628: select 'x'
629: from AMS_VENUES_B
630: where VENUE_ID = id_in;
631:
632: cursor c_get_vnu_id is
633: select AMS_VENUES_B_S.nextval

Line 633: select AMS_VENUES_B_S.nextval

629: from AMS_VENUES_B
630: where VENUE_ID = id_in;
631:
632: cursor c_get_vnu_id is
633: select AMS_VENUES_B_S.nextval
634: from dual;
635: BEGIN
636: if X_OWNER = 'SEED' then
637: l_user_id := 1;