APPS.JTF_AE_PROFRULES dependencies on JTF_PROFILE_RULES_B

Line 16: cursor C is select ROWID from JTF_PROFILE_RULES_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 JTF_PROFILE_RULES_B
17: where PROFILE_RULES_ID = X_PROFILE_RULES_ID
18: ;
19: begin
20: insert into JTF_PROFILE_RULES_B (

Line 20: insert into JTF_PROFILE_RULES_B (

16: cursor C is select ROWID from JTF_PROFILE_RULES_B
17: where PROFILE_RULES_ID = X_PROFILE_RULES_ID
18: ;
19: begin
20: insert into JTF_PROFILE_RULES_B (
21: SECURITY_GROUP_ID,
22: PROFILE_RULES_ID,
23: PROFILE_METADATA_ID,
24: RULE,

Line 96: from JTF_PROFILE_RULES_B

92: SECURITY_GROUP_ID,
93: PROFILE_METADATA_ID,
94: RULE,
95: OBJECT_VERSION_NUMBER
96: from JTF_PROFILE_RULES_B
97: where PROFILE_RULES_ID = X_PROFILE_RULES_ID
98: for update of PROFILE_RULES_ID nowait;
99: recinfo c%rowtype;
100:

Line 158: update JTF_PROFILE_RULES_B set

154: X_LAST_UPDATED_BY in NUMBER,
155: X_LAST_UPDATE_LOGIN in NUMBER
156: ) is
157: begin
158: update JTF_PROFILE_RULES_B set
159: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
160: PROFILE_METADATA_ID = X_PROFILE_METADATA_ID,
161: RULE = X_RULE,
162: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 197: delete from JTF_PROFILE_RULES_B

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

Line 211: from JTF_PROFILE_RULES_B B

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