1 PACKAGE JTF_RS_REP_MGR_DENORM_PVT AS
2 /* $Header: jtfrsvps.pls 120.0 2005/05/11 08:23:13 appldev ship $ */
3
4 -- API Name : JTF_RS_REP_MGR_DENORM_PVT
5 -- Type : Private
6 -- Purpose : Inserts/Update the JTF_RS_REPORTING_MANAGERS table based on changes in jtf_rs_role_relations,
7 -- jtf_rs_grp_relations
8 -- Modification History
9 -- DATE NAME PURPOSE
10 -- 7 Oct 1999 S Choudhury Created
11 -- Notes:
12 --
13
14 /*FOR INSERT IN JTF_RS_ROLE_RELATIONS */
15 --SHOULD BE CALLED AFTER THE ROLE RELATE ROW HAS BEEN INSERTED
16 PROCEDURE INSERT_REP_MANAGER(
17 P_API_VERSION IN NUMBER,
18 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20 P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
21 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22 X_MSG_COUNT OUT NOCOPY NUMBER,
23 X_MSG_DATA OUT NOCOPY VARCHAR2 );
24
25 /*FOR INSERT IN JTF_RS_ROLE_RELATIONS */
26 --SHOULD BE CALLED from the api jtf_rs_groups_denorm.delete_resource_group_relate
27 -- not being used anymore
28 PROCEDURE INSERT_REP_MGR_PARENT(
29 P_API_VERSION IN NUMBER,
30 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
32 P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
33 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34 X_MSG_COUNT OUT NOCOPY NUMBER,
35 X_MSG_DATA OUT NOCOPY VARCHAR2 );
36
37
38 --SHOULD BE CALLED AFTER THE ROLE RELATE ROW HAS BEEN INSERTED --only for migration
39 PROCEDURE INSERT_REP_MANAGER_MIGR(
40 P_API_VERSION IN NUMBER,
41 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43 P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
44 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
45 X_MSG_COUNT OUT NOCOPY NUMBER,
46 X_MSG_DATA OUT NOCOPY VARCHAR2 );
47
48
49
50 --FOR UPDATE on jtf_rs_ROLE_RELATE
51 --SHOULD BE CALLED AFTER THE TABLE HAS BEEN UPDATED
52 PROCEDURE UPDATE_REP_MANAGER(
53 P_API_VERSION IN NUMBER,
54 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
57 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
58 X_MSG_COUNT OUT NOCOPY NUMBER,
59 X_MSG_DATA OUT NOCOPY VARCHAR2 );
60
61 -- FOR DELETE ON JTF_RS_ROLE_RELATE
62 PROCEDURE DELETE_MEMBERS(
63 P_API_VERSION IN NUMBER,
64 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66 P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
67 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
68 X_MSG_COUNT OUT NOCOPY NUMBER,
69 X_MSG_DATA OUT NOCOPY VARCHAR2 );
70
71 /*FOR INSERT IN JTF_RS_GRP_RELATIONS */
72 --AFTER THE GROUP RELATION ROW HAS BEEN INSERTED
73 -- may not be used after 23-apr-2001
74 PROCEDURE INSERT_GRP_RELATIONS(
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_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_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 --when a insert is done in groups denorm
84 PROCEDURE INSERT_GRP_DENORM(
85 P_API_VERSION IN NUMBER,
86 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88 P_GROUP_DENORM_ID IN NUMBER,
89 P_GROUP_ID IN NUMBER,
90 P_PARENT_GROUP_ID IN NUMBER,
91 P_START_DATE_ACTIVE IN DATE,
92 P_END_DATE_ACTIVE IN DATE,
93 P_IMMEDIATE_PARENT_FLAG IN VARCHAR2,
94 P_DENORM_LEVEL IN NUMBER DEFAULT NULL,
95 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96 X_MSG_COUNT OUT NOCOPY NUMBER,
97 X_MSG_DATA OUT NOCOPY VARCHAR2 );
98
99 -- FOR DELETE ON JTF_RS_GROUPS_DENORM
100 -- SHOULD BE CALLED BEFORE THE DENORM RECORD IS ACTUALLY DELETED FROM THE TABLE
101 -- being used after 23 apr 2004
102 PROCEDURE DELETE_GROUP_DENORM(
103 P_API_VERSION IN NUMBER,
104 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106 P_DENORM_GRP_ID IN JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE,
107 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
108 X_MSG_COUNT OUT NOCOPY NUMBER,
109 X_MSG_DATA OUT NOCOPY VARCHAR2 );
110
111 --to be called from jtf_rs_groups_denorm_pvt.update_groups
112 PROCEDURE DELETE_REP_MGR (
113 P_API_VERSION IN NUMBER,
114 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116 P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
117 P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
118 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
119 X_MSG_COUNT OUT NOCOPY NUMBER,
120 X_MSG_DATA OUT NOCOPY VARCHAR2);
121
122 END JTF_RS_REP_MGR_DENORM_PVT;