1 PACKAGE JTF_RS_GROUP_DENORM_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfrsvds.pls 120.0 2005/05/11 08:22:55 appldev ship $ */
3 -- API Name : JTF_RS_GROUP_DENORM_PVT
4 -- Type : Private
5 -- Purpose : Inserts/Update the JTF_RS_GROUP_DENORM_PVT table based on changes in jtf_rs_grp_relations
6 -- Modification History
7 -- DATE NAME PURPOSE
8 -- S Choudhury Created
9 -- Notes:
10 --
11 -- This is an internal use function which is used by JTF_RS_GROUP_DENORM_PVT
12 -- and sql/jtfrsbgd.sql(concurrent program to populate groups denorm)
13 -- and not a public function. It gives direct parent ID(ACTUAL_PARENT_ID)
14 -- for a given groups_drnorm table record, originally requested for
15 -- DBI perf. enhancement # 2759986
16 FUNCTION getDirectParent(p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
17 p_level JTF_RS_GROUPS_DENORM.DENORM_LEVEL%type,
18 p_parent_group_id JTF_RS_GROUPS_DENORM.parent_group_id%type,
19 p_start_date JTF_RS_GROUPS_DENORM.start_date_active%TYPE,
20 p_end_date JTF_RS_GROUPS_DENORM.end_date_active%TYPE) RETURN NUMBER;
21
22 --to be called when a group is created
23 PROCEDURE CREATE_RES_GROUPS(
24 P_API_VERSION IN NUMBER,
25 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27 p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
28 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29 X_MSG_COUNT OUT NOCOPY NUMBER,
30 X_MSG_DATA OUT NOCOPY VARCHAR2 );
31
32
33 --to be called when a group record is updated
34 PROCEDURE UPDATE_RES_GROUPS(
35 P_API_VERSION IN NUMBER,
36 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38 p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
39 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
40 X_MSG_COUNT OUT NOCOPY NUMBER,
41 X_MSG_DATA OUT NOCOPY VARCHAR2 );
42
43
44
45 /*FOR INSERT IN GRP_RELATIONS */
46
47
48 PROCEDURE INSERT_GROUPS(
49 P_API_VERSION IN NUMBER,
50 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52 p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
53 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
54 X_MSG_COUNT OUT NOCOPY NUMBER,
55 X_MSG_DATA OUT NOCOPY VARCHAR2 );
56
57
58 /*FOR INSERT OF PARENTS ONLY FOR A GROUP and is being called from
59 JTF_RS_GROUP_DENORM_PVT.DELETE_GRP_RELATIONS */
60
61 PROCEDURE INSERT_GROUPS_PARENT(
62 P_API_VERSION IN NUMBER,
63 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
66 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
67 X_MSG_COUNT OUT NOCOPY NUMBER,
68 X_MSG_DATA OUT NOCOPY VARCHAR2 );
69
70
71
72 --FOR UPDATE in grp relations
73
74 PROCEDURE UPDATE_GROUPS(
75 P_API_VERSION IN NUMBER,
76 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78 p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
79 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
80 X_MSG_COUNT OUT NOCOPY NUMBER,
81 X_MSG_DATA OUT NOCOPY VARCHAR2 );
82
83
84
85 --FOR delete in grp relations ... perf tuned
86
87 PROCEDURE DELETE_GRP_RELATIONS(
88 P_API_VERSION IN NUMBER,
89 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91 p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
92 p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
93 p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
94 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95 X_MSG_COUNT OUT NOCOPY NUMBER,
96 X_MSG_DATA OUT NOCOPY VARCHAR2);
97
98
99 --FOR DELETE this is not being used after apr 24, 2001
100
101 PROCEDURE DELETE_GROUPS(
102 P_API_VERSION IN NUMBER,
103 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105 p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
106 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
107 X_MSG_COUNT OUT NOCOPY NUMBER,
108 X_MSG_DATA OUT NOCOPY VARCHAR2);
109
110 END JTF_RS_GROUP_DENORM_PVT;