APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on IGS_AD_OFFRESP_BATCH

Line 54: CURSOR batch_details(l_batch_id igs_ad_offresp_batch.batch_id%TYPE) IS

50: FROM igs_lookups_view
51: WHERE lookup_type = 'IMPORT_ERROR_CODE' AND
52: lookup_code = l_code;
53:
54: CURSOR batch_details(l_batch_id igs_ad_offresp_batch.batch_id%TYPE) IS
55: SELECT batch_id, batch_desc
56: FROM igs_ad_offresp_batch
57: WHERE batch_id = l_batch_id;
58: l_batch_rec batch_details%ROWTYPE;

Line 56: FROM igs_ad_offresp_batch

52: lookup_code = l_code;
53:
54: CURSOR batch_details(l_batch_id igs_ad_offresp_batch.batch_id%TYPE) IS
55: SELECT batch_id, batch_desc
56: FROM igs_ad_offresp_batch
57: WHERE batch_id = l_batch_id;
58: l_batch_rec batch_details%ROWTYPE;
59:
60: BEGIN

Line 861: p_batch_id IN igs_ad_offresp_batch.batch_id%TYPE,

857: END validate_off_resp_dtls;
858:
859: PROCEDURE imp_off_resp( errbuf OUT NOCOPY VARCHAR2,
860: retcode OUT NOCOPY NUMBER,
861: p_batch_id IN igs_ad_offresp_batch.batch_id%TYPE,
862: p_yes_no IN VARCHAR2)
863: AS
864: ---------------------------------------------------------------------------------------------------------------------------------------
865: -- Created By : rboddu

Line 876: -- 6. If All the interface records for the given batch_id are succesfully imported then delete the Batch record from IGS_AD_OFFRESP_BATCH.

872: -- 3. If validations Successful then Update the OSS table IGS_AD_PS_APPL_INST_ALL with Interface Offer Response details.
873: -- 4. If the Offer Response status of Application Instance is updated to 'ACCEPTED' then perform the Pre enrollment by calling
874: -- the corresponding job.
875: -- 5. If the record is succesfully imported then Delete the interface record from IGS_AD_OFFRESP_INT.
876: -- 6. If All the interface records for the given batch_id are succesfully imported then delete the Batch record from IGS_AD_OFFRESP_BATCH.
877: -- 7. Once all the pending records are processed then invoke the Import Offer Response Error Rerport (IGSADS21).
878: -- Know limitations, enhancements or remarks
879: -- Change History
880: -- Who When What

Line 964: CURSOR c_processed_recs(p_batch_id igs_ad_offresp_batch.batch_id%TYPE) IS

960: WHERE person_id = cp_person_id AND
961: admission_appl_number = cp_admission_appl_number;
962:
963: --Cursor to check if there is any Pending or Error interface Offer Response record is present in IGS_AD_OFFRESP_INT;
964: CURSOR c_processed_recs(p_batch_id igs_ad_offresp_batch.batch_id%TYPE) IS
965: SELECT offresp_int_id
966: FROM igs_ad_offresp_int
967: WHERE batch_id = p_batch_id AND
968: status IN ('2','3');

Line 1024: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_BATCH', cascade => TRUE);

1020: -- by rrengara on 20-jan-2003 bug 2711176
1021:
1022: BEGIN
1023: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
1024: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_BATCH', cascade => TRUE);
1025: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_INT', cascade => TRUE);
1026: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_ERR', cascade => TRUE);
1027: EXCEPTION WHEN OTHERS THEN
1028: NULL;

Line 1382: DELETE igs_ad_offresp_batch where batch_id = p_batch_id;

1378: -- Check if all the interface records have successfully been imported. In this case delete the batch record from interface batch table.
1379: OPEN c_processed_recs(p_batch_id);
1380: FETCH c_processed_recs INTO l_offresp_id;
1381: IF c_processed_recs%NOTFOUND THEN
1382: DELETE igs_ad_offresp_batch where batch_id = p_batch_id;
1383: END IF;
1384: CLOSE c_processed_recs;
1385:
1386: IF l_tot_rec_processed > 0 THEN -- Commit the records not yet committed above