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 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
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 3973: /*FOR INSERT IN JTF_RS_GRP_RELATIONS */

3969:
3970: END DELETE_REP_MGR;
3971:
3972:
3973: /*FOR INSERT IN JTF_RS_GRP_RELATIONS */
3974: --not being used now as this id done from group denorm which calls INSERT_GRP_DENORM
3975: PROCEDURE INSERT_GRP_RELATIONS(
3976: P_API_VERSION IN NUMBER,
3977: P_INIT_MSG_LIST IN VARCHAR2,

Line 3979: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

3975: PROCEDURE INSERT_GRP_RELATIONS(
3976: P_API_VERSION IN NUMBER,
3977: P_INIT_MSG_LIST IN VARCHAR2,
3978: P_COMMIT IN VARCHAR2,
3979: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
3980: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3981: X_MSG_COUNT OUT NOCOPY NUMBER,
3982: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3983: IS

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

3980: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3981: X_MSG_COUNT OUT NOCOPY NUMBER,
3982: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3983: IS
3984: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;
3985: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GRP_RELATIONS';
3986: l_api_version CONSTANT NUMBER :=1.0;
3987: l_date Date;
3988: l_user_id Number;

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

3994: l_start_date_active DATE;
3995: l_end_date_active DATE;
3996:
3997: --cursor for the direct parent
3998: CURSOR rel_grp_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
3999: IS
4000: SELECT related_group_id,
4001: group_id,
4002: start_date_active,

Line 4004: FROM jtf_rs_grp_relations

4000: SELECT related_group_id,
4001: group_id,
4002: start_date_active,
4003: end_date_active
4004: FROM jtf_rs_grp_relations
4005: WHERE group_relate_id = l_group_relate_id
4006: and delete_flag <> 'Y';
4007:
4008: rel_grp_rec rel_grp_cur%rowtype;

Line 4010: l_related_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;

4006: and delete_flag <> 'Y';
4007:
4008: rel_grp_rec rel_grp_cur%rowtype;
4009:
4010: l_related_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
4011:
4012: CURSOR par_mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4013: l_start_date_active DATE,
4014: l_end_date_active DATE)