eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_GEN_004 dependencies on IGS_AS_SPL_CONS_APPL

Line 1199: p_person_id IN igs_as_spl_cons_appl.person_id%TYPE,

1195: --
1196: --
1197: --
1198: FUNCTION assp_ins_scap_lovall (
1199: p_person_id IN igs_as_spl_cons_appl.person_id%TYPE,
1200: p_course_cd IN igs_as_spl_cons_appl.course_cd%TYPE,
1201: p_unit_cd IN igs_as_spl_cons_appl.unit_cd%TYPE,
1202: p_cal_type IN igs_as_spl_cons_appl.cal_type%TYPE,
1203: p_ci_sequence_number IN NUMBER,

Line 1200: p_course_cd IN igs_as_spl_cons_appl.course_cd%TYPE,

1196: --
1197: --
1198: FUNCTION assp_ins_scap_lovall (
1199: p_person_id IN igs_as_spl_cons_appl.person_id%TYPE,
1200: p_course_cd IN igs_as_spl_cons_appl.course_cd%TYPE,
1201: p_unit_cd IN igs_as_spl_cons_appl.unit_cd%TYPE,
1202: p_cal_type IN igs_as_spl_cons_appl.cal_type%TYPE,
1203: p_ci_sequence_number IN NUMBER,
1204: p_received_dt IN DATE,

Line 1201: p_unit_cd IN igs_as_spl_cons_appl.unit_cd%TYPE,

1197: --
1198: FUNCTION assp_ins_scap_lovall (
1199: p_person_id IN igs_as_spl_cons_appl.person_id%TYPE,
1200: p_course_cd IN igs_as_spl_cons_appl.course_cd%TYPE,
1201: p_unit_cd IN igs_as_spl_cons_appl.unit_cd%TYPE,
1202: p_cal_type IN igs_as_spl_cons_appl.cal_type%TYPE,
1203: p_ci_sequence_number IN NUMBER,
1204: p_received_dt IN DATE,
1205: p_spcl_consideration_cat IN VARCHAR2,

Line 1202: p_cal_type IN igs_as_spl_cons_appl.cal_type%TYPE,

1198: FUNCTION assp_ins_scap_lovall (
1199: p_person_id IN igs_as_spl_cons_appl.person_id%TYPE,
1200: p_course_cd IN igs_as_spl_cons_appl.course_cd%TYPE,
1201: p_unit_cd IN igs_as_spl_cons_appl.unit_cd%TYPE,
1202: p_cal_type IN igs_as_spl_cons_appl.cal_type%TYPE,
1203: p_ci_sequence_number IN NUMBER,
1204: p_received_dt IN DATE,
1205: p_spcl_consideration_cat IN VARCHAR2,
1206: p_estimated_processing_days IN NUMBER,

Line 1221: v_static_sysdate igs_as_spl_cons_appl.received_dt%TYPE;

1217: DECLARE
1218: v_ass_id igs_as_su_atmpt_itm.ass_id%TYPE;
1219: v_creation_dt igs_as_su_atmpt_itm.creation_dt%TYPE;
1220: v_spcl_consideration_cat igs_as_spcl_cons_cat.spcl_consideration_cat%TYPE;
1221: v_static_sysdate igs_as_spl_cons_appl.received_dt%TYPE;
1222: v_ins_fail_flag BOOLEAN DEFAULT FALSE;
1223: v_scap_exists_flag BOOLEAN DEFAULT FALSE;
1224: v_scap_error_flag BOOLEAN DEFAULT FALSE;
1225: v_suaai_error_flag BOOLEAN DEFAULT FALSE;

Line 1244: CURSOR c_scap (cp_ass_id igs_as_spl_cons_appl.ass_id%TYPE) IS

1240: AND suaai2.course_cd = suaai.course_cd
1241: AND suaai2.uoo_id = suaai.uoo_id
1242: AND suaai2.logical_delete_dt IS NULL
1243: AND suaai2.ass_id = suaai.ass_id);
1244: CURSOR c_scap (cp_ass_id igs_as_spl_cons_appl.ass_id%TYPE) IS
1245: SELECT ass_id
1246: FROM igs_as_spl_cons_appl
1247: WHERE person_id = p_person_id
1248: AND course_cd = p_course_cd

Line 1246: FROM igs_as_spl_cons_appl

1242: AND suaai2.logical_delete_dt IS NULL
1243: AND suaai2.ass_id = suaai.ass_id);
1244: CURSOR c_scap (cp_ass_id igs_as_spl_cons_appl.ass_id%TYPE) IS
1245: SELECT ass_id
1246: FROM igs_as_spl_cons_appl
1247: WHERE person_id = p_person_id
1248: AND course_cd = p_course_cd
1249: AND uoo_id = p_uoo_id
1250: AND ass_id = cp_ass_id;

Line 1306: igs_as_spl_cons_appl_pkg.insert_row (

1302: ELSE
1303: DECLARE
1304: l_rowid7 VARCHAR (25);
1305: BEGIN
1306: igs_as_spl_cons_appl_pkg.insert_row (
1307: x_mode => 'R',
1308: x_rowid => l_rowid7,
1309: x_person_id => p_person_id,
1310: x_course_cd => p_course_cd,