24: P_COMMIT IN VARCHAR2,
25: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
27: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
67:
68: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_group_id;
69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;
70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;
73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
74: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
75:
77:
78: --CHECK THIS CURSOR FOR VALIDITY OF DATES
79:
80: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE,
81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
83: IS
84: SELECT 'X'
85: FROM jtf_rs_grp_relations rel
78: --CHECK THIS CURSOR FOR VALIDITY OF DATES
79:
80: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE,
81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
83: IS
84: SELECT 'X'
85: FROM jtf_rs_grp_relations rel
86: WHERE rel.group_id = l_group_id
103:
104: check_overlap_rec check_overlap_cur%ROWTYPE;
105:
106: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
109: IS
110: SELECT 'X'
111: FROM jtf_rs_groups_b grp
104: check_overlap_rec check_overlap_cur%ROWTYPE;
105:
106: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
109: IS
110: SELECT 'X'
111: FROM jtf_rs_groups_b grp
112: WHERE grp.group_id = l_group_id
170:
171:
172: CURSOR seq_cur
173: IS
174: SELECT jtf_rs_grp_relations_s.nextval
175: FROM dual;
176:
177:
178: CURSOR parent_count_cur(l_group_id number)
805: (P_API_VERSION IN NUMBER,
806: P_INIT_MSG_LIST IN VARCHAR2,
807: P_COMMIT IN VARCHAR2,
808: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
809: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
810: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
811: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
812: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
813: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
849:
850: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;
852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;
911:
912:
913:
914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS
919: SELECT 'X'
912:
913:
914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS
919: SELECT 'X'
920: FROM jtf_rs_grp_relations rel
934:
935: check_overlap_rec check_overlap_cur%ROWTYPE;
936:
937: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
940: IS
941: SELECT 'X'
942: FROM jtf_rs_groups_b grp
935: check_overlap_rec check_overlap_cur%ROWTYPE;
936:
937: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
940: IS
941: SELECT 'X'
942: FROM jtf_rs_groups_b grp
943: WHERE grp.group_id = l_group_id