73: g_alt_code VARCHAR2(80);
74: g_header VARCHAR2(1000);
75: g_header_written VARCHAR2(1) DEFAULT 'N';
76: g_trans_type VARCHAR2(1);
77: g_persid_grp igs_pe_persid_group_all.group_id%TYPE;
78:
79: -- Main Cursor to pick up RFMS Records
80: -- for preparing Origination File
81:
1173: l_msg_str_5 VARCHAR2(1000);
1174: l_msg_str_6 VARCHAR2(1000);
1175: -- Get person id group name
1176: CURSOR c_pers_id_grp_name(
1177: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE
1178: ) IS
1179: SELECT group_cd group_name
1180: FROM igs_pe_persid_group_all
1181: WHERE group_id = cp_persid_grp;
1176: CURSOR c_pers_id_grp_name(
1177: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE
1178: ) IS
1179: SELECT group_cd group_name
1180: FROM igs_pe_persid_group_all
1181: WHERE group_id = cp_persid_grp;
1182: l_pers_id_grp_name c_pers_id_grp_name%ROWTYPE;
1183:
1184: l_error NUMBER;