APPS.IGS_TR_VAL_TRI dependencies on IGS_TR_STATUS

Line 53: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;

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;
55:
56: CURSOR c_get_closed_ind ( cp_tracking_status igs_tr_item.tracking_status%TYPE) IS
57: SELECT s_tracking_status, closed_ind

Line 54: v_closed_ind igs_tr_status.closed_ind%TYPE;

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;
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

Line 58: FROM igs_tr_status

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:
61: BEGIN
62:

Line 76: p_message_name := 'IGS_TR_STATUS_CLOSED';

72:
73: CLOSE c_get_closed_ind;
74:
75: IF (v_closed_ind = 'Y') THEN
76: p_message_name := 'IGS_TR_STATUS_CLOSED';
77: RETURN FALSE;
78: END IF;
79:
80: -- Validate that the status is active when inserting.