[Home] [Help]
22:
23: v_sequence_ind igs_tr_item.sequence_ind%TYPE;
24: v_completion_ind NUMBER;
25: -- added for tracking dld in nov 2001 release (bug 1837257)
26: l_override_offset_clc_ind igs_tr_item_all.override_offset_clc_ind%TYPE ;
27: -- modified this cursor to select override_offset_clc_ind which is added
28: -- in the tracking dld of nov2001 release
29: CURSOR c_tracking_item( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
30: SELECT sequence_ind , override_offset_clc_ind