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 2005/05/11 08:23:12 appldev 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 2005/05/11 08:23:12 appldev 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 16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_REP_MGR_DENORM_PVT';

12: -- hierarchy type.
13: -- Notes:
14: --
15:
16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_REP_MGR_DENORM_PVT';
17:
18: /*FOR INSERT IN JTF_RS_ROLE_RELATIONS */
19: PROCEDURE INSERT_REP_MANAGER(
20: P_API_VERSION IN NUMBER,

Line 2630: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(

2626: END LOOP; --end of denorm cur loop
2627:
2628:
2629: --call the insert api for the role relate id
2630: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(
2631: P_API_VERSION => 1.0,
2632: P_INIT_MSG_LIST => p_init_msg_list,
2633: P_COMMIT => l_pass_commit,
2634: P_ROLE_RELATE_ID => l_role_relate_id ,

Line 2941: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(

2937: END IF;
2938:
2939: --recreate the rep manager records for the child role relate id
2940:
2941: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(
2942: P_API_VERSION => 1.0,
2943: P_INIT_MSG_LIST => p_init_msg_list,
2944: P_COMMIT => l_pass_commit,
2945: P_ROLE_RELATE_ID => child_role_relate_rec.role_relate_id,

Line 2955: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(

2951: CLOSE child_role_relate_cur;
2952:
2953: --recreate the rep manager records for the parent role relate id
2954:
2955: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER(
2956: P_API_VERSION => 1.0,
2957: P_INIT_MSG_LIST => p_init_msg_list,
2958: P_COMMIT => l_pass_commit,
2959: P_ROLE_RELATE_ID => par_role_relate_rec.role_relate_id,

Line 4807: END JTF_RS_REP_MGR_DENORM_PVT;

4803: FND_MSG_PUB.add;
4804: x_return_status := fnd_api.g_ret_sts_unexp_error;
4805: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4806: END INSERT_GRP_RELATIONS;
4807: END JTF_RS_REP_MGR_DENORM_PVT;