APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 6: -- jtf_rs_grp_relations

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
8: -- DATE NAME PURPOSE
9: -- 7 Oct 1999 S Roy Choudhury Created
10: -- 3 Jul 2001 S Roy Choudhury Modified the cursor for selecting members in procedure INSERT_GRP_RELATIONS

Line 3986: /*FOR INSERT IN JTF_RS_GRP_RELATIONS */

3982:
3983: END DELETE_REP_MGR;
3984:
3985:
3986: /*FOR INSERT IN JTF_RS_GRP_RELATIONS */
3987: --not being used now as this id done from group denorm which calls INSERT_GRP_DENORM
3988: PROCEDURE INSERT_GRP_RELATIONS(
3989: P_API_VERSION IN NUMBER,
3990: P_INIT_MSG_LIST IN VARCHAR2,

Line 3992: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

3988: PROCEDURE INSERT_GRP_RELATIONS(
3989: P_API_VERSION IN NUMBER,
3990: P_INIT_MSG_LIST IN VARCHAR2,
3991: P_COMMIT IN VARCHAR2,
3992: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
3993: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3994: X_MSG_COUNT OUT NOCOPY NUMBER,
3995: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3996: IS

Line 3997: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;

3993: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3994: X_MSG_COUNT OUT NOCOPY NUMBER,
3995: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3996: IS
3997: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;
3998: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GRP_RELATIONS';
3999: l_api_version CONSTANT NUMBER :=1.0;
4000: l_date Date;
4001: l_user_id Number;

Line 4011: CURSOR rel_grp_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)

4007: l_start_date_active DATE;
4008: l_end_date_active DATE;
4009:
4010: --cursor for the direct parent
4011: CURSOR rel_grp_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
4012: IS
4013: SELECT related_group_id,
4014: group_id,
4015: start_date_active,

Line 4017: FROM jtf_rs_grp_relations

4013: SELECT related_group_id,
4014: group_id,
4015: start_date_active,
4016: end_date_active
4017: FROM jtf_rs_grp_relations
4018: WHERE group_relate_id = l_group_relate_id
4019: and delete_flag <> 'Y';
4020:
4021: rel_grp_rec rel_grp_cur%rowtype;

Line 4023: l_related_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;

4019: and delete_flag <> 'Y';
4020:
4021: rel_grp_rec rel_grp_cur%rowtype;
4022:
4023: l_related_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
4024:
4025: CURSOR par_mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4026: l_start_date_active DATE,
4027: l_end_date_active DATE)