APPS.IGS_AS_VAL_SCAP dependencies on IGS_AS_SU_ATMPT_ITM

Line 20: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,

16: RETURN BOOLEAN;
17: --
18: -- Validate SUAAI or SCAP can be created
19: FUNCTION assp_val_suaai_ins(
20: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
21: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
22: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
23: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
24: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,

Line 21: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,

17: --
18: -- Validate SUAAI or SCAP can be created
19: FUNCTION assp_val_suaai_ins(
20: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
21: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
22: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
23: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
24: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
25: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

Line 22: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,

18: -- Validate SUAAI or SCAP can be created
19: FUNCTION assp_val_suaai_ins(
20: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
21: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
22: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
23: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
24: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
25: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
26: p_message_name OUT NOCOPY VARCHAR2 ,

Line 23: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,

19: FUNCTION assp_val_suaai_ins(
20: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
21: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
22: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
23: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
24: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
25: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
26: p_message_name OUT NOCOPY VARCHAR2 ,
27: -- anilk, 22-Apr-2003, Bug# 2829262

Line 24: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,

20: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
21: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
22: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
23: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
24: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
25: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
26: p_message_name OUT NOCOPY VARCHAR2 ,
27: -- anilk, 22-Apr-2003, Bug# 2829262
28: p_uoo_id IN NUMBER )

Line 25: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

21: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
22: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
23: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
24: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
25: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
26: p_message_name OUT NOCOPY VARCHAR2 ,
27: -- anilk, 22-Apr-2003, Bug# 2829262
28: p_uoo_id IN NUMBER )
29: RETURN BOOLEAN;

Line 38: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

34: p_course_cd IN VARCHAR2 ,
35: p_unit_cd IN VARCHAR2 ,
36: p_cal_type IN VARCHAR2 ,
37: p_ci_sequence_number IN NUMBER ,
38: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
39: p_creation_dt IN DATE ,
40: p_message_name OUT NOCOPY VARCHAR2 ,
41: -- anilk, 22-Apr-2003, Bug# 2829262
42: p_uoo_id IN NUMBER )