APPS.IGS_TR_STEP_PKG dependencies on IGS_TR_ITEM

Line 106: v_tracking_type igs_tr_item.tracking_type%TYPE;

102: ) AS
103:
104: v_message_name VARCHAR2(30);
105: v_tracking_id igs_tr_step.tracking_id%TYPE;
106: v_tracking_type igs_tr_item.tracking_type%TYPE;
107:
108: CURSOR c_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
109: SELECT tracking_type
110: FROM igs_tr_item

Line 108: CURSOR c_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

104: v_message_name VARCHAR2(30);
105: v_tracking_id igs_tr_step.tracking_id%TYPE;
106: v_tracking_type igs_tr_item.tracking_type%TYPE;
107:
108: CURSOR c_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
109: SELECT tracking_type
110: FROM igs_tr_item
111: WHERE tracking_id = cp_tracking_id;
112:

Line 110: FROM igs_tr_item

106: v_tracking_type igs_tr_item.tracking_type%TYPE;
107:
108: CURSOR c_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
109: SELECT tracking_type
110: FROM igs_tr_item
111: WHERE tracking_id = cp_tracking_id;
112:
113: BEGIN
114:

Line 188: IF NOT igs_tr_item_pkg.get_pk_for_validation ( new_references.tracking_id )THEN

184:
185: IF (((old_references.tracking_id = new_references.tracking_id)) OR ((new_references.tracking_id IS NULL))) THEN
186: NULL;
187: ELSE
188: IF NOT igs_tr_item_pkg.get_pk_for_validation ( new_references.tracking_id )THEN
189: fnd_message.set_name('FND','FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;

Line 270: PROCEDURE get_fk_igs_tr_item (

266: CLOSE cur_rowid;
267:
268: END get_fk_igs_pe_person;
269:
270: PROCEDURE get_fk_igs_tr_item (
271: x_tracking_id IN NUMBER
272: ) AS
273:
274: CURSOR cur_rowid IS

Line 294: END get_fk_igs_tr_item;

290: RETURN;
291: END IF;
292: CLOSE cur_rowid;
293:
294: END get_fk_igs_tr_item;
295:
296:
297: PROCEDURE get_fk_igs_lookups_view(
298: x_s_tracking_step_type IN VARCHAR2