APPS.IGS_AS_VAL_UAI dependencies on IGS_AS_UNIT_MODE

Line 49: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE ,

45: --
46:
47: -- Validate IGS_PS_UNIT mode closed indicator.
48: FUNCTION crsp_val_um_closed(
49: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE ,
50: p_message_name OUT NOCOPY VARCHAR2 )
51: RETURN BOOLEAN IS
52: gv_other_detail VARCHAR2(255);
53: BEGIN -- crsp_val_um_closed

Line 54: -- Validate the IGS_AS_UNIT_MODE closed indicator

50: p_message_name OUT NOCOPY VARCHAR2 )
51: RETURN BOOLEAN IS
52: gv_other_detail VARCHAR2(255);
53: BEGIN -- crsp_val_um_closed
54: -- Validate the IGS_AS_UNIT_MODE closed indicator
55: DECLARE
56: CURSOR c_um(
57: cp_unit_mode IGS_AS_UNIT_MODE.unit_mode%TYPE) IS
58: SELECT closed_ind

Line 57: cp_unit_mode IGS_AS_UNIT_MODE.unit_mode%TYPE) IS

53: BEGIN -- crsp_val_um_closed
54: -- Validate the IGS_AS_UNIT_MODE closed indicator
55: DECLARE
56: CURSOR c_um(
57: cp_unit_mode IGS_AS_UNIT_MODE.unit_mode%TYPE) IS
58: SELECT closed_ind
59: FROM IGS_AS_UNIT_MODE
60: WHERE unit_mode = cp_unit_mode;
61: v_um_rec c_um%ROWTYPE;

Line 59: FROM IGS_AS_UNIT_MODE

55: DECLARE
56: CURSOR c_um(
57: cp_unit_mode IGS_AS_UNIT_MODE.unit_mode%TYPE) IS
58: SELECT closed_ind
59: FROM IGS_AS_UNIT_MODE
60: WHERE unit_mode = cp_unit_mode;
61: v_um_rec c_um%ROWTYPE;
62: cst_yes CONSTANT CHAR := 'Y';
63: BEGIN

Line 131: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE,

127: p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
128: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
129: p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
130: p_location_cd IN VARCHAR2,
131: p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE,
132: p_unit_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,
133: p_message_name OUT NOCOPY VARCHAR2 )
134: RETURN BOOLEAN IS
135: BEGIN -- assp_val_uai_links