APPS.JTF_PREFAB_POLICIES_PKG dependencies on JTF_PREFAB_SYS_POLICIES

Line 651: FROM JTF_PREFAB_SYS_POLICIES;

647:
648: begin
649: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
650: INTO db_luby, db_ludate
651: FROM JTF_PREFAB_SYS_POLICIES;
652:
653: -- **** Entry is there, check if it's legal to update ****
654: IF ((X_CUSTOM_MODE = 'FORCE') OR
655: ((f_luby = 0) AND (db_luby = 1)) OR

Line 660: UPDATE jtf_prefab_sys_policies

656: ((f_luby = db_luby) AND (f_ludate > db_ludate))
657: )
658: then
659: -- **** update ****
660: UPDATE jtf_prefab_sys_policies
661: SET object_version_number = X_OBJECT_VERSION_NUMBER,
662: last_updated_by = f_luby,
663: last_update_date = f_ludate,
664: last_update_login = 0,

Line 678: INSERT INTO jtf_prefab_sys_policies (sys_policy_id,

674: cache_memory = X_CACHE_MEMORY;
675: end if;
676: exception
677: when no_data_found then
678: INSERT INTO jtf_prefab_sys_policies (sys_policy_id,
679: object_version_number,
680: created_by,
681: creation_date,
682: last_updated_by,