APPS.IEU_UWQ_RES_CATS_PKG dependencies on IEU_UWQ_RES_CATS_B

Line 18: cursor C is select ROWID from IEU_UWQ_RES_CATS_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 IEU_UWQ_RES_CATS_B
19: where RES_CAT_ID = X_RES_CAT_ID
20: ;
21: begin
22:

Line 23: insert into IEU_UWQ_RES_CATS_B (

19: where RES_CAT_ID = X_RES_CAT_ID
20: ;
21: begin
22:
23: insert into IEU_UWQ_RES_CATS_B (
24: RES_CAT_ID,
25: OBJECT_VERSION_NUMBER,
26: APPLICATION_ID,
27: WHERE_CLAUSE,

Line 99: from IEU_UWQ_RES_CATS_B

95: cursor c is select
96: OBJECT_VERSION_NUMBER,
97: APPLICATION_ID,
98: WHERE_CLAUSE
99: from IEU_UWQ_RES_CATS_B
100: where RES_CAT_ID = X_RES_CAT_ID
101: for update of RES_CAT_ID nowait;
102: recinfo c%rowtype;
103:

Line 158: update IEU_UWQ_RES_CATS_B set

154: X_LAST_UPDATED_BY in NUMBER,
155: X_LAST_UPDATE_LOGIN in NUMBER
156: ) is
157: begin
158: update IEU_UWQ_RES_CATS_B set
159: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
160: APPLICATION_ID = X_APPLICATION_ID,
161: WHERE_CLAUSE = X_WHERE_CLAUSE,
162: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 197: delete from IEU_UWQ_RES_CATS_B

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

Line 211: from IEU_UWQ_RES_CATS_B B

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