APPS.IEU_UWQ_LOGIN_RULES_PKG dependencies on IEU_UWQ_LOGIN_RULES_B

Line 18: cursor C is select ROWID from IEU_UWQ_LOGIN_RULES_B

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17:
18: cursor C is select ROWID from IEU_UWQ_LOGIN_RULES_B
19: where SVR_LOGIN_RULE_ID = X_SVR_LOGIN_RULE_ID;
20:
21: begin
22: insert into IEU_UWQ_LOGIN_RULES_B (

Line 22: insert into IEU_UWQ_LOGIN_RULES_B (

18: cursor C is select ROWID from IEU_UWQ_LOGIN_RULES_B
19: where SVR_LOGIN_RULE_ID = X_SVR_LOGIN_RULE_ID;
20:
21: begin
22: insert into IEU_UWQ_LOGIN_RULES_B (
23: SVR_LOGIN_RULE_ID,
24: LOGIN_RULE_TYPE,
25: LOGIN_RULE,
26: OBJECT_VERSION_NUMBER,

Line 98: from IEU_UWQ_LOGIN_RULES_B

94: cursor c is select
95: OBJECT_VERSION_NUMBER,
96: LOGIN_RULE_TYPE,
97: LOGIN_RULE
98: from IEU_UWQ_LOGIN_RULES_B
99: where SVR_LOGIN_RULE_ID = X_SVR_LOGIN_RULE_ID
100: for update of SVR_LOGIN_RULE_ID nowait;
101: recinfo c%rowtype;
102:

Line 157: update IEU_UWQ_LOGIN_RULES_B set

153: X_LAST_UPDATED_BY in NUMBER,
154: X_LAST_UPDATE_LOGIN in NUMBER
155: ) is
156: begin
157: update IEU_UWQ_LOGIN_RULES_B set
158: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
159: LOGIN_RULE_TYPE = X_LOGIN_RULE_TYPE,
160: LOGIN_RULE = X_LOGIN_RULE,
161: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 197: delete from IEU_UWQ_LOGIN_RULES_B

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

Line 211: from IEU_UWQ_LOGIN_RULES_B B

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