APPS.ENG_CHANGE_CLASSIFICATIONS_PKG dependencies on ENG_CHANGE_CLASSIFICATIONS_B

Line 16: cursor C is select ROWID from ENG_CHANGE_CLASSIFICATIONS_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from ENG_CHANGE_CLASSIFICATIONS_B
17: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
18: ;
19: begin
20: insert into ENG_CHANGE_CLASSIFICATIONS_B (

Line 20: insert into ENG_CHANGE_CLASSIFICATIONS_B (

16: cursor C is select ROWID from ENG_CHANGE_CLASSIFICATIONS_B
17: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
18: ;
19: begin
20: insert into ENG_CHANGE_CLASSIFICATIONS_B (
21: START_DATE,
22: END_DATE,
23: CLASSIFICATION_ID,
24: CREATION_DATE,

Line 86: from ENG_CHANGE_CLASSIFICATIONS_B

82: ) is
83: cursor c is select
84: START_DATE,
85: END_DATE
86: from ENG_CHANGE_CLASSIFICATIONS_B
87: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
88: for update of CLASSIFICATION_ID nowait;
89: recinfo c%rowtype;
90: cursor c1 is select

Line 144: update ENG_CHANGE_CLASSIFICATIONS_B set

140: X_LAST_UPDATED_BY in NUMBER,
141: X_LAST_UPDATE_LOGIN in NUMBER
142: ) is
143: begin
144: update ENG_CHANGE_CLASSIFICATIONS_B set
145: START_DATE = X_START_DATE,
146: END_DATE = X_END_DATE,
147: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
148: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 176: delete from ENG_CHANGE_CLASSIFICATIONS_B

172: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
173: if (sql%notfound) then
174: raise no_data_found;
175: end if;
176: delete from ENG_CHANGE_CLASSIFICATIONS_B
177: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
178: if (sql%notfound) then
179: raise no_data_found;
180: end if;

Line 188: from ENG_CHANGE_CLASSIFICATIONS_B B

184: begin
185: delete from ENG_CHANGE_CLASSIFICATIONS_TL T
186: where not exists
187: (select NULL
188: from ENG_CHANGE_CLASSIFICATIONS_B B
189: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
190: );
191: update ENG_CHANGE_CLASSIFICATIONS_TL T set (
192: DESCRIPTION,