DBA Data[Home] [Help]

APPS.IGS_AS_GEN_003 dependencies on IGS_AS_UNITASS_ITEM

Line 6: uaii in igs_as_unitass_item.unit_ass_item_id%type

2: /* $Header: IGSAS03S.pls 120.0 2005/07/05 12:12:27 appldev noship $ */
3:
4: FUNCTION assp_get_ai_ref(
5: usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,
6: uaii in igs_as_unitass_item.unit_ass_item_id%type
7: )
8: RETURN VARCHAR2 ;
9: PRAGMA RESTRICT_REFERENCES(assp_get_ai_ref,WNDS,WNPS);
10:

Line 13: uaii in igs_as_unitass_item.unit_ass_item_id%type

9: PRAGMA RESTRICT_REFERENCES(assp_get_ai_ref,WNDS,WNPS);
10:
11: FUNCTION assp_get_ai_reldate(
12: usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,
13: uaii in igs_as_unitass_item.unit_ass_item_id%type
14: )
15: RETURN DATE ;
16: PRAGMA RESTRICT_REFERENCES(assp_get_ai_reldate,WNDS,WNPS);
17:

Line 101: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )

97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
98: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
99: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
100: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
101: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
102: RETURN VARCHAR2 ;
103: PRAGMA RESTRICT_REFERENCES(assp_get_supp_cal,WNDS,WNPS);
104: FUNCTION assp_get_trn_sua_out(
105: p_person_id IN NUMBER ,