APPS.IGS_AD_IMP_003 dependencies on IGS_AD_SPLINT_INT

Line 880: FROM igs_ad_splint_int a

876: AS
877:
878: CURSOR c_spl_intrst IS
879: SELECT rowid,a.*
880: FROM igs_ad_splint_int a
881: WHERE interface_run_id = p_interface_run_id
882: AND status = '2';
883:
884: l_spl_intrst_rec c_spl_intrst%ROWTYPE;

Line 932: UPDATE IGS_AD_SPLINT_INT a

928: END IF;
929:
930: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
931:
932: UPDATE IGS_AD_SPLINT_INT a
933: SET status = '3',
934: error_code = 'E678',
935: error_text = l_error_text1
936: WHERE

Line 964: UPDATE igs_ad_splint_int

960:
961: l_error_text := FND_MESSAGE.GET;
962: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
963:
964: UPDATE igs_ad_splint_int
965: SET status = cst_s_val_3,
966: error_code = cst_ec_val_E701,
967: error_text = NVL(l_error_text,l_error_text1)
968: WHERE rowid = l_spl_intrst_rec.rowid;

Line 997: UPDATE IGS_AD_SPLINT_INT

993: END IF;
994:
995: IF l_type = 'E' THEN
996: ROLLBACK TO spl_intrst_save;
997: UPDATE IGS_AD_SPLINT_INT
998: SET status = cst_s_val_3,
999: error_code = cst_ec_val_E322,
1000: error_text = l_error_text
1001: WHERE rowid = l_spl_intrst_rec.rowid;

Line 1009: UPDATE IGS_AD_SPLINT_INT

1005: END IF;
1006:
1007:
1008: ELSIF l_type = 'S' THEN
1009: UPDATE IGS_AD_SPLINT_INT
1010: SET status = cst_s_val_4,
1011: error_code = cst_ec_val_E702,
1012: error_text = l_error_text
1013: WHERE rowid = l_spl_intrst_rec.rowid;

Line 1020: UPDATE IGS_AD_SPLINT_INT

1016: igs_ad_imp_001.logerrormessage(l_spl_intrst_rec.interface_splint_id,l_msg_data);
1017: END IF;
1018:
1019: ELSIF l_type IS NULL THEN
1020: UPDATE IGS_AD_SPLINT_INT
1021: SET status = cst_s_val_1,
1022: error_code = NULL,
1023: error_text = NULL
1024: WHERE rowid = l_spl_intrst_rec.rowid;

Line 1040: UPDATE igs_ad_splint_int

1036:
1037: l_error_text := FND_MESSAGE.GET;
1038: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1039:
1040: UPDATE igs_ad_splint_int
1041: SET status = cst_s_val_3,
1042: error_code = cst_ec_val_E701,
1043: error_text = NVL(l_error_text,l_error_text1)
1044: WHERE rowid = l_spl_intrst_rec.rowid;

Line 1089: UPDATE IGS_AD_SPLINT_INT

1085: END IF;
1086:
1087: ROLLBACK TO spl_intrst_save;
1088:
1089: UPDATE IGS_AD_SPLINT_INT
1090: SET status = cst_s_val_3,
1091: error_code = l_error_code ,
1092: error_text = l_error_text
1093: WHERE rowid = l_spl_intrst_rec.rowid;