APPS.IGS_TR_STATUS_PKG dependencies on IGS_TR_STATUS

Line 1: PACKAGE BODY igs_tr_status_pkg AS

1: PACKAGE BODY igs_tr_status_pkg AS
2: /* $Header: IGSTI02B.pls 115.8 2003/02/20 06:04:57 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_status%ROWTYPE;

Line 5: old_references igs_tr_status%ROWTYPE;

1: PACKAGE BODY igs_tr_status_pkg AS
2: /* $Header: IGSTI02B.pls 115.8 2003/02/20 06:04:57 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_status%ROWTYPE;
6: new_references igs_tr_status%ROWTYPE;
7:
8: /*******************************************************************************
9: Created by : Oracle IDC

Line 6: new_references igs_tr_status%ROWTYPE;

2: /* $Header: IGSTI02B.pls 115.8 2003/02/20 06:04:57 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_status%ROWTYPE;
6: new_references igs_tr_status%ROWTYPE;
7:
8: /*******************************************************************************
9: Created by : Oracle IDC
10: Date created:

Line 43: FROM igs_tr_status

39: ) AS
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM igs_tr_status
44: WHERE ROWID = x_rowid;
45:
46: BEGIN
47:

Line 91: FROM igs_tr_status

87: RETURN BOOLEAN AS
88:
89: CURSOR cur_rowid IS
90: SELECT ROWID
91: FROM igs_tr_status
92: WHERE tracking_status = x_tracking_status;
93:
94: lv_rowid cur_rowid%ROWTYPE;
95:

Line 306: FROM igs_tr_status

302: ) AS
303:
304: CURSOR c IS
305: SELECT ROWID
306: FROM igs_tr_status
307: WHERE tracking_status = x_tracking_status;
308: x_last_update_date DATE;
309: x_last_updated_by NUMBER;
310: x_last_update_login NUMBER;

Line 350: INSERT INTO igs_tr_status (

346: x_last_update_login =>x_last_update_login,
347: x_default_ind => NVL(x_default_ind,'N')
348: );
349:
350: INSERT INTO igs_tr_status (
351: tracking_status,
352: description,
353: s_tracking_status,
354: closed_ind,

Line 417: FROM igs_tr_status

413: x_default_ind IN VARCHAR2 DEFAULT 'N'
414: ) AS
415: CURSOR c1 IS
416: SELECT description,s_tracking_status,closed_ind
417: FROM igs_tr_status
418: WHERE ROWID = x_rowid
419: FOR UPDATE NOWAIT;
420: tlinfo c1%ROWTYPE;
421:

Line 518: UPDATE igs_tr_status SET

514: x_last_update_login =>x_last_update_login,
515: x_default_ind => x_default_ind
516: );
517:
518: UPDATE igs_tr_status SET
519: description = new_references.description,
520: s_tracking_status = new_references.s_tracking_status,
521: closed_ind = new_references.closed_ind,
522: last_update_date = x_last_update_date,

Line 567: FROM igs_tr_status

563: x_default_ind IN VARCHAR2 DEFAULT 'N'
564: ) AS
565: CURSOR c1 IS
566: SELECT ROWID
567: FROM igs_tr_status
568: WHERE tracking_status = x_tracking_status;
569:
570: BEGIN
571:

Line 600: END igs_tr_status_pkg;

596: x_default_ind);
597:
598: END add_row;
599:
600: END igs_tr_status_pkg;