APPS.IGS_TR_TYP_STEP_NOTE_PKG dependencies on IGS_TR_TYP_STEP_NOTE

Line 1: PACKAGE BODY igs_tr_typ_step_note_pkg AS

1: PACKAGE BODY igs_tr_typ_step_note_pkg AS
2: /* $Header: IGSTI07B.pls 115.7 2003/01/17 08:39:24 ssawhney ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_typ_step_note%ROWTYPE;

Line 5: old_references igs_tr_typ_step_note%ROWTYPE;

1: PACKAGE BODY igs_tr_typ_step_note_pkg AS
2: /* $Header: IGSTI07B.pls 115.7 2003/01/17 08:39:24 ssawhney ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_typ_step_note%ROWTYPE;
6: new_references igs_tr_typ_step_note%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_typ_step_note%ROWTYPE;

2: /* $Header: IGSTI07B.pls 115.7 2003/01/17 08:39:24 ssawhney ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_typ_step_note%ROWTYPE;
6: new_references igs_tr_typ_step_note%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM igs_tr_typ_step_note

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

Line 123: FROM igs_tr_typ_step_note

119: -- ssawhney, bug 2753353, removed org_id check from PK check cursor
120: -----------------------------------------------------------------------------------------------*/
121: CURSOR cur_rowid IS
122: SELECT ROWID
123: FROM igs_tr_typ_step_note
124: WHERE tracking_type = x_tracking_type
125: AND tracking_type_step_id = x_tracking_type_step_id
126: AND reference_number = x_reference_number
127: -- AND org_id = x_org_id

Line 152: FROM igs_tr_typ_step_note

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

Line 178: FROM igs_tr_typ_step_note

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

Line 208: FROM igs_tr_typ_step_note

204: -- ssawhney, bug 2753353, removed org_id check from FK check cursor
205: -----------------------------------------------------------------------------------------------*/
206: CURSOR cur_rowid IS
207: SELECT ROWID
208: FROM igs_tr_typ_step_note
209: WHERE tracking_type = x_tracking_type
210: AND tracking_type_step_id = x_tracking_type_step_id ;
211: -- AND org_id = x_org_id
212:

Line 366: CURSOR c IS SELECT ROWID FROM igs_tr_typ_step_note

362: ) AS
363: /*----------------------------------------------------------------------------------------------
364: -- ssawhney, bug 2753353, removed org_id check from PK check cursor
365: -----------------------------------------------------------------------------------------------*/
366: CURSOR c IS SELECT ROWID FROM igs_tr_typ_step_note
367: WHERE tracking_type = x_tracking_type
368: AND tracking_type_step_id = x_tracking_type_step_id
369: AND reference_number = x_reference_number;
370: -- AND org_id = x_org_id

Line 410: INSERT INTO igs_tr_typ_step_note (

406: x_last_update_login =>x_last_update_login,
407: x_org_id => x_org_id
408: );
409:
410: INSERT INTO igs_tr_typ_step_note (
411: tracking_type,
412: tracking_type_step_id,
413: reference_number,
414: trk_note_type,

Line 459: FROM igs_tr_typ_step_note

455: ) AS
456:
457: CURSOR c1 IS
458: SELECT trk_note_type
459: FROM igs_tr_typ_step_note
460: WHERE ROWID = x_rowid
461: FOR UPDATE NOWAIT;
462:
463: tlinfo c1%ROWTYPE;

Line 538: UPDATE igs_tr_typ_step_note SET

534: x_last_updated_by =>x_last_updated_by,
535: x_last_update_login =>x_last_update_login
536: );
537:
538: UPDATE igs_tr_typ_step_note SET
539: trk_note_type = new_references.trk_note_type,
540: last_update_date = x_last_update_date,
541: last_updated_by = x_last_updated_by,
542: last_update_login = x_last_update_login

Line 570: FROM igs_tr_typ_step_note

566: -- ssawhney, bug 2753353, removed org_id check from PK check cursor
567: -----------------------------------------------------------------------------------------------*/
568: CURSOR c1 IS
569: SELECT ROWID
570: FROM igs_tr_typ_step_note
571: WHERE tracking_type = x_tracking_type
572: AND tracking_type_step_id = x_tracking_type_step_id
573: AND reference_number = x_reference_number;
574: -- AND org_id = x_org_id;

Line 614: DELETE FROM igs_tr_typ_step_note WHERE ROWID = x_rowid;

610: before_dml(p_action =>'DELETE',
611: x_rowid =>x_rowid
612: );
613:
614: DELETE FROM igs_tr_typ_step_note WHERE ROWID = x_rowid;
615: IF (SQL%NOTFOUND) THEN
616: RAISE no_data_found;
617: END IF;
618:

Line 626: END igs_tr_typ_step_note_pkg;

622: );
623:
624: END delete_row;
625:
626: END igs_tr_typ_step_note_pkg;