APPS.IGS_TR_STEP_NOTE_PKG dependencies on IGS_TR_STEP_NOTE

Line 1: PACKAGE BODY igs_tr_step_note_pkg AS

1: PACKAGE BODY igs_tr_step_note_pkg AS
2: /* $Header: IGSTI04B.pls 115.4 2002/11/29 04:14:34 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_step_note%ROWTYPE;

Line 5: old_references igs_tr_step_note%ROWTYPE;

1: PACKAGE BODY igs_tr_step_note_pkg AS
2: /* $Header: IGSTI04B.pls 115.4 2002/11/29 04:14:34 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_step_note%ROWTYPE;
6: new_references igs_tr_step_note%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_step_note%ROWTYPE;

2: /* $Header: IGSTI04B.pls 115.4 2002/11/29 04:14:34 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_step_note%ROWTYPE;
6: new_references igs_tr_step_note%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM igs_tr_step_note

20: ) AS
21:
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM igs_tr_step_note
25: WHERE ROWID = x_rowid;
26:
27: BEGIN
28:

Line 123: FROM igs_tr_step_note

119: RETURN BOOLEAN AS
120:
121: CURSOR cur_rowid IS
122: SELECT ROWID
123: FROM igs_tr_step_note
124: WHERE tracking_id = x_tracking_id
125: AND tracking_step_id = x_tracking_step_id
126: AND reference_number = x_reference_number
127: FOR UPDATE NOWAIT;

Line 151: FROM igs_tr_step_note

147: ) AS
148:
149: CURSOR cur_rowid IS
150: SELECT ROWID
151: FROM igs_tr_step_note
152: WHERE reference_number = x_reference_number ;
153:
154: lv_rowid cur_rowid%ROWTYPE;
155:

Line 177: FROM igs_tr_step_note

173: ) AS
174:
175: CURSOR cur_rowid IS
176: SELECT ROWID
177: FROM igs_tr_step_note
178: WHERE trk_note_type = x_trk_note_type ;
179:
180: lv_rowid cur_rowid%ROWTYPE;
181:

Line 205: FROM igs_tr_step_note

201: ) AS
202:
203: CURSOR cur_rowid IS
204: SELECT ROWID
205: FROM igs_tr_step_note
206: WHERE tracking_id = x_tracking_id
207: AND tracking_step_id = x_tracking_step_id ;
208:
209: lv_rowid cur_rowid%ROWTYPE;

Line 350: FROM igs_tr_step_note

346: ) AS
347:
348: CURSOR c IS
349: SELECT ROWID
350: FROM igs_tr_step_note
351: WHERE tracking_id = x_tracking_id
352: AND tracking_step_id = x_tracking_step_id
353: AND reference_number = x_reference_number;
354:

Line 395: INSERT INTO igs_tr_step_note (

391: x_last_updated_by =>x_last_updated_by,
392: x_last_update_login =>x_last_update_login
393: );
394:
395: INSERT INTO igs_tr_step_note (
396: tracking_id,
397: tracking_step_id,
398: reference_number,
399: trk_note_type,

Line 443: FROM igs_tr_step_note

439: ) AS
440:
441: CURSOR c1 IS
442: SELECT trk_note_type
443: FROM igs_tr_step_note
444: WHERE ROWID = x_rowid
445: FOR UPDATE NOWAIT;
446: tlinfo c1%ROWTYPE;
447:

Line 520: UPDATE igs_tr_step_note SET

516: x_last_updated_by =>x_last_updated_by,
517: x_last_update_login =>x_last_update_login
518: );
519:
520: UPDATE igs_tr_step_note SET
521: trk_note_type = new_references.trk_note_type,
522: last_update_date = x_last_update_date,
523: last_updated_by = x_last_updated_by,
524: last_update_login = x_last_update_login

Line 549: FROM igs_tr_step_note

545: ) AS
546:
547: CURSOR c1 IS
548: SELECT ROWID
549: FROM igs_tr_step_note
550: WHERE tracking_id = x_tracking_id
551: AND tracking_step_id = x_tracking_step_id
552: AND reference_number = x_reference_number;
553:

Line 592: DELETE FROM igs_tr_step_note WHERE ROWID = x_rowid;

588: before_dml(p_action =>'DELETE',
589: x_rowid =>x_rowid
590: );
591:
592: DELETE FROM igs_tr_step_note WHERE ROWID = x_rowid;
593: IF (SQL%NOTFOUND) THEN
594: RAISE no_data_found;
595: END IF;
596:

Line 604: END igs_tr_step_note_pkg;

600: );
601:
602: END delete_row;
603:
604: END igs_tr_step_note_pkg;