eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_TR_GEN_002 dependencies on IGS_TR_ITEM

Line 17: IGS_TR_ITEMS, deletion of tracking item notes for IGS_TR_ITEMS and deletion of

13:
14: Purpose:
15: 1. Used for deletion of tracking step notes, deletion of
16: tracking steps, for tracking items, deletion of tracking group members for
17: IGS_TR_ITEMS, deletion of tracking item notes for IGS_TR_ITEMS and deletion of
18: IGS_TR_ITEMS
19:
20: Usage: (e.g. restricted, unrestricted, where to call from)
21: 1. Called from IGSTR007.fmb

Line 18: IGS_TR_ITEMS

14: Purpose:
15: 1. Used for deletion of tracking step notes, deletion of
16: tracking steps, for tracking items, deletion of tracking group members for
17: IGS_TR_ITEMS, deletion of tracking item notes for IGS_TR_ITEMS and deletion of
18: IGS_TR_ITEMS
19:
20: Usage: (e.g. restricted, unrestricted, where to call from)
21: 1. Called from IGSTR007.fmb
22:

Line 44: -- 1. Delete tracking_step_notes for the IGS_TR_ITEM.

40: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
41: v_message_name VARCHAR2(30);
42:
43: ------------------------------------------------------------------------------
44: -- 1. Delete tracking_step_notes for the IGS_TR_ITEM.
45: ------------------------------------------------------------------------------
46:
47: FUNCTION trkpl_del_tsn (
48: lp_tracking_id igs_tr_item.tracking_id%TYPE)

Line 48: lp_tracking_id igs_tr_item.tracking_id%TYPE)

44: -- 1. Delete tracking_step_notes for the IGS_TR_ITEM.
45: ------------------------------------------------------------------------------
46:
47: FUNCTION trkpl_del_tsn (
48: lp_tracking_id igs_tr_item.tracking_id%TYPE)
49: RETURN BOOLEAN AS
50: lv_param_values VARCHAR2(1080);
51: BEGIN
52:

Line 83: p_message_name := 'IGS_TR_ITEM_STEP_NOTE_LOCKED';

79:
80: EXCEPTION
81:
82: WHEN e_resource_busy THEN
83: p_message_name := 'IGS_TR_ITEM_STEP_NOTE_LOCKED';
84: RETURN FALSE;
85:
86: WHEN OTHERS THEN
87: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 99: -- 2. Delete tracking_step for the IGS_TR_ITEM.

95:
96: END trkpl_del_tsn;
97:
98: ------------------------------------------------------------------------------
99: -- 2. Delete tracking_step for the IGS_TR_ITEM.
100: ------------------------------------------------------------------------------
101: FUNCTION trkpl_del_ts(
102: lp_tracking_id igs_tr_item.tracking_id%TYPE)
103: RETURN BOOLEAN AS

Line 102: lp_tracking_id igs_tr_item.tracking_id%TYPE)

98: ------------------------------------------------------------------------------
99: -- 2. Delete tracking_step for the IGS_TR_ITEM.
100: ------------------------------------------------------------------------------
101: FUNCTION trkpl_del_ts(
102: lp_tracking_id igs_tr_item.tracking_id%TYPE)
103: RETURN BOOLEAN AS
104:
105: lv_param_values VARCHAR2(1080);
106:

Line 144: -- 3. Delete tracking_group_member for the IGS_TR_ITEM.

140:
141: END trkpl_del_ts;
142:
143: ------------------------------------------------------------------------------
144: -- 3. Delete tracking_group_member for the IGS_TR_ITEM.
145: ------------------------------------------------------------------------------
146: FUNCTION trkpl_del_tgm(
147: lp_tracking_id igs_tr_item.tracking_id%TYPE)
148: RETURN BOOLEAN AS

Line 147: lp_tracking_id igs_tr_item.tracking_id%TYPE)

143: ------------------------------------------------------------------------------
144: -- 3. Delete tracking_group_member for the IGS_TR_ITEM.
145: ------------------------------------------------------------------------------
146: FUNCTION trkpl_del_tgm(
147: lp_tracking_id igs_tr_item.tracking_id%TYPE)
148: RETURN BOOLEAN AS
149: lv_param_values VARCHAR2(1080);
150: BEGIN
151:

