APPS.ENG_CHANGE_TEMPLATES_PKG dependencies on ENG_CHANGE_TEMPLATES_B

Line 18: cursor C is select ROWID from ENG_CHANGE_TEMPLATES_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from ENG_CHANGE_TEMPLATES_B
19: where CHANGE_TEMPLATE_ID = X_CHANGE_TEMPLATE_ID
20: ;
21: begin
22: insert into ENG_CHANGE_TEMPLATES_B (

Line 22: insert into ENG_CHANGE_TEMPLATES_B (

18: cursor C is select ROWID from ENG_CHANGE_TEMPLATES_B
19: where CHANGE_TEMPLATE_ID = X_CHANGE_TEMPLATE_ID
20: ;
21: begin
22: insert into ENG_CHANGE_TEMPLATES_B (
23: CHANGE_TEMPLATE_ID,
24: ORGANIZATION_ID,
25: START_DATE,
26: END_DATE,

Line 96: from ENG_CHANGE_TEMPLATES_B

92: cursor c is select
93: ORGANIZATION_ID,
94: START_DATE,
95: END_DATE
96: from ENG_CHANGE_TEMPLATES_B
97: where CHANGE_TEMPLATE_ID = X_CHANGE_TEMPLATE_ID
98: for update of CHANGE_TEMPLATE_ID nowait;
99: recinfo c%rowtype;
100:

Line 158: update ENG_CHANGE_TEMPLATES_B set

154: X_LAST_UPDATED_BY in NUMBER,
155: X_LAST_UPDATE_LOGIN in NUMBER
156: ) is
157: begin
158: update ENG_CHANGE_TEMPLATES_B set
159: ORGANIZATION_ID = X_ORGANIZATION_ID,
160: START_DATE = X_START_DATE,
161: END_DATE = X_END_DATE,
162: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 197: delete from ENG_CHANGE_TEMPLATES_B

193: if (sql%notfound) then
194: raise no_data_found;
195: end if;
196:
197: delete from ENG_CHANGE_TEMPLATES_B
198: where CHANGE_TEMPLATE_ID = X_CHANGE_TEMPLATE_ID;
199:
200: if (sql%notfound) then
201: raise no_data_found;

Line 211: from ENG_CHANGE_TEMPLATES_B B

207: begin
208: delete from ENG_CHANGE_TEMPLATES_TL T
209: where not exists
210: (select NULL
211: from ENG_CHANGE_TEMPLATES_B B
212: where B.CHANGE_TEMPLATE_ID = T.CHANGE_TEMPLATE_ID
213: );
214:
215: update ENG_CHANGE_TEMPLATES_TL T set (