APPS.ENG_CHANGE_LOGS_PKG dependencies on ENG_CHANGE_LOGS_B

Line 23: cursor C is select ROWID from ENG_CHANGE_LOGS_B

19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER,
21: X_CHANGE_PROPAGATION_MAP_ID IN NUMBER
22: ) is
23: cursor C is select ROWID from ENG_CHANGE_LOGS_B
24: where CHANGE_LOG_ID = X_CHANGE_LOG_ID
25: ;
26: begin
27: insert into ENG_CHANGE_LOGS_B (

Line 27: insert into ENG_CHANGE_LOGS_B (

23: cursor C is select ROWID from ENG_CHANGE_LOGS_B
24: where CHANGE_LOG_ID = X_CHANGE_LOG_ID
25: ;
26: begin
27: insert into ENG_CHANGE_LOGS_B (
28: CHANGE_LOG_ID,
29: CHANGE_ID,
30: CHANGE_LINE_ID,
31: LOCAL_REVISED_ITEM_SEQUENCE_ID,

Line 126: from ENG_CHANGE_LOGS_B

122: LOCAL_CHANGE_LINE_ID,
123: REVISED_ITEM_SEQUENCE_ID,
124: LOCAL_ORGANIZATION_ID,
125: CHANGE_PROPAGATION_MAP_ID
126: from ENG_CHANGE_LOGS_B
127: where CHANGE_LOG_ID = X_CHANGE_LOG_ID
128: for update of CHANGE_LOG_ID nowait;
129: recinfo c%rowtype;
130:

Line 206: update ENG_CHANGE_LOGS_B set

202: X_LAST_UPDATE_LOGIN in NUMBER,
203: X_CHANGE_PROPAGATION_MAP_ID IN NUMBER
204: ) is
205: begin
206: update ENG_CHANGE_LOGS_B set
207: CHANGE_ID = X_CHANGE_ID,
208: CHANGE_LINE_ID = X_CHANGE_LINE_ID,
209: LOCAL_REVISED_ITEM_SEQUENCE_ID = X_LOCAL_REVISED_ITEM_SEQUENCE_,
210: LOG_CLASSIFICATION_CODE = X_LOG_CLASSIFICATION_CODE,

Line 251: delete from ENG_CHANGE_LOGS_B

247: if (sql%notfound) then
248: raise no_data_found;
249: end if;
250:
251: delete from ENG_CHANGE_LOGS_B
252: where CHANGE_LOG_ID = X_CHANGE_LOG_ID;
253:
254: if (sql%notfound) then
255: raise no_data_found;

Line 265: from ENG_CHANGE_LOGS_B B

261: begin
262: delete from ENG_CHANGE_LOGS_TL T
263: where not exists
264: (select NULL
265: from ENG_CHANGE_LOGS_B B
266: where B.CHANGE_LOG_ID = T.CHANGE_LOG_ID
267: );
268:
269: update ENG_CHANGE_LOGS_TL T set (