APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on JTF_RS_REP_MGR_DENORM_PVT

Line 1: PACKAGE BODY JTF_RS_REP_MGR_DENORM_PVT AS

1: PACKAGE BODY JTF_RS_REP_MGR_DENORM_PVT AS
2: /* $Header: jtfrsvpb.pls 120.0.12010000.2 2009/02/17 06:36:08 rgokavar ship $ */
3: -- API Name : JTF_RS_REP_MGR_DENORM_PVT
4: -- Type : Private
5: -- Purpose : Inserts/Update the JTF_RS_REPORTING_MANAGERS table based on changes in jtf_rs_role_relations,

Line 3: -- API Name : JTF_RS_REP_MGR_DENORM_PVT

1: PACKAGE BODY JTF_RS_REP_MGR_DENORM_PVT AS
2: /* $Header: jtfrsvpb.pls 120.0.12010000.2 2009/02/17 06:36:08 rgokavar ship $ */
3: -- API Name : JTF_RS_REP_MGR_DENORM_PVT
4: -- Type : Private
5: -- Purpose : Inserts/Update the JTF_RS_REPORTING_MANAGERS table based on changes in jtf_rs_role_relations,
6: -- jtf_rs_grp_relations
7: -- Modification History

Line 17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_REP_MGR_DENORM_PVT';

13: -- 5 Feb 2009 Sudhir Gokavarapu Bug8261683 : Modified Deletion logic in procedure UPDATE_REP_MANAGER.
14: -- Notes:
15: --
16:
17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_REP_MGR_DENORM_PVT';
18:
19: /*FOR INSERT IN JTF_RS_ROLE_RELATIONS */
20: PROCEDURE INSERT_REP_MANAGER(
21: P_API_VERSION IN NUMBER,

Line 2643: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(

2639: THEN
2640: COMMIT WORK;
2641: END IF;
2642: --call the insert api for the role relate id
2643: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(
2644: P_API_VERSION => 1.0,
2645: P_INIT_MSG_LIST => p_init_msg_list,
2646: P_COMMIT => l_pass_commit,
2647: P_ROLE_RELATE_ID => l_role_relate_id ,

Line 2954: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(

2950: END IF;
2951:
2952: --recreate the rep manager records for the child role relate id
2953:
2954: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(
2955: P_API_VERSION => 1.0,
2956: P_INIT_MSG_LIST => p_init_msg_list,
2957: P_COMMIT => l_pass_commit,
2958: P_ROLE_RELATE_ID => child_role_relate_rec.role_relate_id,

Line 2968: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(

2964: CLOSE child_role_relate_cur;
2965:
2966: --recreate the rep manager records for the parent role relate id
2967:
2968: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(
2969: P_API_VERSION => 1.0,
2970: P_INIT_MSG_LIST => p_init_msg_list,
2971: P_COMMIT => l_pass_commit,
2972: P_ROLE_RELATE_ID => par_role_relate_rec.role_relate_id,

Line 4820: END JTF_RS_REP_MGR_DENORM_PVT;

4816: FND_MSG_PUB.add;
4817: x_return_status := fnd_api.g_ret_sts_unexp_error;
4818: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4819: END INSERT_GRP_RELATIONS;
4820: END JTF_RS_REP_MGR_DENORM_PVT;