APPS.JTF_PREFAB_POLICIES_PKG dependencies on JTF_PREFAB_POLICIES_B

Line 28: cursor C is select ROWID from JTF_PREFAB_POLICIES_B

24: X_LAST_UPDATE_DATE in DATE,
25: X_LAST_UPDATED_BY in NUMBER,
26: X_LAST_UPDATE_LOGIN in NUMBER
27: ) is
28: cursor C is select ROWID from JTF_PREFAB_POLICIES_B
29: where POLICY_ID = X_POLICY_ID
30: ;
31: begin
32: insert into JTF_PREFAB_POLICIES_B (

Line 32: insert into JTF_PREFAB_POLICIES_B (

28: cursor C is select ROWID from JTF_PREFAB_POLICIES_B
29: where POLICY_ID = X_POLICY_ID
30: ;
31: begin
32: insert into JTF_PREFAB_POLICIES_B (
33: POLICY_ID,
34: OBJECT_VERSION_NUMBER,
35: -- SECURITY_GROUP_ID,
36: POLICY_NAME,

Line 153: from JTF_PREFAB_POLICIES_B

149: INTERVAL_UNIT,
150: START_TIME,
151: END_TIME,
152: RUN_ALWAYS_FLAG
153: from JTF_PREFAB_POLICIES_B
154: where POLICY_ID = X_POLICY_ID
155: for update of POLICY_ID nowait;
156: recinfo c%rowtype;
157:

Line 234: update JTF_PREFAB_POLICIES_B set

230: X_LAST_UPDATED_BY in NUMBER,
231: X_LAST_UPDATE_LOGIN in NUMBER
232: ) is
233: begin
234: update JTF_PREFAB_POLICIES_B set
235: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
236: -- SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
237: POLICY_NAME = X_POLICY_NAME,
238: PRIORITY = X_PRIORITY,

Line 284: delete from JTF_PREFAB_POLICIES_B

280: if (sql%notfound) then
281: raise no_data_found;
282: end if;
283:
284: delete from JTF_PREFAB_POLICIES_B
285: where POLICY_ID = X_POLICY_ID;
286:
287: if (sql%notfound) then
288: raise no_data_found;

Line 298: from JTF_PREFAB_POLICIES_B B

294: begin
295: delete from JTF_PREFAB_POLICIES_TL T
296: where not exists
297: (select NULL
298: from JTF_PREFAB_POLICIES_B B
299: where B.POLICY_ID = T.POLICY_ID
300: );
301:
302: update JTF_PREFAB_POLICIES_TL T set (

Line 383: cursor c is select nvl(max(POLICY_ID), 0) from jtf_prefab_policies_b where POLICY_ID < 10000;

379: db_luby NUMBER;
380: db_ludate DATE;
381: l_policy_id NUMBER;
382:
383: cursor c is select nvl(max(POLICY_ID), 0) from jtf_prefab_policies_b where POLICY_ID < 10000;
384: l_pseudo_seq NUMBER := NULL;
385: begin
386:
387: if (X_OWNER = 'SEED') then

Line 398: FROM JTF_PREFAB_POLICIES_B

394:
395: begin
396: SELECT POLICY_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
397: INTO l_policy_id, db_luby, db_ludate
398: FROM JTF_PREFAB_POLICIES_B
399: WHERE APPLICATION_ID = X_APPLICATION_ID AND
400: POLICY_NAME = X_POLICY_NAME;
401:
402: -- **** Entry is there, check if it's legal to update ****

Line 497: FROM JTF_PREFAB_POLICIES_B b, JTF_PREFAB_POLICIES_TL tl

493:
494: begin
495: SELECT tl.POLICY_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
496: INTO l_policy_id, db_luby, db_ludate
497: FROM JTF_PREFAB_POLICIES_B b, JTF_PREFAB_POLICIES_TL tl
498: WHERE b.POLICY_ID = tl.POLICY_ID AND
499: b.APPLICATION_ID = X_APPLICATION_ID AND
500: b.POLICY_NAME = X_POLICY_NAME AND
501: tl.LANGUAGE = userenv('LANG');

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 584: FROM JTF_PREFAB_POLICIES_B

580:
581: -- **** get policy id ***
582: SELECT POLICY_ID
583: INTO l_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,