APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 6: -- Purpose : Inserts/Update the JTF_RS_REPORTING_MANAGERS table based on changes in jtf_rs_role_relations,

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

Line 14: /*FOR INSERT IN JTF_RS_ROLE_RELATIONS */

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,

Line 20: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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:

Line 25: /*FOR INSERT IN JTF_RS_ROLE_RELATIONS */

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,

Line 32: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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:

Line 43: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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:

Line 56: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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:

Line 66: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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: