DBA Data[Home] [Help]

APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_GS_ATTRIB_VAL

Line 1178: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,1,0,p_school_code,l_code);

1174:
1175: x_snapshot_id := l_inst_id;
1176:
1177: -- Saving values :p_obj_type_id,p_obj_id p_attrib_id p_version p_value x_return_code.
1178: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,1,0,p_school_code,l_code);
1179: Check_Result(l_code); --Checking the result code
1180:
1181: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,2,0,p_branch_code,l_code);
1182: Check_Result(l_code); --Checking the result code

Line 1181: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,2,0,p_branch_code,l_code);

1177: -- Saving values :p_obj_type_id,p_obj_id p_attrib_id p_version p_value x_return_code.
1178: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,1,0,p_school_code,l_code);
1179: Check_Result(l_code); --Checking the result code
1180:
1181: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,2,0,p_branch_code,l_code);
1182: Check_Result(l_code); --Checking the result code
1183:
1184: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,3,0,p_load_cal_type,l_code);
1185: Check_Result(l_code); --Checking the result code

Line 1184: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,3,0,p_load_cal_type,l_code);

1180:
1181: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,2,0,p_branch_code,l_code);
1182: Check_Result(l_code); --Checking the result code
1183:
1184: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,3,0,p_load_cal_type,l_code);
1185: Check_Result(l_code); --Checking the result code
1186:
1187: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,4,0,p_load_cal_seq,l_code);
1188: Check_Result(l_code); --Checking the result code

Line 1187: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,4,0,p_load_cal_seq,l_code);

1183:
1184: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,3,0,p_load_cal_type,l_code);
1185: Check_Result(l_code); --Checking the result code
1186:
1187: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,4,0,p_load_cal_seq,l_code);
1188: Check_Result(l_code); --Checking the result code
1189:
1190: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,5,0,p_report_flag,l_code);
1191: Check_Result(l_code); --Checking the result code

Line 1190: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,5,0,p_report_flag,l_code);

1186:
1187: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,4,0,p_load_cal_seq,l_code);
1188: Check_Result(l_code); --Checking the result code
1189:
1190: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,5,0,p_report_flag,l_code);
1191: Check_Result(l_code); --Checking the result code
1192:
1193: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,6,0,to_char(sysdate,'YYYYMMDD'),l_code);
1194: Check_Result(l_code); --Checking the result code

Line 1193: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,6,0,to_char(sysdate,'YYYYMMDD'),l_code);

1189:
1190: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,5,0,p_report_flag,l_code);
1191: Check_Result(l_code); --Checking the result code
1192:
1193: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,6,0,to_char(sysdate,'YYYYMMDD'),l_code);
1194: Check_Result(l_code); --Checking the result code
1195:
1196: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,7,0,p_prev_snapshot_id,l_code);
1197: Check_Result(l_code); --Checking the result code

Line 1196: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,7,0,p_prev_snapshot_id,l_code);

1192:
1193: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,6,0,to_char(sysdate,'YYYYMMDD'),l_code);
1194: Check_Result(l_code); --Checking the result code
1195:
1196: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,l_inst_id,7,0,p_prev_snapshot_id,l_code);
1197: Check_Result(l_code); --Checking the result code
1198:
1199: END Create_Header_Record;
1200:

Line 1217: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,l_cur_count,0,g_counts(l_cur_count),l_code);

1213: g_counts(18):=0;
1214: --Making loop through attributes to get counts for the trailer record
1215: FOR l_cur_count IN 10..17 LOOP
1216: --Store value in the EDS
1217: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,l_cur_count,0,g_counts(l_cur_count),l_code);
1218: Check_Result(l_code); --Checking the result code
1219: g_counts(18):=g_counts(18)+g_counts(l_cur_count);
1220: END LOOP;
1221:

Line 1222: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,18,0,g_counts(18),l_code);

1218: Check_Result(l_code); --Checking the result code
1219: g_counts(18):=g_counts(18)+g_counts(l_cur_count);
1220: END LOOP;
1221:
1222: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,18,0,g_counts(18),l_code);
1223: Check_Result(l_code); --Checking the result code
1224:
1225: END Create_Trailer_Record;
1226:

