APPS.JTF_PREFAB_POLICIES_PKG dependencies on JTF_PREFAB_UR_POLICIES

Line 432: DELETE FROM jtf_prefab_ur_policies

428: X_LAST_UPDATED_BY => f_luby,
429: X_LAST_UPDATE_LOGIN => 0);
430:
431: -- **** delete all the child entries ****
432: DELETE FROM jtf_prefab_ur_policies
433: WHERE policy_id = l_policy_id;
434: end if;
435: exception
436: when no_data_found then

Line 542: cursor c is select nvl(max(UR_POLICY_ID), 0) from jtf_prefab_ur_policies where UR_POLICY_ID < 10000;

538: db_luby NUMBER;
539: db_ludate DATE;
540: l_policy_id NUMBER;
541:
542: cursor c is select nvl(max(UR_POLICY_ID), 0) from jtf_prefab_ur_policies where UR_POLICY_ID < 10000;
543: l_pseudo_seq NUMBER := NULL;
544: begin
545:
546: if (X_OWNER = 'SEED') then

Line 557: FROM JTF_PREFAB_UR_POLICIES ur, JTF_PREFAB_POLICIES_B po

553:
554: begin
555: SELECT po.POLICY_ID, ur.LAST_UPDATED_BY, ur.LAST_UPDATE_DATE
556: INTO l_policy_id, db_luby, db_ludate
557: FROM JTF_PREFAB_UR_POLICIES ur, JTF_PREFAB_POLICIES_B po
558: WHERE po.POLICY_ID = ur.POLICY_ID AND
559: po.APPLICATION_ID = X_APPLICATION_ID AND
560: po.POLICY_NAME = X_POLICY_NAME AND
561: ur.USERRESP_ID = X_USERRESP_ID AND

Line 588: INSERT INTO jtf_prefab_ur_policies (ur_policy_id,

584: FROM JTF_PREFAB_POLICIES_B
585: WHERE APPLICATION_ID = X_APPLICATION_ID
586: AND POLICY_NAME = X_POLICY_NAME;
587:
588: INSERT INTO jtf_prefab_ur_policies (ur_policy_id,
589: object_version_number,
590: created_by,
591: creation_date,
592: last_updated_by,