Line 187: -- 4. Delete tracking_item_notes for the IGS_TR_ITEM.

183:
184: END trkpl_del_tgm;
185:
186: ------------------------------------------------------------------------------
187: -- 4. Delete tracking_item_notes for the IGS_TR_ITEM.
188: ------------------------------------------------------------------------------
189: FUNCTION trkpl_del_tin (
190: lp_tracking_id igs_tr_item.tracking_id%TYPE)
191: RETURN BOOLEAN AS

Line 190: lp_tracking_id igs_tr_item.tracking_id%TYPE)

186: ------------------------------------------------------------------------------
187: -- 4. Delete tracking_item_notes for the IGS_TR_ITEM.
188: ------------------------------------------------------------------------------
189: FUNCTION trkpl_del_tin (
190: lp_tracking_id igs_tr_item.tracking_id%TYPE)
191: RETURN BOOLEAN AS
192: lv_param_values VARCHAR2(1080);
193: BEGIN
194:

Line 199: FROM igs_tr_item_note

195: DECLARE
196:
197: CURSOR c_del_tin IS
198: SELECT ROWID, reference_number
199: FROM igs_tr_item_note
200: WHERE tracking_id = lp_tracking_id
201: FOR UPDATE OF tracking_id NOWAIT;
202:
203: BEGIN

Line 206: igs_tr_item_note_pkg.delete_row( x_rowid => v_tin_rec.ROWID);

202:
203: BEGIN
204:
205: FOR v_tin_rec IN c_del_tin LOOP
206: igs_tr_item_note_pkg.delete_row( x_rowid => v_tin_rec.ROWID);
207: IF igs_ge_gen_001.genp_del_note( v_tin_rec.reference_number, v_message_name) = FALSE THEN
208: p_message_name := v_message_name;
209: EXIT;
210: END IF;

Line 223: p_message_name := 'IGS_TR_ITEM_NOTE_REC_LOCKED';

219:
220: EXCEPTION
221:
222: WHEN e_resource_busy THEN
223: p_message_name := 'IGS_TR_ITEM_NOTE_REC_LOCKED';
224: RETURN FALSE;
225:
226: WHEN OTHERS THEN
227: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 239: -- 5. Delete the IGS_TR_ITEM.

235:
236: END trkpl_del_tin;
237:
238: ------------------------------------------------------------------------------
239: -- 5. Delete the IGS_TR_ITEM.
240: ------------------------------------------------------------------------------
241: FUNCTION trkpl_del_tri(
242: lp_tracking_id igs_tr_item.tracking_id%TYPE)
243: RETURN BOOLEAN AS

Line 242: lp_tracking_id igs_tr_item.tracking_id%TYPE)

238: ------------------------------------------------------------------------------
239: -- 5. Delete the IGS_TR_ITEM.
240: ------------------------------------------------------------------------------
241: FUNCTION trkpl_del_tri(
242: lp_tracking_id igs_tr_item.tracking_id%TYPE)
243: RETURN BOOLEAN AS
244: lv_param_values VARCHAR2(1080);
245: BEGIN
246:

Line 250: SELECT ROWID, igs_tr_item.*

246:
247: DECLARE
248:
249: CURSOR c_del_tri IS
250: SELECT ROWID, igs_tr_item.*
251: FROM igs_tr_item
252: WHERE tracking_id = lp_tracking_id
253: FOR UPDATE OF tracking_id NOWAIT;
254:

Line 251: FROM igs_tr_item

247: DECLARE
248:
249: CURSOR c_del_tri IS
250: SELECT ROWID, igs_tr_item.*
251: FROM igs_tr_item
252: WHERE tracking_id = lp_tracking_id
253: FOR UPDATE OF tracking_id NOWAIT;
254:
255: BEGIN

Line 258: igs_tr_item_pkg.delete_row( x_rowid => v_tri_rec.ROWID);

