APPS.IGS_AD_IMP_003 dependencies on IGS_AD_SPLTAL_INT

Line 1119: FROM igs_ad_spltal_int a

1115: AS
1116:
1117: CURSOR c_spl_tal IS
1118: SELECT rowid,a.*
1119: FROM igs_ad_spltal_int a
1120: WHERE interface_run_id = p_interface_run_id
1121: AND status = '2';
1122:
1123: l_spl_tal_rec c_spl_tal%ROWTYPE;

Line 1170: UPDATE IGS_AD_SPLTAL_INT a

1166: END IF;
1167:
1168: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
1169:
1170: UPDATE IGS_AD_SPLTAL_INT a
1171: SET status = '3',
1172: error_code = 'E678',
1173: error_text = l_error_text1
1174: WHERE

Line 1202: UPDATE igs_ad_spltal_int

1198:
1199: l_error_text := FND_MESSAGE.GET;
1200: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1201:
1202: UPDATE igs_ad_spltal_int
1203: SET status = cst_s_val_3,
1204: error_code = cst_ec_val_E701,
1205: error_text = NVL(l_error_text,l_error_text1)
1206: WHERE rowid = l_spl_tal_rec.rowid;

Line 1234: UPDATE IGS_AD_SPLTAL_INT

1230: END IF;
1231:
1232: IF l_type = 'E' THEN
1233: ROLLBACK TO spl_tal_save;
1234: UPDATE IGS_AD_SPLTAL_INT
1235: SET status = cst_s_val_3,
1236: error_code = cst_ec_val_E322,
1237: error_text = l_error_text
1238: WHERE rowid = l_spl_tal_rec.rowid;

Line 1246: UPDATE IGS_AD_SPLTAL_INT

1242: END IF;
1243:
1244:
1245: ELSIF l_type = 'S' THEN
1246: UPDATE IGS_AD_SPLTAL_INT
1247: SET status = cst_s_val_4,
1248: error_code = cst_ec_val_E702,
1249: error_text = l_error_text
1250: WHERE rowid = l_SPL_TAL_REC.rowid;

Line 1257: UPDATE igs_ad_spltal_int

1253: igs_ad_imp_001.logerrormessage(l_spl_tal_rec.interface_spltal_id,l_msg_data);
1254: END IF;
1255:
1256: ELSIF l_type IS NULL THEN
1257: UPDATE igs_ad_spltal_int
1258: SET status = cst_s_val_1,
1259: error_code = NULL,
1260: error_text = NULL
1261: WHERE rowid = l_spl_tal_rec.rowid;

Line 1275: UPDATE igs_ad_spltal_int

1271:
1272: l_error_text := FND_MESSAGE.GET;
1273: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1274:
1275: UPDATE igs_ad_spltal_int
1276: SET status = cst_s_val_3,
1277: error_code = cst_ec_val_E701,
1278: error_text = NVL(l_error_text,l_error_text1)
1279: WHERE rowid = l_spl_tal_rec.rowid;

Line 1325: UPDATE IGS_AD_SPLTAL_INT

1321: END IF;
1322:
1323: ROLLBACK TO spl_tal_save;
1324:
1325: UPDATE IGS_AD_SPLTAL_INT
1326: SET status = cst_s_val_3,
1327: error_code = l_error_code ,
1328: error_text = l_error_text
1329: WHERE rowid = l_spl_tal_rec.rowid;