APPS.JTF_IAPP_FAMILIES_PKG dependencies on JTF_IAPP_FAMILIES_B_S

Line 21: select JTF_IAPP_FAMILIES_B_S.nextval from SYS.DUAL

17: where APP_FAMILY_ID = X_APP_FAMILY_ID
18: ;
19:
20: cursor C_2 is
21: select JTF_IAPP_FAMILIES_B_S.nextval from SYS.DUAL
22: ;
23:
24: l_app_family_id NUMBER := NULL;
25: l_last_updated_by NUMBER := G_USER_ID;

Line 126: update JTF_IAPP_FAMILIES_B set

122:
123: l_last_updated_by NUMBER := G_USER_ID;
124:
125: begin
126: update JTF_IAPP_FAMILIES_B set
127: APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME,
128: DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
129: ENABLED_FLAG = X_ENABLED_FLAG,
130: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 277: update JTF_IAPP_FAMILIES_B set DELETED_FLAG = 'Y' where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME;

273: begin
274:
275: jtf_iapp_families_pkg.DELETE_ALL_APPS_IN_FAMILY (X_APP_FAMILY_ACCESS_NAME => X_APP_FAMILY_ACCESS_NAME);
276:
277: update JTF_IAPP_FAMILIES_B set DELETED_FLAG = 'Y' where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME;
278:
279: if (sql%notfound) then
280: raise no_data_found;
281: end if;