DBA Data[Home] [Help]

APPS.IGS_AD_SS_APPL_FEE_PKG dependencies on IGS_AD_PRCS_CAT_STEP

Line 69: l_apcs_unit_restriction_num IGS_AD_PRCS_CAT_STEP.STEP_ORDER_NUM%TYPE;

65: l_apcs_unit_set_ind VARCHAR2(1);
66: l_apcs_un_crs_us_ind VARCHAR2(1);
67: l_apcs_chkuencumb_ind VARCHAR2(1);
68: l_apcs_unit_restr_ind VARCHAR2(1);
69: l_apcs_unit_restriction_num IGS_AD_PRCS_CAT_STEP.STEP_ORDER_NUM%TYPE;
70: l_apcs_un_dob_ind VARCHAR2(1);
71: l_apcs_un_title_ind VARCHAR2(1);
72: l_apcs_asses_cond_ind VARCHAR2(1);
73: l_apcs_fee_cond_ind VARCHAR2(1);

Line 76: l_apcs_multi_off_restn_num IGS_AD_PRCS_CAT_STEP.STEP_ORDER_NUM%TYPE;

72: l_apcs_asses_cond_ind VARCHAR2(1);
73: l_apcs_fee_cond_ind VARCHAR2(1);
74: l_apcs_doc_cond_ind VARCHAR2(1);
75: l_apcs_multi_off_ind VARCHAR2(1);
76: l_apcs_multi_off_restn_num IGS_AD_PRCS_CAT_STEP.STEP_ORDER_NUM%TYPE;
77: l_apcs_set_otcome_ind VARCHAR2(1);
78: l_apcs_override_o_ind VARCHAR2(1);
79: l_apcs_defer_ind VARCHAR2(1);
80: l_apcs_ack_app_ind VARCHAR2(1);

Line 281: l_apcs_unit_restriction_num IGS_AD_PRCS_CAT_STEP.STEP_ORDER_NUM%TYPE;

277: l_apcs_unit_set_ind VARCHAR2(1);
278: l_apcs_un_crs_us_ind VARCHAR2(1);
279: l_apcs_chkuencumb_ind VARCHAR2(1);
280: l_apcs_unit_restr_ind VARCHAR2(1);
281: l_apcs_unit_restriction_num IGS_AD_PRCS_CAT_STEP.STEP_ORDER_NUM%TYPE;
282: l_apcs_un_dob_ind VARCHAR2(1);
283: l_apcs_un_title_ind VARCHAR2(1);
284: l_apcs_asses_cond_ind VARCHAR2(1);
285: l_apcs_fee_cond_ind VARCHAR2(1);

Line 288: l_apcs_multi_off_restn_num IGS_AD_PRCS_CAT_STEP.STEP_ORDER_NUM%TYPE;

284: l_apcs_asses_cond_ind VARCHAR2(1);
285: l_apcs_fee_cond_ind VARCHAR2(1);
286: l_apcs_doc_cond_ind VARCHAR2(1);
287: l_apcs_multi_off_ind VARCHAR2(1);
288: l_apcs_multi_off_restn_num IGS_AD_PRCS_CAT_STEP.STEP_ORDER_NUM%TYPE;
289: l_apcs_set_otcome_ind VARCHAR2(1);
290: l_apcs_override_o_ind VARCHAR2(1);
291: l_apcs_defer_ind VARCHAR2(1);
292: l_apcs_ack_app_ind VARCHAR2(1);

Line 460: SELECT 1 FROM IGS_AD_PRCS_CAT_STEP APCS , IGS_TR_TYPE_ALL TRT

456: WHERE person_id = p_person_id AND
457: admission_appl_number = p_admission_application_number;
458:
459: CURSOR c_trk_exists(p_adm_cat VARCHAR2, p_adm_prc_typ VARCHAR2) IS
460: SELECT 1 FROM IGS_AD_PRCS_CAT_STEP APCS , IGS_TR_TYPE_ALL TRT
461: WHERE
462: APCS.S_ADMISSION_STEP_TYPE = TRT.TRACKING_TYPE AND
463: APCS.STEP_GROUP_TYPE = 'TRACK' AND
464: TRT.S_TRACKING_TYPE IS NOT NULL