APPS.IGS_AS_SU_ATMPT_ITM_PKG dependencies on IGS_TR_ITEM

Line 167: CURSOR cp_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

163: AS
164: v_message_name VARCHAR2 (30);
165: v_s_tracking_type igs_tr_type.s_tracking_type%TYPE;
166: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;
167: CURSOR cp_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
168: SELECT tt.s_tracking_type,
169: trs.s_tracking_status
170: FROM igs_tr_item tri,
171: igs_tr_type tt,

Line 170: FROM igs_tr_item tri,

166: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;
167: CURSOR cp_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
168: SELECT tt.s_tracking_type,
169: trs.s_tracking_status
170: FROM igs_tr_item tri,
171: igs_tr_type tt,
172: igs_tr_status trs
173: WHERE tri.tracking_id = cp_tracking_id
174: AND tri.tracking_type = tt.tracking_type

Line 377: ELSIF NOT igs_tr_item_pkg.get_pk_for_validation (new_references.tracking_id) THEN

373: IF (((old_references.tracking_id = new_references.tracking_id))
374: OR ((new_references.tracking_id IS NULL))
375: ) THEN
376: NULL;
377: ELSIF NOT igs_tr_item_pkg.get_pk_for_validation (new_references.tracking_id) THEN
378: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
379: igs_ge_msg_stack.ADD;
380: app_exception.raise_exception;
381: END IF;

Line 487: PROCEDURE get_fk_igs_tr_item (x_tracking_id IN NUMBER) AS

483: END IF;
484: CLOSE cur_rowid;
485: END get_fk_igs_as_sua_ai_group;
486:
487: PROCEDURE get_fk_igs_tr_item (x_tracking_id IN NUMBER) AS
488: CURSOR cur_rowid IS
489: SELECT ROWID
490: FROM igs_as_su_atmpt_itm
491: WHERE tracking_id = x_tracking_id;

Line 504: END get_fk_igs_tr_item;

500: app_exception.raise_exception;
501: RETURN;
502: END IF;
503: CLOSE cur_rowid;
504: END get_fk_igs_tr_item;
505:
506: -- Added by DDEY as a part of enhancement bug # 2162831
507: PROCEDURE get_fk_igs_as_grd_sch_grade (
508: x_grading_schema_cd IN VARCHAR2,