254:
255: BEGIN
256:
257: FOR v_tri_rec IN c_del_tri LOOP
258: igs_tr_item_pkg.delete_row( x_rowid => v_tri_rec.ROWID);
259: END LOOP;
260:
261: RETURN TRUE;
262: END;

Line 267: p_message_name := 'IGS_TR_ITEM_RECORD_LOCKED';

263:
264: EXCEPTION
265:
266: WHEN e_resource_busy THEN
267: p_message_name := 'IGS_TR_ITEM_RECORD_LOCKED';
268: RETURN FALSE;
269:
270: WHEN OTHERS THEN
271: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 394: v_tracking_id igs_tr_item.tracking_id%TYPE;

390: -- return status of a tracking group
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;

Line 478: CURSOR c_get_s_tracking_status ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

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
481: WHERE it.tracking_id = cp_tracking_id
482: AND it.tracking_status = ts.tracking_status;

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 543: v_tracking_type igs_tr_item.tracking_type%TYPE;

539:
540: DECLARE
541:
542: v_other_detail VARCHAR2(255);
543: v_tracking_type igs_tr_item.tracking_type%TYPE;
544: v_originator_person_id igs_tr_item.originator_person_id%TYPE;
545: v_new_reference_number igs_ge_note.reference_number%TYPE;
546: p_rowid VARCHAR2(25);
547: v_start_dt igs_tr_item.start_dt%TYPE;

Line 544: v_originator_person_id igs_tr_item.originator_person_id%TYPE;

540: DECLARE
541:
542: v_other_detail VARCHAR2(255);
543: v_tracking_type igs_tr_item.tracking_type%TYPE;
544: v_originator_person_id igs_tr_item.originator_person_id%TYPE;
545: v_new_reference_number igs_ge_note.reference_number%TYPE;
546: p_rowid VARCHAR2(25);
547: v_start_dt igs_tr_item.start_dt%TYPE;
548: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;

Line 547: v_start_dt igs_tr_item.start_dt%TYPE;

543: v_tracking_type igs_tr_item.tracking_type%TYPE;
544: v_originator_person_id igs_tr_item.originator_person_id%TYPE;
545: v_new_reference_number igs_ge_note.reference_number%TYPE;
546: p_rowid VARCHAR2(25);
547: v_start_dt igs_tr_item.start_dt%TYPE;
548: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;
549: v_override_offset_clc_ind igs_tr_item.override_offset_clc_ind%TYPE;
550:
551: CURSOR c_tracking_item ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

Line 548: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;

544: v_originator_person_id igs_tr_item.originator_person_id%TYPE;
545: v_new_reference_number igs_ge_note.reference_number%TYPE;
546: p_rowid VARCHAR2(25);
547: v_start_dt igs_tr_item.start_dt%TYPE;
548: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;
549: v_override_offset_clc_ind igs_tr_item.override_offset_clc_ind%TYPE;
550:
551: CURSOR c_tracking_item ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
552: SELECT tracking_type, originator_person_id,start_dt,completion_due_dt, override_offset_clc_ind

Line 549: v_override_offset_clc_ind igs_tr_item.override_offset_clc_ind%TYPE;

545: v_new_reference_number igs_ge_note.reference_number%TYPE;
546: p_rowid VARCHAR2(25);
547: v_start_dt igs_tr_item.start_dt%TYPE;
548: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;
549: v_override_offset_clc_ind igs_tr_item.override_offset_clc_ind%TYPE;
550:
551: CURSOR c_tracking_item ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
552: SELECT tracking_type, originator_person_id,start_dt,completion_due_dt, override_offset_clc_ind
553: FROM igs_tr_item

Line 551: CURSOR c_tracking_item ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

547: v_start_dt igs_tr_item.start_dt%TYPE;
548: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;
549: v_override_offset_clc_ind igs_tr_item.override_offset_clc_ind%TYPE;
550:
551: CURSOR c_tracking_item ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
552: SELECT tracking_type, originator_person_id,start_dt,completion_due_dt, override_offset_clc_ind
553: FROM igs_tr_item
554: WHERE tracking_id = cp_tracking_id;
555:

Line 553: FROM igs_tr_item