Line 1240: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,20,p_student_data.student_id,p_student_data.ssn,l_code);

1236: l_code VARCHAR2(3);
1237:
1238: BEGIN
1239: --Saving value;
1240: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,20,p_student_data.student_id,p_student_data.ssn,l_code);
1241: Check_Result(l_code); --Checking the result code
1242:
1243: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,21,p_student_data.student_id,p_student_data.f_name,l_code);
1244: Check_Result(l_code); --Checking the result code

Line 1243: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,21,p_student_data.student_id,p_student_data.f_name,l_code);

1239: --Saving value;
1240: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,20,p_student_data.student_id,p_student_data.ssn,l_code);
1241: Check_Result(l_code); --Checking the result code
1242:
1243: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,21,p_student_data.student_id,p_student_data.f_name,l_code);
1244: Check_Result(l_code); --Checking the result code
1245:
1246: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,22,p_student_data.student_id,p_student_data.m_name,l_code);
1247: Check_Result(l_code); --Checking the result code

Line 1246: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,22,p_student_data.student_id,p_student_data.m_name,l_code);

1242:
1243: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,21,p_student_data.student_id,p_student_data.f_name,l_code);
1244: Check_Result(l_code); --Checking the result code
1245:
1246: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,22,p_student_data.student_id,p_student_data.m_name,l_code);
1247: Check_Result(l_code); --Checking the result code
1248:
1249: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,23,p_student_data.student_id,p_student_data.l_name,l_code);
1250: Check_Result(l_code); --Checking the result code

Line 1249: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,23,p_student_data.student_id,p_student_data.l_name,l_code);

1245:
1246: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,22,p_student_data.student_id,p_student_data.m_name,l_code);
1247: Check_Result(l_code); --Checking the result code
1248:
1249: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,23,p_student_data.student_id,p_student_data.l_name,l_code);
1250: Check_Result(l_code); --Checking the result code
1251:
1252: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,24,p_student_data.student_id,p_student_data.suffix,l_code);
1253: Check_Result(l_code); --Checking the result code

Line 1252: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,24,p_student_data.student_id,p_student_data.suffix,l_code);

1248:
1249: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,23,p_student_data.student_id,p_student_data.l_name,l_code);
1250: Check_Result(l_code); --Checking the result code
1251:
1252: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,24,p_student_data.student_id,p_student_data.suffix,l_code);
1253: Check_Result(l_code); --Checking the result code
1254:
1255: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,25,p_student_data.student_id,p_student_data.prev_ssn,l_code);
1256: Check_Result(l_code); --Checking the result code

Line 1255: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,25,p_student_data.student_id,p_student_data.prev_ssn,l_code);

1251:
1252: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,24,p_student_data.student_id,p_student_data.suffix,l_code);
1253: Check_Result(l_code); --Checking the result code
1254:
1255: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,25,p_student_data.student_id,p_student_data.prev_ssn,l_code);
1256: Check_Result(l_code); --Checking the result code
1257:
1258: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,26,p_student_data.student_id,p_student_data.prev_l_name,l_code);
1259: Check_Result(l_code); --Checking the result code

Line 1258: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,26,p_student_data.student_id,p_student_data.prev_l_name,l_code);

1254:
1255: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,25,p_student_data.student_id,p_student_data.prev_ssn,l_code);
1256: Check_Result(l_code); --Checking the result code
1257:
1258: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,26,p_student_data.student_id,p_student_data.prev_l_name,l_code);
1259: Check_Result(l_code); --Checking the result code
1260:
1261: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,27,p_student_data.student_id,p_student_data.enr_status,l_code);
1262: Check_Result(l_code); --Checking the result code

Line 1261: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,27,p_student_data.student_id,p_student_data.enr_status,l_code);

1257:
1258: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,26,p_student_data.student_id,p_student_data.prev_l_name,l_code);
1259: Check_Result(l_code); --Checking the result code
1260:
1261: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,27,p_student_data.student_id,p_student_data.enr_status,l_code);
1262: Check_Result(l_code); --Checking the result code
1263:
1264: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,28,p_student_data.student_id,to_char(p_student_data.status_date,'YYYYMMDD'),l_code);
1265: Check_Result(l_code); --Checking the result code

