DBA Data[Home] [Help]

APPS.IGS_EN_GEN_009 dependencies on IGS_AS_SC_ATMPT_ENR

Line 1431: -- Insert a record into the IGS_AS_SC_ATMPT_ENR table.

1427: p_message_name OUT NOCOPY VARCHAR2)
1428: RETURN BOOLEAN AS
1429:
1430: BEGIN -- enrp_ins_scae_trnsfr
1431: -- Insert a record into the IGS_AS_SC_ATMPT_ENR table.
1432: DECLARE
1433: v_dummy VARCHAR2(1);
1434: CURSOR c_scae IS
1435: SELECT 'x'

Line 1436: FROM IGS_AS_SC_ATMPT_ENR scae

1432: DECLARE
1433: v_dummy VARCHAR2(1);
1434: CURSOR c_scae IS
1435: SELECT 'x'
1436: FROM IGS_AS_SC_ATMPT_ENR scae
1437: WHERE scae.person_id = p_person_id AND
1438: scae.course_cd = p_course_cd AND
1439: scae.cal_type = p_cal_type AND
1440: scae.ci_sequence_number = p_ci_sequence_number;

Line 1463: IGS_AS_SC_ATMPT_ENR_PKG.INSERT_ROW(

1459: DECLARE
1460: l_rowid VARCHAR2(25);
1461: BEGIN
1462:
1463: IGS_AS_SC_ATMPT_ENR_PKG.INSERT_ROW(
1464: x_rowid => l_rowid,
1465: x_person_id => p_person_id,
1466: x_course_cd => p_course_cd,
1467: x_cal_type => p_cal_type,