APPS.IGS_TR_GROUP_NOTE_PKG dependencies on IGS_TR_GROUP_NOTE

Line 1: PACKAGE BODY igs_tr_group_note_pkg AS

1: PACKAGE BODY igs_tr_group_note_pkg AS
2: /* $Header: IGSTI11B.pls 115.5 2002/11/29 04:16:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_group_note%ROWTYPE;

Line 5: old_references igs_tr_group_note%ROWTYPE;

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

Line 6: new_references igs_tr_group_note%ROWTYPE;

2: /* $Header: IGSTI11B.pls 115.5 2002/11/29 04:16:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_group_note%ROWTYPE;
6: new_references igs_tr_group_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_group_note

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

Line 135: FROM igs_tr_group_note

131: RETURN BOOLEAN AS
132:
133: CURSOR cur_rowid IS
134: SELECT ROWID
135: FROM igs_tr_group_note
136: WHERE tracking_group_id = x_tracking_group_id
137: AND reference_number = x_reference_number
138: FOR UPDATE NOWAIT;
139:

Line 163: FROM igs_tr_group_note

159: ) AS
160:
161: CURSOR cur_rowid IS
162: SELECT ROWID
163: FROM igs_tr_group_note
164: WHERE reference_number = x_reference_number ;
165:
166: lv_rowid cur_rowid%ROWTYPE;
167:

Line 189: FROM igs_tr_group_note

185: ) AS
186:
187: CURSOR cur_rowid IS
188: SELECT ROWID
189: FROM igs_tr_group_note
190: WHERE tracking_group_id = x_tracking_group_id ;
191:
192: lv_rowid cur_rowid%ROWTYPE;
193:

Line 215: FROM igs_tr_group_note

211: ) AS
212:
213: CURSOR cur_rowid IS
214: SELECT ROWID
215: FROM igs_tr_group_note
216: WHERE trk_note_type = x_trk_note_type ;
217:
218: lv_rowid cur_rowid%ROWTYPE;
219:

Line 309: FROM igs_tr_group_note

305: ) AS
306:
307: CURSOR c IS
308: SELECT ROWID
309: FROM igs_tr_group_note
310: WHERE tracking_group_id = x_tracking_group_id
311: AND reference_number = x_reference_number;
312:
313: x_last_update_date DATE;

Line 352: INSERT INTO igs_tr_group_note (

348: x_last_updated_by => x_last_updated_by,
349: x_last_update_login => x_last_update_login
350: );
351:
352: INSERT INTO igs_tr_group_note (
353: tracking_group_id,
354: reference_number,
355: trk_note_type,
356: creation_date,

Line 396: FROM igs_tr_group_note

392: ) AS
393:
394: CURSOR c1 IS
395: SELECT trk_note_type
396: FROM igs_tr_group_note
397: WHERE ROWID = x_rowid
398: FOR UPDATE NOWAIT;
399:
400: tlinfo c1%ROWTYPE;

Line 473: UPDATE igs_tr_group_note SET

469: x_last_updated_by => x_last_updated_by,
470: x_last_update_login => x_last_update_login
471: );
472:
473: UPDATE igs_tr_group_note SET
474: trk_note_type = new_references.trk_note_type,
475: last_update_date = x_last_update_date,
476: last_updated_by = x_last_updated_by,
477: last_update_login = x_last_update_login

Line 501: FROM igs_tr_group_note

497: ) AS
498:
499: CURSOR c1 IS
500: SELECT ROWID
501: FROM igs_tr_group_note
502: WHERE tracking_group_id = x_tracking_group_id
503: AND reference_number = x_reference_number;
504:
505: BEGIN

Line 542: DELETE FROM igs_tr_group_note WHERE ROWID = x_rowid;

538: p_action =>'DELETE',
539: x_rowid => x_rowid
540: );
541:
542: DELETE FROM igs_tr_group_note WHERE ROWID = x_rowid;
543: IF (SQL%NOTFOUND) THEN
544: RAISE no_data_found;
545: END IF;
546:

Line 553: END igs_tr_group_note_pkg;

549: x_rowid => x_rowid
550: );
551: END delete_row;
552:
553: END igs_tr_group_note_pkg;