549: v_override_offset_clc_ind igs_tr_item.override_offset_clc_ind%TYPE;
550:
551: CURSOR c_tracking_item ( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
552: SELECT tracking_type, originator_person_id,start_dt,completion_due_dt, override_offset_clc_ind
553: FROM igs_tr_item
554: WHERE tracking_id = cp_tracking_id;
555:
556: CURSOR c_tracking_type_step ( cp_tracking_type igs_tr_type.tracking_type%TYPE) IS
557: SELECT *

Line 912: IGS_TR_ITEM record. The tracking item step will be defaulted

908:
909: Purpose:
910: 1. This procedure will be used by batch processing to create a tracking item
911: It will accept the details of the item to be created and insert a
912: IGS_TR_ITEM record. The tracking item step will be defaulted
913: when the database table insert trigger fires for the tracking item.
914:
915: Usage: (e.g. restricted, unrestricted, where to call from)
916: 1. Called from IGSTR007.FMB

Line 930: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;

926: *******************************************************************************/
927:
928: gv_other_detail VARCHAR2(255);
929: lv_param_values VARCHAR2(1080);
930: v_completion_due_dt igs_tr_item.completion_due_dt%TYPE;
931:
932: BEGIN
933:
934: -- trkp_ins_trk_item

Line 937: -- IGS_TR_ITEM record. The tracking item step will be defaulted

933:
934: -- trkp_ins_trk_item
935: -- This procedure will be used by batch processing to create a tracking item
936: -- It will accept the details of the item to be created and insert a
937: -- IGS_TR_ITEM record. The tracking item step will be defaulted
938: -- when the database table insert trigger fires for the tracking item.
939:
940: DECLARE
941:

Line 944: v_nxt_tracking_id igs_tr_item.tracking_id%TYPE;

940: DECLARE
941:
942: v_check CHAR;
943: v_tracking_type igs_tr_type%ROWTYPE;
944: v_nxt_tracking_id igs_tr_item.tracking_id%TYPE;
945: l_sequence_ind igs_tr_type.sequence_ind%TYPE;
946: l_business_days_ind igs_tr_type.business_days_ind%TYPE;
947: p_rowid VARCHAR2(25);
948:

Line 966: SELECT igs_tr_item_tr_id_s.NEXTVAL

962: FROM igs_pe_person_base_v
963: WHERE person_id = cp_person_id;
964:
965: CURSOR c_tri_nxt_seq_num IS
966: SELECT igs_tr_item_tr_id_s.NEXTVAL
967: FROM dual;
968:
969: BEGIN
970:

Line 1068: igs_tr_item_pkg.insert_row(

1064: FETCH c_tri_nxt_seq_num INTO v_nxt_tracking_id;
1065: CLOSE c_tri_nxt_seq_num;
1066: p_tracking_id := v_nxt_tracking_id;
1067:
1068: igs_tr_item_pkg.insert_row(
1069: x_rowid => p_rowid,
1070: x_tracking_id => v_nxt_tracking_id,
1071: x_tracking_status => p_tracking_status ,
1072: x_tracking_type => p_tracking_type,

Line 1583: v_start_dt igs_tr_item.start_dt%TYPE;

1579: v_completion_dt igs_tr_step.completion_dt%TYPE;
1580: v_step_completion_ind igs_tr_step.step_completion_ind%TYPE;
1581: v_by_pass_ind igs_tr_step.by_pass_ind%TYPE;
1582: v_recipient_id igs_tr_step.recipient_id%TYPE;
1583: v_start_dt igs_tr_item.start_dt%TYPE;
1584: v_business_days_ind igs_tr_item.business_days_ind%TYPE;
1585: v_sequence_ind igs_tr_item.sequence_ind%TYPE;
1586: v_step_completion_ind_temp igs_tr_step.step_completion_ind%TYPE;
1587: v_action_dt igs_tr_step_v.action_dt%TYPE;

Line 1584: v_business_days_ind igs_tr_item.business_days_ind%TYPE;

1580: v_step_completion_ind igs_tr_step.step_completion_ind%TYPE;
1581: v_by_pass_ind igs_tr_step.by_pass_ind%TYPE;
1582: v_recipient_id igs_tr_step.recipient_id%TYPE;
1583: v_start_dt igs_tr_item.start_dt%TYPE;
1584: v_business_days_ind igs_tr_item.business_days_ind%TYPE;
1585: v_sequence_ind igs_tr_item.sequence_ind%TYPE;
1586: v_step_completion_ind_temp igs_tr_step.step_completion_ind%TYPE;
1587: v_action_dt igs_tr_step_v.action_dt%TYPE;
1588: v_message_name VARCHAR2(30);

Line 1585: v_sequence_ind igs_tr_item.sequence_ind%TYPE;

1581: v_by_pass_ind igs_tr_step.by_pass_ind%TYPE;
1582: v_recipient_id igs_tr_step.recipient_id%TYPE;
1583: v_start_dt igs_tr_item.start_dt%TYPE;
1584: v_business_days_ind igs_tr_item.business_days_ind%TYPE;
1585: v_sequence_ind igs_tr_item.sequence_ind%TYPE;
1586: v_step_completion_ind_temp igs_tr_step.step_completion_ind%TYPE;
1587: v_action_dt igs_tr_step_v.action_dt%TYPE;
1588: v_message_name VARCHAR2(30);
1589: v_rowid VARCHAR2(25);

Line 1605: FROM igs_tr_item

1601: cnt NUMBER DEFAULT 1;
1602:
1603: CURSOR c_tri_all 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

Line 1618: igs_tr_item tri

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
1620: AND trst.tracking_id = tri.tracking_id
1621: AND ((NVL(p_tracking_step_id, 0) = 0)
1622: OR

Line 1684: igs_tr_item_rec c_tri_all%ROWTYPE;

1680: WHERE s_tracking_status = 'COMPLETE'
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:

Line 1703: FROM igs_tr_step trst, igs_tr_item tri

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
1706: AND trst.tracking_step_number = (SELECT MAX(b.tracking_step_number)
1707: FROM igs_tr_step b

Line 1717: igs_tr_item tri

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
1719: AND trst.tracking_id = p_tracking_id
1720: AND trst.tracking_step_number > p_tracking_step_number
1721: FOR UPDATE OF trst.action_days NOWAIT;

Line 1747: IF igs_tr_item_rec.business_days_ind = 'Y' THEN

1743: p_message_name := 'IGS_TR_DT_CANNOT_LT_ST_DATE';
1744: RETURN FALSE;
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));

Line 1789: IF igs_tr_item_rec.sequence_ind = 'Y' THEN

1785: app_exception.raise_exception;
1786: END validate_date;
1787:
1788: BEGIN
1789: IF igs_tr_item_rec.sequence_ind = 'Y' THEN
1790: IF (p_tracking_step_number - 1) = 0 THEN
1791: l_start_dt := igs_tr_item_rec.start_dt;
1792: ELSE
1793: OPEN c_start_dt;

Line 1791: l_start_dt := igs_tr_item_rec.start_dt;

1787:
1788: BEGIN
1789: IF igs_tr_item_rec.sequence_ind = 'Y' THEN
1790: IF (p_tracking_step_number - 1) = 0 THEN
1791: l_start_dt := igs_tr_item_rec.start_dt;
1792: ELSE
1793: OPEN c_start_dt;
1794: FETCH c_start_dt INTO l_start_dt;
1795: CLOSE c_start_dt;

Line 1798: l_start_dt := igs_tr_item_rec.start_dt;

1794: FETCH c_start_dt INTO l_start_dt;
1795: CLOSE c_start_dt;
1796: END IF;
1797: ELSE
1798: l_start_dt := igs_tr_item_rec.start_dt;
1799: END IF;
1800:
1801: IF NOT (validate_date (p_date_type,
1802: p_tracking_id,

Line 1819: IF igs_tr_item_rec.sequence_ind = 'Y' THEN

1815: l_next_start_dt_diff := TRUNC(p_end_dt) - TRUNC(igs_tr_step_rec.completion_dt);
1816: l_next_start_dt := TRUNC(p_end_dt);
1817: END IF;
1818:
1819: IF igs_tr_item_rec.sequence_ind = 'Y' THEN
1820:
1821: FOR l_upd_next_dt_rec IN c_upd_next_dt LOOP
1822:
1823: IF (l_upd_next_dt_rec.step_completion_ind = 'N' AND l_upd_next_dt_rec.by_pass_ind = 'N') THEN

Line 1907: FETCH c_tri_all INTO igs_tr_item_rec;

1903:
1904: -- Manu Validate that the step being updated does not
1905: -- belong to an item that is complete
1906: OPEN c_tri_all;
1907: FETCH c_tri_all INTO igs_tr_item_rec;
1908:
1909: IF c_tri_all%NOTFOUND THEN
1910: CLOSE c_tri_all;
1911: p_message_name := 'IGS_TR_INVALID_ITEM_ID';

Line 1915: OPEN c_sys_trk_sts(igs_tr_item_rec.tracking_status);

1911: p_message_name := 'IGS_TR_INVALID_ITEM_ID';
1912: RETURN FALSE;
1913:
1914: ELSE
1915: OPEN c_sys_trk_sts(igs_tr_item_rec.tracking_status);
1916: FETCH c_sys_trk_sts INTO l_sys_trk_sts;
1917: CLOSE c_sys_trk_sts;
1918:
1919: IF (l_sys_trk_sts <> 'ACTIVE') THEN

Line 1952: IF (igs_tr_item_rec.override_offset_clc_ind = 'N' AND

1948: p_by_pass_ind <> igs_tr_step_rec.by_pass_ind) THEN
1949: l_field_mod := l_field_mod || 'B';
1950: END IF;
1951:
1952: IF (igs_tr_item_rec.override_offset_clc_ind = 'N' AND
1953: p_action_dt IS NOT NULL AND
1954: p_action_dt <> igs_tr_step_rec.action_dt AND
1955: igs_tr_step_rec.step_completion_ind = 'N' AND
1956: igs_tr_step_rec.by_pass_ind = 'N') THEN

Line 1957: IF (igs_tr_item_rec.sequence_ind = 'Y' AND

1953: p_action_dt IS NOT NULL AND
1954: p_action_dt <> igs_tr_step_rec.action_dt AND
1955: igs_tr_step_rec.step_completion_ind = 'N' AND
1956: igs_tr_step_rec.by_pass_ind = 'N') THEN
1957: IF (igs_tr_item_rec.sequence_ind = 'Y' AND
1958: NVL(INSTR(l_field_mod,'S'),0) = 0 AND
1959: NVL(INSTR(l_field_mod,'B'),0) = 0) OR
1960: (igs_tr_item_rec.sequence_ind = 'N') THEN
1961: l_field_mod := l_field_mod || 'A';

Line 1960: (igs_tr_item_rec.sequence_ind = 'N') THEN

1956: igs_tr_step_rec.by_pass_ind = 'N') THEN
1957: IF (igs_tr_item_rec.sequence_ind = 'Y' AND
1958: NVL(INSTR(l_field_mod,'S'),0) = 0 AND
1959: NVL(INSTR(l_field_mod,'B'),0) = 0) OR
1960: (igs_tr_item_rec.sequence_ind = 'N') THEN
1961: l_field_mod := l_field_mod || 'A';
1962: END IF;
1963: END IF;
1964:

Line 1998: IF (igs_tr_item_rec.sequence_ind = 'Y') THEN

1994: CLOSE c_update_trst;
1995: RETURN FALSE;
1996: END IF;
1997:
1998: IF (igs_tr_item_rec.sequence_ind = 'Y') THEN
1999: IF NVL(INSTR(l_field_mod,'S'),0) > 0 THEN
2000: IF p_step_completion_ind = 'Y' THEN
2001: -- Validate new value, on error return false
2002: IF trkp_prev_step_cmplt (

Line 2159: ELSIF (igs_tr_item_rec.sequence_ind = 'N') THEN

2155: END IF;
2156:
2157: END IF;
2158:
2159: ELSIF (igs_tr_item_rec.sequence_ind = 'N') THEN
2160:
2161: IF NVL(INSTR(l_field_mod,'S'),0) > 0 THEN
2162: IF p_step_completion_ind = 'Y' THEN
2163: -- Validate new value, on error return false

Line 2316: igs_tr_item_pkg.update_row(

2312: RETURN FALSE;
2313: END IF;
2314: CLOSE c_dflt_trk_sts;
2315:
2316: igs_tr_item_pkg.update_row(
2317: x_mode => 'R',
2318: x_rowid => igs_tr_item_rec.row_id,
2319: x_tracking_id => igs_tr_item_rec.tracking_id,
2320: x_tracking_status => l_trk_sts,

Line 2318: x_rowid => igs_tr_item_rec.row_id,

2314: CLOSE c_dflt_trk_sts;
2315:
2316: igs_tr_item_pkg.update_row(
2317: x_mode => 'R',
2318: x_rowid => igs_tr_item_rec.row_id,
2319: x_tracking_id => igs_tr_item_rec.tracking_id,
2320: x_tracking_status => l_trk_sts,
2321: x_tracking_type => igs_tr_item_rec.tracking_type,
2322: x_source_person_id => igs_tr_item_rec.source_person_id,

Line 2319: x_tracking_id => igs_tr_item_rec.tracking_id,

2315:
2316: igs_tr_item_pkg.update_row(
2317: x_mode => 'R',
2318: x_rowid => igs_tr_item_rec.row_id,
2319: x_tracking_id => igs_tr_item_rec.tracking_id,
2320: x_tracking_status => l_trk_sts,
2321: x_tracking_type => igs_tr_item_rec.tracking_type,
2322: x_source_person_id => igs_tr_item_rec.source_person_id,
2323: x_start_dt => igs_tr_item_rec.start_dt,

Line 2321: x_tracking_type => igs_tr_item_rec.tracking_type,

2317: x_mode => 'R',
2318: x_rowid => igs_tr_item_rec.row_id,
2319: x_tracking_id => igs_tr_item_rec.tracking_id,
2320: x_tracking_status => l_trk_sts,
2321: x_tracking_type => igs_tr_item_rec.tracking_type,
2322: x_source_person_id => igs_tr_item_rec.source_person_id,
2323: x_start_dt => igs_tr_item_rec.start_dt,
2324: x_target_days => igs_tr_item_rec.target_days,
2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,

Line 2322: x_source_person_id => igs_tr_item_rec.source_person_id,

2318: x_rowid => igs_tr_item_rec.row_id,
2319: x_tracking_id => igs_tr_item_rec.tracking_id,
2320: x_tracking_status => l_trk_sts,
2321: x_tracking_type => igs_tr_item_rec.tracking_type,
2322: x_source_person_id => igs_tr_item_rec.source_person_id,
2323: x_start_dt => igs_tr_item_rec.start_dt,
2324: x_target_days => igs_tr_item_rec.target_days,
2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,
2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,

Line 2323: x_start_dt => igs_tr_item_rec.start_dt,

2319: x_tracking_id => igs_tr_item_rec.tracking_id,
2320: x_tracking_status => l_trk_sts,
2321: x_tracking_type => igs_tr_item_rec.tracking_type,
2322: x_source_person_id => igs_tr_item_rec.source_person_id,
2323: x_start_dt => igs_tr_item_rec.start_dt,
2324: x_target_days => igs_tr_item_rec.target_days,
2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,
2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,
2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,

Line 2324: x_target_days => igs_tr_item_rec.target_days,

2320: x_tracking_status => l_trk_sts,
2321: x_tracking_type => igs_tr_item_rec.tracking_type,
2322: x_source_person_id => igs_tr_item_rec.source_person_id,
2323: x_start_dt => igs_tr_item_rec.start_dt,
2324: x_target_days => igs_tr_item_rec.target_days,
2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,
2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,
2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,
2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,

Line 2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,

2321: x_tracking_type => igs_tr_item_rec.tracking_type,
2322: x_source_person_id => igs_tr_item_rec.source_person_id,
2323: x_start_dt => igs_tr_item_rec.start_dt,
2324: x_target_days => igs_tr_item_rec.target_days,
2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,
2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,
2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,
2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,
2329: x_override_offset_clc_ind => igs_tr_item_rec.override_offset_clc_ind,

Line 2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,

2322: x_source_person_id => igs_tr_item_rec.source_person_id,
2323: x_start_dt => igs_tr_item_rec.start_dt,
2324: x_target_days => igs_tr_item_rec.target_days,
2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,
2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,
2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,
2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,
2329: x_override_offset_clc_ind => igs_tr_item_rec.override_offset_clc_ind,
2330: x_completion_due_dt => igs_tr_item_rec.completion_due_dt,

Line 2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,

2323: x_start_dt => igs_tr_item_rec.start_dt,
2324: x_target_days => igs_tr_item_rec.target_days,
2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,
2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,
2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,
2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,
2329: x_override_offset_clc_ind => igs_tr_item_rec.override_offset_clc_ind,
2330: x_completion_due_dt => igs_tr_item_rec.completion_due_dt,
2331: x_publish_ind => igs_tr_item_rec.publish_ind

Line 2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,

2324: x_target_days => igs_tr_item_rec.target_days,
2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,
2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,
2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,
2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,
2329: x_override_offset_clc_ind => igs_tr_item_rec.override_offset_clc_ind,
2330: x_completion_due_dt => igs_tr_item_rec.completion_due_dt,
2331: x_publish_ind => igs_tr_item_rec.publish_ind
2332: );

Line 2329: x_override_offset_clc_ind => igs_tr_item_rec.override_offset_clc_ind,

2325: x_sequence_ind => igs_tr_item_rec.sequence_ind,
2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,
2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,
2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,
2329: x_override_offset_clc_ind => igs_tr_item_rec.override_offset_clc_ind,
2330: x_completion_due_dt => igs_tr_item_rec.completion_due_dt,
2331: x_publish_ind => igs_tr_item_rec.publish_ind
2332: );
2333:

Line 2330: x_completion_due_dt => igs_tr_item_rec.completion_due_dt,

2326: x_business_days_ind => igs_tr_item_rec.business_days_ind,
2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,
2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,
2329: x_override_offset_clc_ind => igs_tr_item_rec.override_offset_clc_ind,
2330: x_completion_due_dt => igs_tr_item_rec.completion_due_dt,
2331: x_publish_ind => igs_tr_item_rec.publish_ind
2332: );
2333:
2334: END IF;

Line 2331: x_publish_ind => igs_tr_item_rec.publish_ind

2327: x_originator_person_id => igs_tr_item_rec.originator_person_id,
2328: x_s_created_ind => igs_tr_item_rec.s_created_ind,
2329: x_override_offset_clc_ind => igs_tr_item_rec.override_offset_clc_ind,
2330: x_completion_due_dt => igs_tr_item_rec.completion_due_dt,
2331: x_publish_ind => igs_tr_item_rec.publish_ind
2332: );
2333:
2334: END IF;
2335: CLOSE c_check_item_cmpltn;

Line 2720: p_tracking_status IN IGS_TR_ITEM_V.TRACKING_STATUS%TYPE,

2716: END sync_trk_item_grplmt;
2717:
2718:
2719: FUNCTION validate_completion_status ( p_tracking_id IN IGS_TR_STEP_V.TRACKING_ID%TYPE,
2720: p_tracking_status IN IGS_TR_ITEM_V.TRACKING_STATUS%TYPE,
2721: p_sequence_ind IN IGS_TR_ITEM_V.SEQUENCE_IND%TYPE,
2722: p_message_name OUT NOCOPY VARCHAR2
2723: )
2724: RETURN BOOLEAN

Line 2721: p_sequence_ind IN IGS_TR_ITEM_V.SEQUENCE_IND%TYPE,

2717:
2718:
2719: FUNCTION validate_completion_status ( p_tracking_id IN IGS_TR_STEP_V.TRACKING_ID%TYPE,
2720: p_tracking_status IN IGS_TR_ITEM_V.TRACKING_STATUS%TYPE,
2721: p_sequence_ind IN IGS_TR_ITEM_V.SEQUENCE_IND%TYPE,
2722: p_message_name OUT NOCOPY VARCHAR2
2723: )
2724: RETURN BOOLEAN
2725: IS