APPS.JTF_AE_PROFPROPS dependencies on JTF_PROFILEPROPERTIES_B

Line 19: cursor C is select ROWID from JTF_PROFILEPROPERTIES_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from JTF_PROFILEPROPERTIES_B
20: where PROFILEPROPERTIES_ID = X_PROFILEPROPERTIES_ID
21: ;
22: begin
23: insert into JTF_PROFILEPROPERTIES_B (

Line 23: insert into JTF_PROFILEPROPERTIES_B (

19: cursor C is select ROWID from JTF_PROFILEPROPERTIES_B
20: where PROFILEPROPERTIES_ID = X_PROFILEPROPERTIES_ID
21: ;
22: begin
23: insert into JTF_PROFILEPROPERTIES_B (
24: PROFILE_MAPPINGS_ID,
25: ATTRNAME,
26: OWNER_APPLICATION_ID,
27: ISPRIMARYKEY_FLAG_CODE,

Line 110: from JTF_PROFILEPROPERTIES_B

106: OWNER_APPLICATION_ID,
107: ISPRIMARYKEY_FLAG_CODE,
108: OBJECT_VERSION_NUMBER,
109: SECURITY_GROUP_ID
110: from JTF_PROFILEPROPERTIES_B
111: where PROFILEPROPERTIES_ID = X_PROFILEPROPERTIES_ID
112: for update of PROFILEPROPERTIES_ID nowait;
113: recinfo c%rowtype;
114:

Line 179: update JTF_PROFILEPROPERTIES_B set

175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: begin
179: update JTF_PROFILEPROPERTIES_B set
180: PROFILE_MAPPINGS_ID = X_PROFILE_MAPPINGS_ID,
181: ATTRNAME = X_ATTRNAME,
182: OWNER_APPLICATION_ID = X_OWNER_APPLICATION_ID,
183: ISPRIMARYKEY_FLAG_CODE = X_ISPRIMARYKEY_FLAG_CODE,

Line 221: delete from JTF_PROFILEPROPERTIES_B

217: if (sql%notfound) then
218: raise no_data_found;
219: end if;
220:
221: delete from JTF_PROFILEPROPERTIES_B
222: where PROFILEPROPERTIES_ID = X_PROFILEPROPERTIES_ID;
223:
224: if (sql%notfound) then
225: raise no_data_found;

Line 235: from JTF_PROFILEPROPERTIES_B B

231: begin
232: delete from JTF_PROFILEPROPERTIES_TL T
233: where not exists
234: (select NULL
235: from JTF_PROFILEPROPERTIES_B B
236: where B.PROFILEPROPERTIES_ID = T.PROFILEPROPERTIES_ID
237: );
238:
239: update JTF_PROFILEPROPERTIES_TL T set (