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_VAL_SCAP dependencies on IGS_AS_SU_ATMPT_ITM

Line 88: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,

84: END assp_val_spco_closed;
85: --
86: -- Validate SUAAI or SCAP can be created
87: FUNCTION assp_val_suaai_ins(
88: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
89: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
90: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
91: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
92: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,

Line 89: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,

85: --
86: -- Validate SUAAI or SCAP can be created
87: FUNCTION assp_val_suaai_ins(
88: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
89: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
90: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
91: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
92: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
93: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

Line 90: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,

86: -- Validate SUAAI or SCAP can be created
87: FUNCTION assp_val_suaai_ins(
88: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
89: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
90: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
91: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
92: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
93: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
94: p_message_name OUT NOCOPY VARCHAR2 ,

Line 91: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,

87: FUNCTION assp_val_suaai_ins(
88: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
89: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
90: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
91: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
92: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
93: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
94: p_message_name OUT NOCOPY VARCHAR2 ,
95: -- anilk, 22-Apr-2003, Bug# 2829262

Line 92: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,

88: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
89: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
90: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
91: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
92: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
93: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
94: p_message_name OUT NOCOPY VARCHAR2 ,
95: -- anilk, 22-Apr-2003, Bug# 2829262
96: p_uoo_id IN NUMBER )

Line 93: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

89: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
90: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
91: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
92: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
93: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
94: p_message_name OUT NOCOPY VARCHAR2 ,
95: -- anilk, 22-Apr-2003, Bug# 2829262
96: p_uoo_id IN NUMBER )
97: RETURN BOOLEAN IS

Line 191: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

187: p_course_cd IN VARCHAR2 ,
188: p_unit_cd IN VARCHAR2 ,
189: p_cal_type IN VARCHAR2 ,
190: p_ci_sequence_number IN NUMBER ,
191: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
192: p_creation_dt IN DATE ,
193: p_message_name OUT NOCOPY VARCHAR2 ,
194: -- anilk, 22-Apr-2003, Bug# 2829262
195: p_uoo_id IN NUMBER )

Line 203: FROM IGS_AS_SU_ATMPT_ITM suaai

199: -- This module validates the deletion date a suaai record
200: DECLARE
201: CURSOR c_suaai IS
202: SELECT suaai.logical_delete_dt
203: FROM IGS_AS_SU_ATMPT_ITM suaai
204: WHERE suaai.person_id = p_person_id AND
205: suaai.course_cd = p_course_cd AND
206: -- anilk, 22-Apr-2003, Bug# 2829262
207: suaai.uoo_id = p_uoo_id AND