APPS.IGS_AD_IMP_015 dependencies on IGS_AD_TXCPT_INT

Line 367: UPDATE igs_ad_txcpt_int a

363: AND error_code = 'E347'
364: AND status = '4';
365:
366: -- Populating the interface table with the interface_run_id value
367: UPDATE igs_ad_txcpt_int a
368: SET interface_run_id = p_interface_run_id,
369: (person_id,education_id)
370: = (SELECT person_id,NVL(education_id,update_education_id)
371: FROM igs_ad_acadhis_int_all

Line 380: UPDATE igs_ad_txcpt_int

376: AND status IN ('1','4'));
377:
378: -- If record failed only due to child record failure
379: -- then set status back to 1 and nullify error code/text
380: UPDATE igs_ad_txcpt_int
381: SET error_code = NULL,
382: error_text = NULL,
383: status = '1'
384: WHERE interface_run_id = p_interface_run_id

Line 390: tabname => 'IGS_AD_TXCPT_INT',

386: AND status = '4';
387:
388: -- Gather statistics of the table
389: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
390: tabname => 'IGS_AD_TXCPT_INT',
391: cascade => TRUE);
392:
393: -- Call category entity import procedure
394: igs_ad_imp_024.prc_trscrpt (p_interface_run_id => p_interface_run_id,

Line 936: l_category_entity_ad_table(10).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(10).entity_name := 'IGS_AD_TXCPT_INT';

932: l_category_entity_ad_table(06).category_name := 'INQUIRY_INFORMATION_TYPES'; l_category_entity_ad_table(06).entity_name := 'IGR_I_INFO_INT';
933: l_category_entity_ad_table(07).category_name := 'INQUIRY_CHARACTERISTICS'; l_category_entity_ad_table(07).entity_name := 'IGR_I_CHAR_INT';
934: l_category_entity_ad_table(08).category_name := 'TEST_RESULTS'; l_category_entity_ad_table(08).entity_name := 'IGS_AD_TEST_INT';
935: l_category_entity_ad_table(09).category_name := 'TEST_RESULTS'; l_category_entity_ad_table(09).entity_name := 'IGS_AD_TEST_SEGS_INT';
936: l_category_entity_ad_table(10).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(10).entity_name := 'IGS_AD_TXCPT_INT';
937: l_category_entity_ad_table(11).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(11).entity_name := 'IGS_AD_TRMDT_INT';
938: l_category_entity_ad_table(12).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(12).entity_name := 'IGS_AD_TUNDT_INT';
939: l_category_entity_ad_table(13).category_name := 'APPLICATION'; l_category_entity_ad_table(13).entity_name := 'IGS_AD_APL_INT';
940: l_category_entity_ad_table(14).category_name := 'APPLICATION'; l_category_entity_ad_table(14).entity_name := 'IGS_AD_PS_APPL_INST_INT';

Line 1120: DELETE FROM igs_ad_txcpt_int

1116: WHERE status = '1'
1117: AND interface_run_id = p_interface_run_id;
1118: COMMIT;
1119:
1120: DELETE FROM igs_ad_txcpt_int
1121: WHERE status = '1'
1122: AND interface_run_id = p_interface_run_id;
1123: COMMIT;
1124: END IF; -- g_transcript_dtls_inc