APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_IMP_BATCH_DET

Line 452: l_Batch_Id igs_ad_imp_batch_det.batch_id%type;

448: AND STATISTIC_TYPE = 'HIGH_SCHOOL'
449: AND (COURSE_STATUS IN ('1','2') OR COURSE_STATUS IS NULL); -- exam taken(1) or Planned(2) or Numeric Grades
450:
451:
452: l_Batch_Id igs_ad_imp_batch_det.batch_id%type;
453: l_Batch_Desc igs_ad_imp_batch_det.batch_desc%type;
454: l_interface_id igs_ad_interface_all.interface_id%type;
455: l_interface_addr_id igs_ad_addr_int_all.interface_addr_id%type;
456: l_interface_test_id igs_ad_test_int.interface_test_id%type;

Line 453: l_Batch_Desc igs_ad_imp_batch_det.batch_desc%type;

449: AND (COURSE_STATUS IN ('1','2') OR COURSE_STATUS IS NULL); -- exam taken(1) or Planned(2) or Numeric Grades
450:
451:
452: l_Batch_Id igs_ad_imp_batch_det.batch_id%type;
453: l_Batch_Desc igs_ad_imp_batch_det.batch_desc%type;
454: l_interface_id igs_ad_interface_all.interface_id%type;
455: l_interface_addr_id igs_ad_addr_int_all.interface_addr_id%type;
456: l_interface_test_id igs_ad_test_int.interface_test_id%type;
457: l_admission_test_type igs_ad_test_int.admission_test_type%type;

Line 503: -- Insert the Batch_id in to the Batch Table IGS_AD_IMP_BATCH_DET for Import Process

499: errbuf := 'INVALID SETUP';
500: retcode := 0;
501: RETURN;
502: END IF;
503: -- Insert the Batch_id in to the Batch Table IGS_AD_IMP_BATCH_DET for Import Process
504:
505:
506: l_Batch_Desc := 'Import ACT Assessment Details :'||to_char(sysdate,'MM-DD-YY HH24:MI:SS');
507: INSERT

Line 508: INTO IGS_AD_IMP_BATCH_DET

504:
505:
506: l_Batch_Desc := 'Import ACT Assessment Details :'||to_char(sysdate,'MM-DD-YY HH24:MI:SS');
507: INSERT
508: INTO IGS_AD_IMP_BATCH_DET
509: (
510: BATCH_ID ,
511: BATCH_DESC ,
512: CREATED_BY ,