APPS.JTF_DIAGNOSTIC_SYNC dependencies on JTF_DIAGNOSTIC_CMAP

Line 5: key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE;

1: package body jtf_diagnostic_sync as
2: /* $Header: jtfdiagsyncb.pls 115.1 2003/07/30 00:48:16 navkumar noship $ */
3: PROCEDURE diagSyncAll
4: IS
5: key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE;
6: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE;
7: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE;
8: classList JTF_DIAGNOSTIC_LOG.versions%TYPE;
9: CURSOR diagnose IS

Line 6: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE;

2: /* $Header: jtfdiagsyncb.pls 115.1 2003/07/30 00:48:16 navkumar noship $ */
3: PROCEDURE diagSyncAll
4: IS
5: key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE;
6: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE;
7: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE;
8: classList JTF_DIAGNOSTIC_LOG.versions%TYPE;
9: CURSOR diagnose IS
10: select

Line 7: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE;

3: PROCEDURE diagSyncAll
4: IS
5: key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE;
6: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE;
7: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE;
8: classList JTF_DIAGNOSTIC_LOG.versions%TYPE;
9: CURSOR diagnose IS
10: select
11: appName,

Line 28: FUNCTION diagsync( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,

24: END LOOP;
25: CLOSE diagnose;
26: END diagSyncAll;
27:
28: FUNCTION diagsync( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,
29: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,
30: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,
31: classList JTF_DIAGNOSTIC_LOG.versions%TYPE)
32: RETURN INTEGER IS

Line 29: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,

25: CLOSE diagnose;
26: END diagSyncAll;
27:
28: FUNCTION diagsync( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,
29: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,
30: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,
31: classList JTF_DIAGNOSTIC_LOG.versions%TYPE)
32: RETURN INTEGER IS
33: entries INTEGER := 0;

Line 30: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,

26: END diagSyncAll;
27:
28: FUNCTION diagsync( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,
29: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,
30: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,
31: classList JTF_DIAGNOSTIC_LOG.versions%TYPE)
32: RETURN INTEGER IS
33: entries INTEGER := 0;
34: x INTEGER := 0;

Line 36: className JTF_DIAGNOSTIC_CMAP.className%TYPE;

32: RETURN INTEGER IS
33: entries INTEGER := 0;
34: x INTEGER := 0;
35: prev INTEGER;
36: className JTF_DIAGNOSTIC_CMAP.className%TYPE;
37: parseState INTEGER := -1;
38: parseString VARCHAR2(20);
39: BEGIN
40: -- entries := entries+diagentry(key1, key2, key3, key3);

Line 41: delete from JTF_DIAGNOSTIC_CMAP

37: parseState INTEGER := -1;
38: parseString VARCHAR2(20);
39: BEGIN
40: -- entries := entries+diagentry(key1, key2, key3, key3);
41: delete from JTF_DIAGNOSTIC_CMAP
42: where
43: appName = key1
44: and groupName = key2
45: and testClassName = key3;

Line 81: FUNCTION diagentry( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,

77: end if;
78: END LOOP;
79: END diagsync;
80:
81: FUNCTION diagentry( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,
82: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,
83: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,
84: className JTF_DIAGNOSTIC_CMAP.className%TYPE)
85: RETURN INTEGER IS

Line 82: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,

78: END LOOP;
79: END diagsync;
80:
81: FUNCTION diagentry( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,
82: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,
83: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,
84: className JTF_DIAGNOSTIC_CMAP.className%TYPE)
85: RETURN INTEGER IS
86: BEGIN

Line 83: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,

79: END diagsync;
80:
81: FUNCTION diagentry( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,
82: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,
83: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,
84: className JTF_DIAGNOSTIC_CMAP.className%TYPE)
85: RETURN INTEGER IS
86: BEGIN
87: insert into JTF_DIAGNOSTIC_CMAP(

Line 84: className JTF_DIAGNOSTIC_CMAP.className%TYPE)

80:
81: FUNCTION diagentry( key1 JTF_DIAGNOSTIC_CMAP.appName%TYPE,
82: key2 JTF_DIAGNOSTIC_CMAP.groupName%TYPE,
83: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,
84: className JTF_DIAGNOSTIC_CMAP.className%TYPE)
85: RETURN INTEGER IS
86: BEGIN
87: insert into JTF_DIAGNOSTIC_CMAP(
88: appName,

Line 87: insert into JTF_DIAGNOSTIC_CMAP(

83: key3 JTF_DIAGNOSTIC_CMAP.testClassName%TYPE,
84: className JTF_DIAGNOSTIC_CMAP.className%TYPE)
85: RETURN INTEGER IS
86: BEGIN
87: insert into JTF_DIAGNOSTIC_CMAP(
88: appName,
89: groupName,
90: testClassName,
91: classname)