APPS.IGS_TR_ITEM_NOTE_PKG dependencies on IGS_TR_ITEM_NOTE

Line 1: PACKAGE BODY igs_tr_item_note_pkg AS

1: PACKAGE BODY igs_tr_item_note_pkg AS
2: /* $Header: IGSTI01B.pls 115.5 2002/11/29 04:13:42 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_item_note%ROWTYPE;

Line 5: old_references igs_tr_item_note%ROWTYPE;

1: PACKAGE BODY igs_tr_item_note_pkg AS
2: /* $Header: IGSTI01B.pls 115.5 2002/11/29 04:13:42 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_item_note%ROWTYPE;
6: new_references igs_tr_item_note%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_item_note%ROWTYPE;

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

Line 23: FROM igs_tr_item_note

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

Line 63: -- "TRG_TIN_BR_IUD" BEFORE INSERT OR DELETE OR UPDATE ON OSS_TST.IGS_TR_ITEM_NOTE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW

59:
60: END set_column_values;
61:
62: -- Trigger description :-
63: -- "TRG_TIN_BR_IUD" BEFORE INSERT OR DELETE OR UPDATE ON OSS_TST.IGS_TR_ITEM_NOTE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW
64:
65: PROCEDURE beforerowinsertupdatedelete1(
66: p_inserting IN BOOLEAN DEFAULT FALSE,
67: p_updating IN BOOLEAN DEFAULT FALSE,

Line 143: FROM igs_tr_item_note

139: ) RETURN BOOLEAN AS
140:
141: CURSOR cur_rowid IS
142: SELECT ROWID
143: FROM igs_tr_item_note
144: WHERE tracking_id = x_tracking_id
145: AND reference_number = x_reference_number
146: FOR UPDATE NOWAIT;
147:

Line 170: FROM igs_tr_item_note

166: ) AS
167:
168: CURSOR cur_rowid IS
169: SELECT ROWID
170: FROM igs_tr_item_note
171: WHERE reference_number = x_reference_number ;
172:
173: lv_rowid cur_rowid%ROWTYPE;
174:

Line 196: FROM igs_tr_item_note

192: ) AS
193:
194: CURSOR cur_rowid IS
195: SELECT ROWID
196: FROM igs_tr_item_note
197: WHERE trk_note_type = x_trk_note_type ;
198:
199: lv_rowid cur_rowid%ROWTYPE;
200:

Line 222: FROM igs_tr_item_note

218: ) AS
219:
220: CURSOR cur_rowid IS
221: SELECT ROWID
222: FROM igs_tr_item_note
223: WHERE tracking_id = x_tracking_id ;
224:
225: lv_rowid cur_rowid%ROWTYPE;
226:

Line 325: FROM igs_tr_item_note

321: ) AS
322:
323: CURSOR c IS
324: SELECT ROWID
325: FROM igs_tr_item_note
326: WHERE tracking_id = x_tracking_id
327: AND reference_number = x_reference_number;
328:
329: x_last_update_date DATE;

Line 368: INSERT INTO igs_tr_item_note (

364: x_last_updated_by => x_last_updated_by,
365: x_last_update_login => x_last_update_login
366: );
367:
368: INSERT INTO igs_tr_item_note (
369: tracking_id,
370: reference_number,
371: trk_note_type,
372: creation_date,

Line 412: FROM igs_tr_item_note

408: ) AS
409:
410: CURSOR c1 IS
411: SELECT trk_note_type
412: FROM igs_tr_item_note
413: WHERE ROWID = x_rowid
414: FOR UPDATE NOWAIT;
415:
416: tlinfo c1%ROWTYPE;

Line 489: UPDATE igs_tr_item_note SET

485: x_last_updated_by => x_last_updated_by,
486: x_last_update_login => x_last_update_login
487: );
488:
489: UPDATE igs_tr_item_note SET
490: trk_note_type = new_references.trk_note_type,
491: last_update_date = x_last_update_date,
492: last_updated_by = x_last_updated_by,
493: last_update_login = x_last_update_login

Line 517: FROM igs_tr_item_note

513: ) AS
514:
515: CURSOR c1 IS
516: SELECT ROWID
517: FROM igs_tr_item_note
518: WHERE tracking_id = x_tracking_id
519: AND reference_number = x_reference_number;
520:
521: BEGIN

Line 560: DELETE FROM igs_tr_item_note

556: p_action =>'DELETE',
557: x_rowid => x_rowid
558: );
559:
560: DELETE FROM igs_tr_item_note
561: WHERE ROWID = x_rowid;
562:
563: IF (SQL%NOTFOUND) THEN
564: RAISE no_data_found;

Line 574: END igs_tr_item_note_pkg;

570: );
571:
572: END delete_row;
573:
574: END igs_tr_item_note_pkg;