APPS.IGR_IMP_001 dependencies on IGR_I_APPL_INT

Line 866: INSERT INTO igr_i_appl_int

862: /* Validate the data in Self Service table for not null before inseting into igs_ad_inq_appl_int */
863: validate_inq_appl_int(inq_rec, l_status,l_tokenstr);
864: IF l_status = 1 THEN /* Validation Successfull*/
865: BEGIN
866: INSERT INTO igr_i_appl_int
867: (
868: interface_inq_appl_id ,
869: interface_id ,
870: enquiry_appl_number ,

Line 927: igr_i_appl_int_s.nextval,

923: program_update_date,
924: source_promotion_id
925: )VALUES
926: (
927: igr_i_appl_int_s.nextval,
928: l_interface_id ,
929: null ,
930: inq_rec.acad_cal_type ,
931: inq_rec.acad_ci_sequence_number ,

Line 987: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_APPL_INT failed '||SQLERRM);

983: inq_rec.source_promotion_id
984: );
985: EXCEPTION WHEN OTHERS THEN
986: l_status:=0;
987: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_APPL_INT failed '||SQLERRM);
988: RAISE;
989: END;
990: ELSE /* l_status = 0 i.e Validation failed*/
991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

Line 992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');

988: RAISE;
989: END;
990: ELSE /* l_status = 0 i.e Validation failed*/
991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');
993: fnd_message.set_token('COL_NAMES',l_tokenstr);
994: fnd_message.set_token('ID',inq_rec.inq_person_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: RAISE null_validation_fails;

Line 1709: igr_i_appl_int_s.currval ,

1705: program_update_date
1706: ) VALUES
1707: (
1708: igr_i_pkg_int_s.nextval ,
1709: igr_i_appl_int_s.currval ,
1710: inq_info_rec.package_item_id ,
1711: '2' ,
1712: null ,
1713: null ,

Line 1767: igr_i_appl_int_s.currval,

1763: program_update_date
1764: ) VALUES
1765: (
1766: igr_i_lines_int_s.nextval,
1767: igr_i_appl_int_s.currval,
1768: inq_lines_rec.preference,
1769: inq_lines_rec.product_category_id ,
1770: inq_lines_rec.product_category_set_id ,
1771: '2' ,