26: X_MSG_DATA OUT NOCOPY VARCHAR2 )
27: IS
28: CURSOR rep_mgr_seq_cur
29: IS
30: SELECT jtf_rs_rep_managers_s.nextval
31: FROM dual;
32:
33:
34: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1156: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1157: IS
1158: CURSOR rep_mgr_seq_cur
1159: IS
1160: SELECT jtf_rs_rep_managers_s.nextval
1161: FROM dual;
1162:
1163:
1164: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
3012: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3013: IS
3014: CURSOR rep_mgr_seq_cur
3015: IS
3016: SELECT jtf_rs_rep_managers_s.nextval
3017: FROM dual;
3018:
3019:
3020: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
3596: IF l_start_date_active > l_end_date_active THEN
3597: RAISE skip_row;
3598: END IF;
3599:
3600: SELECT jtf_rs_rep_managers_s.nextval
3601: INTO l_denorm_manager_id
3602: FROM dual;
3603:
3604: /* to_char(l_process_table(k).PERSON_ID)||'..'||
4147: member_rec member_cur%rowtype;
4148:
4149: CURSOR rep_mgr_seq_cur
4150: IS
4151: SELECT jtf_rs_rep_managers_s.nextval
4152: FROM dual;
4153:
4154: --dupliacte check cursor to be added
4155: