APPS.IGS_TR_VAL_TRI dependencies on IGS_TR_ITEM

Line 50: -- Validate the IGS_TR_ITEM.tracking_status.

46: lv_param_values VARCHAR2(1080);
47:
48: BEGIN
49:
50: -- Validate the IGS_TR_ITEM.tracking_status.
51: DECLARE
52:
53: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;
54: v_closed_ind igs_tr_status.closed_ind%TYPE;

Line 56: CURSOR c_get_closed_ind ( cp_tracking_status igs_tr_item.tracking_status%TYPE) IS

52:
53: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;
54: v_closed_ind igs_tr_status.closed_ind%TYPE;
55:
56: CURSOR c_get_closed_ind ( cp_tracking_status igs_tr_item.tracking_status%TYPE) IS
57: SELECT s_tracking_status, closed_ind
58: FROM igs_tr_status
59: WHERE tracking_status = cp_tracking_status;
60:

Line 116: -- Validate the IGS_TR_ITEM.tracking_type.

112: lv_param_values VARCHAR2(1080);
113:
114: BEGIN
115:
116: -- Validate the IGS_TR_ITEM.tracking_type.
117: DECLARE
118:
119: v_closed_ind igs_tr_type.closed_ind%TYPE;
120: CURSOR c_get_closed_ind ( cp_tracking_type igs_tr_item.tracking_type%TYPE) IS

Line 120: CURSOR c_get_closed_ind ( cp_tracking_type igs_tr_item.tracking_type%TYPE) IS

116: -- Validate the IGS_TR_ITEM.tracking_type.
117: DECLARE
118:
119: v_closed_ind igs_tr_type.closed_ind%TYPE;
120: CURSOR c_get_closed_ind ( cp_tracking_type igs_tr_item.tracking_type%TYPE) IS
121: SELECT closed_ind
122: FROM igs_tr_type
123: WHERE tracking_type = cp_tracking_type;
124:

Line 174: -- This module validates IGS_TR_ITEM.start_dt is within

170: lv_param_values VARCHAR2(1080);
171:
172: BEGIN
173:
174: -- This module validates IGS_TR_ITEM.start_dt is within
175: -- a valid range for date manipulation within the form.
176: p_message_name := NULL;
177:
178: IF NOT (p_start_dt BETWEEN cst_min_dt AND cst_max_dt) THEN