DBA Data[Home] [Help]

APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_PS_ENT_PT_REF_CD

Line 1377: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;

1373: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
1374: v_message_name VARCHAR2(30);
1375: v_return_type VARCHAR2(127);
1376: v_admission_cat IGS_AD_CAT.admission_cat%TYPE DEFAULT NULL;
1377: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
1378: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
1379: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
1380: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
1381: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;

Line 1378: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;

1374: v_message_name VARCHAR2(30);
1375: v_return_type VARCHAR2(127);
1376: v_admission_cat IGS_AD_CAT.admission_cat%TYPE DEFAULT NULL;
1377: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
1378: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
1379: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
1380: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
1381: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
1382: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;

Line 1379: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;

1375: v_return_type VARCHAR2(127);
1376: v_admission_cat IGS_AD_CAT.admission_cat%TYPE DEFAULT NULL;
1377: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
1378: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
1379: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
1380: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
1381: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
1382: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
1383: v_unit_set_cd VARCHAR2(255);

Line 1380: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;

1376: v_admission_cat IGS_AD_CAT.admission_cat%TYPE DEFAULT NULL;
1377: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
1378: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
1379: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
1380: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
1381: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
1382: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
1383: v_unit_set_cd VARCHAR2(255);
1384: v_us_version_number NUMBER(6);

Line 1381: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;

1377: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
1378: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
1379: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
1380: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
1381: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
1382: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
1383: v_unit_set_cd VARCHAR2(255);
1384: v_us_version_number NUMBER(6);
1385: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;

Line 1382: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;

1378: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
1379: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
1380: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
1381: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
1382: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
1383: v_unit_set_cd VARCHAR2(255);
1384: v_us_version_number NUMBER(6);
1385: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;
1386: v_ref_cd_type IGS_GE_REF_CD_TYPE.reference_cd_type%TYPE;

Line 1385: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;

1381: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
1382: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
1383: v_unit_set_cd VARCHAR2(255);
1384: v_us_version_number NUMBER(6);
1385: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;
1386: v_ref_cd_type IGS_GE_REF_CD_TYPE.reference_cd_type%TYPE;
1387: v_acai_admission_appl_number
1388: IGS_AD_PS_APPL_INST.admission_appl_number%TYPE;
1389: v_acai_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;