APPS.IBY_DELIVERY_CHANNELS_PKG dependencies on IBY_DELIVERY_CHANNELS_B

Line 20: cursor C is select ROWID from IBY_DELIVERY_CHANNELS_B

16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER,
18: X_SEEDED_FLAG in VARCHAR2
19: ) is
20: cursor C is select ROWID from IBY_DELIVERY_CHANNELS_B
21: where DELIVERY_CHANNEL_CODE = X_DELIVERY_CHANNEL_CODE
22: ;
23: begin
24: insert into IBY_DELIVERY_CHANNELS_B (

Line 24: insert into IBY_DELIVERY_CHANNELS_B (

20: cursor C is select ROWID from IBY_DELIVERY_CHANNELS_B
21: where DELIVERY_CHANNEL_CODE = X_DELIVERY_CHANNEL_CODE
22: ;
23: begin
24: insert into IBY_DELIVERY_CHANNELS_B (
25: DELIVERY_CHANNEL_CODE,
26: FORMAT_VALUE,
27: OBJECT_VERSION_NUMBER,
28: INACTIVE_DATE,

Line 106: from IBY_DELIVERY_CHANNELS_B

102: FORMAT_VALUE,
103: OBJECT_VERSION_NUMBER,
104: INACTIVE_DATE,
105: TERRITORY_CODE
106: from IBY_DELIVERY_CHANNELS_B
107: where DELIVERY_CHANNEL_CODE = X_DELIVERY_CHANNEL_CODE
108: for update of DELIVERY_CHANNEL_CODE nowait;
109: recinfo c%rowtype;
110:

Line 172: update IBY_DELIVERY_CHANNELS_B set

168: X_LAST_UPDATED_BY in NUMBER,
169: X_LAST_UPDATE_LOGIN in NUMBER
170: ) is
171: begin
172: update IBY_DELIVERY_CHANNELS_B set
173: FORMAT_VALUE = X_FORMAT_VALUE,
174: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
175: INACTIVE_DATE = X_INACTIVE_DATE,
176: TERRITORY_CODE = X_TERRITORY_CODE,

Line 212: delete from IBY_DELIVERY_CHANNELS_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from IBY_DELIVERY_CHANNELS_B
213: where DELIVERY_CHANNEL_CODE = X_DELIVERY_CHANNEL_CODE;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 226: from IBY_DELIVERY_CHANNELS_B B

222: begin
223: delete from IBY_DELIVERY_CHANNELS_TL T
224: where not exists
225: (select NULL
226: from IBY_DELIVERY_CHANNELS_B B
227: where B.DELIVERY_CHANNEL_CODE = T.DELIVERY_CHANNEL_CODE
228: );
229:
230: update IBY_DELIVERY_CHANNELS_TL T set (