Line 1264: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,28,p_student_data.student_id,to_char(p_student_data.status_date,'YYYYMMDD'),l_code);

1260:
1261: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,27,p_student_data.student_id,p_student_data.enr_status,l_code);
1262: Check_Result(l_code); --Checking the result code
1263:
1264: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,28,p_student_data.student_id,to_char(p_student_data.status_date,'YYYYMMDD'),l_code);
1265: Check_Result(l_code); --Checking the result code
1266:
1267: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,29,p_student_data.student_id,p_student_data.addr1,l_code);
1268: Check_Result(l_code); --Checking the result code

Line 1267: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,29,p_student_data.student_id,p_student_data.addr1,l_code);

1263:
1264: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,28,p_student_data.student_id,to_char(p_student_data.status_date,'YYYYMMDD'),l_code);
1265: Check_Result(l_code); --Checking the result code
1266:
1267: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,29,p_student_data.student_id,p_student_data.addr1,l_code);
1268: Check_Result(l_code); --Checking the result code
1269:
1270: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,30,p_student_data.student_id,p_student_data.addr2,l_code);
1271: Check_Result(l_code); --Checking the result code

Line 1270: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,30,p_student_data.student_id,p_student_data.addr2,l_code);

1266:
1267: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,29,p_student_data.student_id,p_student_data.addr1,l_code);
1268: Check_Result(l_code); --Checking the result code
1269:
1270: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,30,p_student_data.student_id,p_student_data.addr2,l_code);
1271: Check_Result(l_code); --Checking the result code
1272:
1273: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,31,p_student_data.student_id,p_student_data.city,l_code);
1274: Check_Result(l_code); --Checking the result code

Line 1273: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,31,p_student_data.student_id,p_student_data.city,l_code);

1269:
1270: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,30,p_student_data.student_id,p_student_data.addr2,l_code);
1271: Check_Result(l_code); --Checking the result code
1272:
1273: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,31,p_student_data.student_id,p_student_data.city,l_code);
1274: Check_Result(l_code); --Checking the result code
1275:
1276: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,32,p_student_data.student_id,p_student_data.state,l_code);
1277: Check_Result(l_code); --Checking the result code

Line 1276: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,32,p_student_data.student_id,p_student_data.state,l_code);

1272:
1273: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,31,p_student_data.student_id,p_student_data.city,l_code);
1274: Check_Result(l_code); --Checking the result code
1275:
1276: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,32,p_student_data.student_id,p_student_data.state,l_code);
1277: Check_Result(l_code); --Checking the result code
1278:
1279: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,33,p_student_data.student_id,p_student_data.zip,l_code);
1280: Check_Result(l_code); --Checking the result code

Line 1279: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,33,p_student_data.student_id,p_student_data.zip,l_code);

1275:
1276: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,32,p_student_data.student_id,p_student_data.state,l_code);
1277: Check_Result(l_code); --Checking the result code
1278:
1279: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,33,p_student_data.student_id,p_student_data.zip,l_code);
1280: Check_Result(l_code); --Checking the result code
1281:
1282: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,34,p_student_data.student_id,p_student_data.country,l_code);
1283: Check_Result(l_code); --Checking the result code

Line 1282: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,34,p_student_data.student_id,p_student_data.country,l_code);

1278:
1279: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,33,p_student_data.student_id,p_student_data.zip,l_code);
1280: Check_Result(l_code); --Checking the result code
1281:
1282: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,34,p_student_data.student_id,p_student_data.country,l_code);
1283: Check_Result(l_code); --Checking the result code
1284:
1285: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,35,p_student_data.student_id,to_char(p_student_data.grad_date,'YYYYMMDD'),l_code);
1286: Check_Result(l_code); --Checking the result code

Line 1285: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,35,p_student_data.student_id,to_char(p_student_data.grad_date,'YYYYMMDD'),l_code);

