APPS.JTF_IAPP_FAMILIES_PKG dependencies on JTF_IAPP_FAMILY_USR_MAP

Line 326: from JTF_IAPP_FAMILIES_B f, JTF_IAPP_FAMILY_USR_MAP u

322: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
323: ;
324:
325: cursor C_2 is select f.APP_FAMILY_ID, USER_ID
326: from JTF_IAPP_FAMILIES_B f, JTF_IAPP_FAMILY_USR_MAP u
327: where f.APP_FAMILY_ID = u.APP_FAMILY_ID
328: AND f.APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
329: AND u.USER_ID = X_USER_ID
330: ;

Line 349: insert into JTF_IAPP_FAMILY_USR_MAP (

345: CLOSE C;
346: End If;
347:
348: if (C_2%notfound) then
349: insert into JTF_IAPP_FAMILY_USR_MAP (
350: APP_FAMILY_ID,
351: USER_ID,
352: DEFAULT_RESP_ID,
353: CREATED_BY,

Line 370: update JTF_IAPP_FAMILY_USR_MAP set

366: G_LOGIN_ID
367: );
368: else
369:
370: update JTF_IAPP_FAMILY_USR_MAP set
371: DEFAULT_RESP_ID = X_DEFAULT_RESP_ID,
372: LAST_UPDATE_DATE = SYSDATE,
373: LAST_UPDATED_BY = G_USER_ID,
374: LAST_UPDATE_LOGIN = G_LOGIN_ID

Line 409: delete from JTF_IAPP_FAMILY_USR_MAP

405: OPEN C;
406: FETCH C INTO l_app_family_id;
407: CLOSE C;
408:
409: delete from JTF_IAPP_FAMILY_USR_MAP
410: where APP_FAMILY_ID = l_app_family_id
411: AND USER_ID = X_USER_ID;
412:
413: if (sql%notfound) then

Line 430: delete from JTF_IAPP_FAMILY_USR_MAP

426: begin
427:
428: If (X_APP_FAMILY_ID IS NOT NULL AND X_USER_ID IS NOT NULL) then
429:
430: delete from JTF_IAPP_FAMILY_USR_MAP
431: where APP_FAMILY_ID = X_APP_FAMILY_ID
432: AND USER_ID = X_USER_ID;
433:
434: if (sql%notfound) then