APPS.IGS_TR_GEN_002 dependencies on IGS_TR_STATUS

Line 395: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;

391: DECLARE
392:
393: v_other_detail VARCHAR2(255);
394: v_tracking_id igs_tr_item.tracking_id%TYPE;
395: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;
396: v_active_flag BOOLEAN DEFAULT FALSE;
397: v_cancelled_cnt NUMBER(3) DEFAULT 0;
398: v_row_cnt NUMBER(3) DEFAULT 0;
399:

Line 476: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;

472: -- Returns the status of tracking item
473: DECLARE
474:
475: v_other_detail VARCHAR2(255);
476: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;
477:
478: CURSOR c_get_s_tracking_status ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
479: SELECT s_tracking_status
480: FROM igs_tr_item it, igs_tr_status ts

Line 480: FROM igs_tr_item it, igs_tr_status ts

476: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;
477:
478: CURSOR c_get_s_tracking_status ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
479: SELECT s_tracking_status
480: FROM igs_tr_item it, igs_tr_status ts
481: WHERE it.tracking_id = cp_tracking_id
482: AND it.tracking_status = ts.tracking_status;
483:
484: BEGIN

Line 951: FROM igs_tr_status

947: p_rowid VARCHAR2(25);
948:
949: CURSOR c_tracking_status IS
950: SELECT 'x'
951: FROM igs_tr_status
952: WHERE tracking_status = p_tracking_status;
953:
954: CURSOR c_tracking_type IS
955: SELECT *

Line 1608: CURSOR c_sys_trk_sts(p_tracking_status igs_tr_status.tracking_status%TYPE) IS

1604: SELECT *
1605: FROM igs_tr_item
1606: WHERE tracking_id = p_tracking_id;
1607:
1608: CURSOR c_sys_trk_sts(p_tracking_status igs_tr_status.tracking_status%TYPE) IS
1609: SELECT s_tracking_status
1610: FROM igs_tr_status
1611: WHERE tracking_status = p_tracking_status;
1612:

Line 1610: FROM igs_tr_status

1606: WHERE tracking_id = p_tracking_id;
1607:
1608: CURSOR c_sys_trk_sts(p_tracking_status igs_tr_status.tracking_status%TYPE) IS
1609: SELECT s_tracking_status
1610: FROM igs_tr_status
1611: WHERE tracking_status = p_tracking_status;
1612:
1613: --ssawhney cant change view reference..using view logic in select.
1614: CURSOR c_update_trst IS

Line 1679: FROM igs_tr_status

1675: );
1676:
1677: CURSOR c_dflt_trk_sts IS
1678: SELECT tracking_status
1679: FROM igs_tr_status
1680: WHERE s_tracking_status = 'COMPLETE'
1681: AND default_ind = 'Y';
1682:
1683: igs_tr_step_rec c_update_trst%ROWTYPE;

Line 1685: l_sys_trk_sts igs_tr_status.s_tracking_status%TYPE;

1681: AND default_ind = 'Y';
1682:
1683: igs_tr_step_rec c_update_trst%ROWTYPE;
1684: igs_tr_item_rec c_tri_all%ROWTYPE;
1685: l_sys_trk_sts igs_tr_status.s_tracking_status%TYPE;
1686: l_trk_sts igs_tr_status.tracking_status%TYPE;
1687: l_item_cmpl c_check_item_cmpltn%ROWTYPE;
1688:
1689: -- validitate action / completion date and get action days

Line 1686: l_trk_sts igs_tr_status.tracking_status%TYPE;

1682:
1683: igs_tr_step_rec c_update_trst%ROWTYPE;
1684: igs_tr_item_rec c_tri_all%ROWTYPE;
1685: l_sys_trk_sts igs_tr_status.s_tracking_status%TYPE;
1686: l_trk_sts igs_tr_status.tracking_status%TYPE;
1687: l_item_cmpl c_check_item_cmpltn%ROWTYPE;
1688:
1689: -- validitate action / completion date and get action days
1690: FUNCTION process_date (