1281:
1282: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,34,p_student_data.student_id,p_student_data.country,l_code);
1283: Check_Result(l_code); --Checking the result code
1284:
1285: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,35,p_student_data.student_id,to_char(p_student_data.grad_date,'YYYYMMDD'),l_code);
1286: Check_Result(l_code); --Checking the result code
1287:
1288: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,36,p_student_data.student_id,to_char(p_student_data.birth_date,'YYYYMMDD'),l_code);
1289: Check_Result(l_code); --Checking the result code

Line 1288: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,36,p_student_data.student_id,to_char(p_student_data.birth_date,'YYYYMMDD'),l_code);

1284:
1285: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,35,p_student_data.student_id,to_char(p_student_data.grad_date,'YYYYMMDD'),l_code);
1286: Check_Result(l_code); --Checking the result code
1287:
1288: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,36,p_student_data.student_id,to_char(p_student_data.birth_date,'YYYYMMDD'),l_code);
1289: Check_Result(l_code); --Checking the result code
1290:
1291: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,37,p_student_data.student_id,to_char(p_student_data.term_s_date,'YYYYMMDD'),l_code);
1292: Check_Result(l_code); --Checking the result code

Line 1291: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,37,p_student_data.student_id,to_char(p_student_data.term_s_date,'YYYYMMDD'),l_code);

1287:
1288: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,36,p_student_data.student_id,to_char(p_student_data.birth_date,'YYYYMMDD'),l_code);
1289: Check_Result(l_code); --Checking the result code
1290:
1291: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,37,p_student_data.student_id,to_char(p_student_data.term_s_date,'YYYYMMDD'),l_code);
1292: Check_Result(l_code); --Checking the result code
1293:
1294: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,38,p_student_data.student_id,to_char(p_student_data.term_e_date,'YYYYMMDD'),l_code);
1295: Check_Result(l_code); --Checking the result code

Line 1294: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,38,p_student_data.student_id,to_char(p_student_data.term_e_date,'YYYYMMDD'),l_code);

1290:
1291: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,37,p_student_data.student_id,to_char(p_student_data.term_s_date,'YYYYMMDD'),l_code);
1292: Check_Result(l_code); --Checking the result code
1293:
1294: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,38,p_student_data.student_id,to_char(p_student_data.term_e_date,'YYYYMMDD'),l_code);
1295: Check_Result(l_code); --Checking the result code
1296:
1297: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,39,p_student_data.student_id,p_student_data.grad_level,l_code);
1298: Check_Result(l_code); --Checking the result code

Line 1297: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,39,p_student_data.student_id,p_student_data.grad_level,l_code);

1293:
1294: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,38,p_student_data.student_id,to_char(p_student_data.term_e_date,'YYYYMMDD'),l_code);
1295: Check_Result(l_code); --Checking the result code
1296:
1297: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,39,p_student_data.student_id,p_student_data.grad_level,l_code);
1298: Check_Result(l_code); --Checking the result code
1299:
1300: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,40,p_student_data.student_id,p_student_data.data_block,l_code);
1301: Check_Result(l_code); --Checking the result code

Line 1300: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,40,p_student_data.student_id,p_student_data.data_block,l_code);

1296:
1297: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,39,p_student_data.student_id,p_student_data.grad_level,l_code);
1298: Check_Result(l_code); --Checking the result code
1299:
1300: IGS_EN_GS_ATTRIB_VAL.SET_VALUE(1,p_snapshot_id,40,p_student_data.student_id,p_student_data.data_block,l_code);
1301: Check_Result(l_code); --Checking the result code
1302:
1303: END Save_Student_Record;
1304:

Line 1601: l_prev_stat := IGS_EN_GS_ATTRIB_VAL.GET_VALUE(1,p_prev_snapshot_id,27,p_student_data.student_id);

1597: -- if falling below full time then derive status change date based on previous snapshot value
1598: IF p_prev_snapshot_id IS NOT NULL AND p_student_data.enr_status IN ('L','H') THEN
1599:
1600: --Get previous status if current is H or L and snapshot is provided.
1601: l_prev_stat := IGS_EN_GS_ATTRIB_VAL.GET_VALUE(1,p_prev_snapshot_id,27,p_student_data.student_id);
1602:
1603: -- Get status_date (if reqiured)
1604: IF (g_debug_mode) THEN
1605: Put_Debug_Msg('| Previous enrollemt status found: '||l_prev_stat);