APPS.IGS_AD_VAL_APCS dependencies on IGS_AD_PRCS_CAT_STEP

Line 3: -- Validate the IGS_AD_PRCS_CAT_STEP.mandatory_step_ind.

1: PACKAGE BODY IGS_AD_VAL_APCS AS
2: /* $Header: IGSAD42B.pls 115.8 2002/11/28 21:32:21 nsidana ship $ */
3: -- Validate the IGS_AD_PRCS_CAT_STEP.mandatory_step_ind.
4: FUNCTION admp_val_apcs_mndtry(
5: p_s_admission_step_type IN VARCHAR2 ,
6: p_mandatory_step_ind IN VARCHAR2 DEFAULT 'N',
7: p_message_name OUT NOCOPY VARCHAR2 )

Line 17: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS

13: cst_no CONSTANT CHAR := 'N';
14: v_step_order_applicable_ind
15: IGS_LOOKUPS_view.step_order_applicable_ind%TYPE;
16: CURSOR c_apcs (
17: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
18: SELECT sasgt.step_order_applicable_ind
19: FROM IGS_LOOKUPS_view sasgt,
20: IGS_LOOKUPS_view sast
21: WHERE sasgt.lookup_code = sast.step_group_type AND

Line 49: -- Validate the IGS_AD_PRCS_CAT_STEP.step_order_num.

45: IGS_GE_MSG_STACK.ADD;
46: App_Exception.Raise_Exception;
47: END admp_val_apcs_mndtry;
48: --
49: -- Validate the IGS_AD_PRCS_CAT_STEP.step_order_num.
50: FUNCTION admp_val_apcs_order(
51: p_s_admission_step_type IN VARCHAR2 ,
52: p_step_order_num IN NUMBER ,
53: p_message_name OUT NOCOPY VARCHAR2 )

Line 57: -- Validate the IGS_AD_PRCS_CAT_STEP.step_order_num

53: p_message_name OUT NOCOPY VARCHAR2 )
54: RETURN BOOLEAN IS
55: gv_other_detail VARCHAR2(255);
56: BEGIN -- admp_val_apcs_order
57: -- Validate the IGS_AD_PRCS_CAT_STEP.step_order_num
58: DECLARE
59: cst_no CONSTANT CHAR := 'N';
60: cst_yes CONSTANT CHAR := 'Y';
61: v_step_order_num IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;

Line 63: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS

59: cst_no CONSTANT CHAR := 'N';
60: cst_yes CONSTANT CHAR := 'Y';
61: v_step_order_num IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;
62: CURSOR c_order(
63: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
64: SELECT sasgt.step_order_applicable_ind
65: FROM IGS_LOOKUPS_view sasgt,
66: IGS_LOOKUPS_view sast
67: WHERE sasgt.lookup_code = sast.step_group_type AND

Line 99: -- Validate the IGS_AD_PRCS_CAT_STEP.step_type_restriction_num.

95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END admp_val_apcs_order;
98: --
99: -- Validate the IGS_AD_PRCS_CAT_STEP.step_type_restriction_num.
100: FUNCTION admp_val_apcs_rstrct(
101: p_s_admission_step_type IN VARCHAR2 ,
102: p_step_type_restriction_num IN NUMBER ,
103: p_message_name OUT NOCOPY VARCHAR2 )

Line 107: -- Validate the IGS_AD_PRCS_CAT_STEP.step_type_restriction_num

103: p_message_name OUT NOCOPY VARCHAR2 )
104: RETURN BOOLEAN IS
105: gv_other_detail VARCHAR2(255);
106: BEGIN -- admp_val_apcs_rstrct
107: -- Validate the IGS_AD_PRCS_CAT_STEP.step_type_restriction_num
108: DECLARE
109: cst_no CONSTANT CHAR := 'N';
110: cst_yes CONSTANT CHAR := 'Y';
111: v_step_type_rest_num_ind

Line 114: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS

110: cst_yes CONSTANT CHAR := 'Y';
111: v_step_type_rest_num_ind
112: IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;
113: CURSOR c_rstrct(
114: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
115: SELECT sast.step_type_restriction_num_ind
116: FROM IGS_LOOKUPS_view sast
117: WHERE sast.lookup_code = cp_s_admission_step_type AND
118: sast.lookup_Type = 'ADMISSION_STEP_TYPE';