APPS.IEU_UWQM_PRIORITIES_PKG dependencies on IEU_UWQM_PRIORITIES_B

Line 11: cursor C is select ROWID from IEU_UWQM_PRIORITIES_B

7: P_NAME in VARCHAR2,
8: P_DESCRIPTION in VARCHAR2,
9: X_ROWID in out nocopy VARCHAR2
10: ) is
11: cursor C is select ROWID from IEU_UWQM_PRIORITIES_B
12: where PRIORITY_ID = P_PRIORITY_ID
13: ;
14: begin
15: insert into IEU_UWQM_PRIORITIES_B (

Line 15: insert into IEU_UWQM_PRIORITIES_B (

11: cursor C is select ROWID from IEU_UWQM_PRIORITIES_B
12: where PRIORITY_ID = P_PRIORITY_ID
13: ;
14: begin
15: insert into IEU_UWQM_PRIORITIES_B (
16: PRIORITY_CODE,
17: PRIORITY_ID,
18: OBJECT_VERSION_NUMBER,
19: PRIORITY_LEVEL,

Line 91: from IEU_UWQM_PRIORITIES_B

87: cursor c is select
88: PRIORITY_CODE,
89: OBJECT_VERSION_NUMBER,
90: PRIORITY_LEVEL
91: from IEU_UWQM_PRIORITIES_B
92: where PRIORITY_ID = P_PRIORITY_ID
93: for update of PRIORITY_ID nowait;
94: recinfo c%rowtype;
95:

Line 146: update IEU_UWQM_PRIORITIES_B set

142: P_NAME in VARCHAR2,
143: P_DESCRIPTION in VARCHAR2
144: ) is
145: begin
146: update IEU_UWQM_PRIORITIES_B set
147: PRIORITY_CODE = P_PRIORITY_CODE,
148: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
149: PRIORITY_LEVEL = P_PRIORITY_LEVEL,
150: LAST_UPDATE_DATE = SYSDATE,

Line 185: delete from IEU_UWQM_PRIORITIES_B

181: if (sql%notfound) then
182: raise no_data_found;
183: end if;
184:
185: delete from IEU_UWQM_PRIORITIES_B
186: where PRIORITY_ID = P_PRIORITY_ID;
187:
188: if (sql%notfound) then
189: raise no_data_found;

Line 199: from IEU_UWQM_PRIORITIES_B B

195: begin
196: delete from IEU_UWQM_PRIORITIES_TL T
197: where not exists
198: (select NULL
199: from IEU_UWQM_PRIORITIES_B B
200: where B.PRIORITY_ID = T.PRIORITY_ID
201: );
202:
203: update IEU_UWQM_PRIORITIES_TL T set (