APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_UC_QUAL_DETS_PKG

Line 22: ayedubat 07-MAR-03 For the Bug,2824978 the column x_imported_date in Igs_uc_qual_dets_pkg.insert_row

18: smaddali Modified cursor cur_del_rec to delete the unique record being inserted ,
19: identified by unique key fields for bug 2450449 , also modified call to htis cursor
20: bayadav 08-JAN-03 Modified Cur_person_id cursor to cehck for EBL_AMMENDED_RESULT first then EBL_RESULT
21: while fetching value for approved result
22: ayedubat 07-MAR-03 For the Bug,2824978 the column x_imported_date in Igs_uc_qual_dets_pkg.insert_row
23: call is populated with SYSDATE.
24: For the Bug, 2825034 the existing qualifications are deleted first and importing all
25: the qualifications in the UCAS Interface table again.
26: For the Bug, 2825118 a validation is added to check the parent existence of the

Line 284: igs_uc_qual_dets_pkg.delete_row( x_rowid => cur_del_qual_dets_rec.ROWID );

280: END IF;
281:
282: ELSE
283: --Delete the existing imported Qualification when advanced standing details doesn't exists.
284: igs_uc_qual_dets_pkg.delete_row( x_rowid => cur_del_qual_dets_rec.ROWID );
285: l_records_deleted := l_records_deleted + 1;
286: END IF;
287:
288: END LOOP ;

Line 409: igs_uc_qual_dets_pkg.Update_row ( x_mode => 'R',

405: l_records_errored := NVL(l_records_errored ,0) + 1 ;
406:
407: ELSE
408:
409: igs_uc_qual_dets_pkg.Update_row ( x_mode => 'R',
410: x_rowid => Cur_qual_dets_val.ROWID,
411: x_Qual_dets_id => Cur_qual_dets_val.Qual_dets_id,
412: x_Person_id => Cur_qual_dets_val.person_id,
413: x_Exam_level => Cur_qual_dets_val.Exam_level,

Line 505: Igs_uc_qual_dets_pkg.Insert_row ( x_mode => 'R',

501:
502: IF l_validation_status = TRUE THEN
503:
504: /* Inserting record in to igs_uc_qual_dets table thru TBH */
505: Igs_uc_qual_dets_pkg.Insert_row ( x_mode => 'R',
506: x_rowid => l_rowid,
507: x_Qual_dets_id => l_Qual_dets_id,
508: x_Person_id => J.person_id,
509: x_Exam_level => l_oss_exam_level,