APPS.IGS_TR_GEN_002 dependencies on IGS_TR_GEN_001

Line 1056: v_completion_due_dt := igs_tr_gen_001.trkp_clc_dt_offset(p_start_dt,

1052: -- ssawhney customer bug 2610394,
1053: -- RE was passing p_target_days as null and because of that v_comp_due_dt was coming out NOCOPY to be same as p_start_dt.
1054:
1055: IF p_completion_due_dt IS NULL THEN
1056: v_completion_due_dt := igs_tr_gen_001.trkp_clc_dt_offset(p_start_dt,
1057: NVL(p_target_days, v_tracking_type.target_days), -- p_target_days,
1058: l_business_days_ind,
1059: NVL(p_override_offset_clc_ind,'N'));
1060: END IF;

Line 1553: In call to function igs_tr_gen_001.trkp_clc_bus_dt the p_business_days

1549: 11 Jul,2001 Step update not allowed if item is complete,
1550: Complete item if all the steps are considered complete
1551:
1552: Aiyer 24-Apr-2002 This code has been modified by Aiyer for the bug 2309359
1553: In call to function igs_tr_gen_001.trkp_clc_bus_dt the p_business_days
1554: parameter was being passed as 'N'.This was causing a numeric conversion error .
1555: This has been set to NVL(p_action_days,0) in this fix.
1556:
1557: ssawhney 4-Nov-2003 Bug 3206700. The cursor to check item completion modified.

Line 1615: SELECT trst.*, trst.rowid ROW_ID, igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id, trst.tracking_step_number,

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
1615: SELECT trst.*, trst.rowid ROW_ID, igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id, trst.tracking_step_number,
1616: tri.start_dt, tri.sequence_ind,tri.business_days_ind ) action_dt
1617: FROM igs_tr_step trst,
1618: igs_tr_item tri
1619: WHERE trst.tracking_id = p_tracking_id

Line 1701: SELECT NVL(trst.completion_dt,igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id, trst.tracking_step_number,

1697: )RETURN BOOLEAN IS
1698: --ssawhney view reference changed to table in the second part..first part still referes to the function for getting the dates.
1699:
1700: CURSOR c_start_dt IS
1701: SELECT NVL(trst.completion_dt,igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id, trst.tracking_step_number,
1702: tri.start_dt, tri.sequence_ind,tri.business_days_ind )) start_dt
1703: FROM igs_tr_step trst, igs_tr_item tri
1704: WHERE trst.tracking_id = tri.tracking_id
1705: AND trst.tracking_id = p_tracking_id

Line 1714: SELECT trst.*, trst.rowid ROW_ID, igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id, trst.tracking_step_number,

1710: AND b.by_pass_ind = 'N');
1711:
1712: --ssawhney view reference changed to table and introduced fucntions.
1713: CURSOR c_upd_next_dt IS
1714: SELECT trst.*, trst.rowid ROW_ID, igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id, trst.tracking_step_number,
1715: tri.start_dt, tri.sequence_ind,tri.business_days_ind ) action_dt
1716: FROM igs_tr_step trst,
1717: igs_tr_item tri
1718: WHERE trst.tracking_id = tri.tracking_id

Line 1749: -- In function igs_tr_gen_001.trkp_clc_bus_dt the p_business_days parameter was being passed as 'N'.

1745: END IF;
1746:
1747: IF igs_tr_item_rec.business_days_ind = 'Y' THEN
1748: -- This code has been changed by Aiyer for the bug 2309359
1749: -- In function igs_tr_gen_001.trkp_clc_bus_dt the p_business_days parameter was being passed as 'N'.
1750: -- This was causing a numeric conversion error . This has been set to NVL(p_action_days,0) in this fix.
1751: l_clc_end_dt := igs_tr_gen_001.trkp_clc_bus_dt(p_end_dt, NVL(p_action_days,0));
1752:
1753: IF p_end_dt IS NOT NULL AND p_end_dt <> l_clc_end_dt THEN

Line 1751: l_clc_end_dt := igs_tr_gen_001.trkp_clc_bus_dt(p_end_dt, NVL(p_action_days,0));

1747: IF igs_tr_item_rec.business_days_ind = 'Y' THEN
1748: -- This code has been changed by Aiyer for the bug 2309359
1749: -- In function igs_tr_gen_001.trkp_clc_bus_dt the p_business_days parameter was being passed as 'N'.
1750: -- This was causing a numeric conversion error . This has been set to NVL(p_action_days,0) in this fix.
1751: l_clc_end_dt := igs_tr_gen_001.trkp_clc_bus_dt(p_end_dt, NVL(p_action_days,0));
1752:
1753: IF p_end_dt IS NOT NULL AND p_end_dt <> l_clc_end_dt THEN
1754: p_end_dt := l_clc_end_dt;
1755: RETURN FALSE;