APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_OTHER_INST

Line 1083: l_other_inst_id IGS_AD_OTHER_INST.OTHER_INST_ID%TYPE;

1079: PROCEDURE insert_othinst(p_person_id IN NUMBER,
1080: p_adm_appl_id IN NUMBER,
1081: p_admission_appl_number IN NUMBER) AS
1082: l_rowid VARCHAR2(25);
1083: l_other_inst_id IGS_AD_OTHER_INST.OTHER_INST_ID%TYPE;
1084: lv_mode VARCHAR2(1) DEFAULT 'R';
1085:
1086: CURSOR c_othinst IS
1087: SELECT othinst.ss_othins_id,

Line 1112: IGS_AD_OTHER_INST_PKG.insert_row(x_rowid => l_rowid,

1108:
1109: FOR c_othinst_rec IN c_othinst LOOP
1110: l_rowid := '';
1111: l_other_inst_id := 0;
1112: IGS_AD_OTHER_INST_PKG.insert_row(x_rowid => l_rowid,
1113: x_other_inst_id => l_other_inst_id,
1114: x_person_id => p_person_id,
1115: x_admission_appl_number => p_admission_appl_number,
1116: x_institution_code => c_othinst_rec.institution_code,

Line 1124: 'Exception from IGS_AD_OTHER_INST_PKG.insert_row ' ||

1120: END LOOP;
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: logDetail('Inside insert_othinst' ||
1124: 'Exception from IGS_AD_OTHER_INST_PKG.insert_row ' ||
1125: SQLERRM || 'person_id : ' ||
1126: IGS_GE_NUMBER.TO_CANN(p_person_id),
1127: 'S');
1128: IF FND_MSG_PUB.Count_Msg < 1 THEN