APPS.AMS_EVENT_OFFERS_ALL_PKG dependencies on AMS_EVENT_OFFERS_ALL_B

Line 102: cursor C is select ROWID from AMS_EVENT_OFFERS_ALL_B

98: X_LAST_UPDATE_DATE in DATE,
99: X_LAST_UPDATED_BY in NUMBER,
100: X_LAST_UPDATE_LOGIN in NUMBER
101: ) is
102: cursor C is select ROWID from AMS_EVENT_OFFERS_ALL_B
103: where EVENT_OFFER_ID = X_EVENT_OFFER_ID
104: ;
105: begin
106: insert into AMS_EVENT_OFFERS_ALL_B (

Line 106: insert into AMS_EVENT_OFFERS_ALL_B (

102: cursor C is select ROWID from AMS_EVENT_OFFERS_ALL_B
103: where EVENT_OFFER_ID = X_EVENT_OFFER_ID
104: ;
105: begin
106: insert into AMS_EVENT_OFFERS_ALL_B (
107: ATTRIBUTE6,
108: ORGANIZATION_ID,
109: ATTRIBUTE2,
110: EVENT_START_DATE_TIME,

Line 519: from AMS_EVENT_OFFERS_ALL_B

515: EVENT_HEADER_ID,
516: PRIVATE_FLAG,
517: ACTIVE_FLAG,
518: SOURCE_CODE
519: from AMS_EVENT_OFFERS_ALL_B
520: where EVENT_OFFER_ID = X_EVENT_OFFER_ID
521: for update of EVENT_OFFER_ID nowait;
522: recinfo c%rowtype;
523:

Line 822: update AMS_EVENT_OFFERS_ALL_B set

818: X_LAST_UPDATED_BY in NUMBER,
819: X_LAST_UPDATE_LOGIN in NUMBER
820: ) is
821: begin
822: update AMS_EVENT_OFFERS_ALL_B set
823: ATTRIBUTE6 = X_ATTRIBUTE6,
824: ORGANIZATION_ID = X_ORGANIZATION_ID,
825: ATTRIBUTE2 = X_ATTRIBUTE2,
826: EVENT_START_DATE_TIME = X_EVENT_START_DATE_TIME,

Line 946: delete from AMS_EVENT_OFFERS_ALL_B

942: if (sql%notfound) then
943: raise no_data_found;
944: end if;
945:
946: delete from AMS_EVENT_OFFERS_ALL_B
947: where EVENT_OFFER_ID = X_EVENT_OFFER_ID;
948:
949: if (sql%notfound) then
950: raise no_data_found;

Line 960: from AMS_EVENT_OFFERS_ALL_B B

956: begin
957: delete from AMS_EVENT_OFFERS_ALL_TL T
958: where not exists
959: (select NULL
960: from AMS_EVENT_OFFERS_ALL_B B
961: where B.EVENT_OFFER_ID = T.EVENT_OFFER_ID
962: );
963:
964: update AMS_EVENT_OFFERS_ALL_TL T set (

Line 1150: from ams_event_offers_all_b

1146: l_row_id varchar2(100);
1147:
1148: cursor c_version is
1149: select object_version_number
1150: from ams_event_offers_all_b
1151: where event_header_id = X_EVENT_HEADER_ID;
1152:
1153: cursor c_evo_exists is
1154: select 'x'

Line 1155: from ams_event_offers_all_b

1151: where event_header_id = X_EVENT_HEADER_ID;
1152:
1153: cursor c_evo_exists is
1154: select 'x'
1155: from ams_event_offers_all_b
1156: where event_offer_id = X_EVENT_OFFER_ID;
1157:
1158: cursor c_evo_id is
1159: select ams_event_offers_all_b_s.nextval

Line 1159: select ams_event_offers_all_b_s.nextval

1155: from ams_event_offers_all_b
1156: where event_offer_id = X_EVENT_OFFER_ID;
1157:
1158: cursor c_evo_id is
1159: select ams_event_offers_all_b_s.nextval
1160: from dual;
1161:
1162: BEGIN
1163: