APPS.IGS_UC_WRONG_APP_PKG dependencies on IGS_UC_WRONG_APP

Line 1: PACKAGE BODY igs_uc_wrong_app_pkg AS

1: PACKAGE BODY igs_uc_wrong_app_pkg AS
2: /* $Header: IGSXI34B.pls 115.8 2003/07/30 10:41:04 ayedubat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_wrong_app%ROWTYPE;

Line 5: old_references igs_uc_wrong_app%ROWTYPE;

1: PACKAGE BODY igs_uc_wrong_app_pkg AS
2: /* $Header: IGSXI34B.pls 115.8 2003/07/30 10:41:04 ayedubat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_wrong_app%ROWTYPE;
6: new_references igs_uc_wrong_app%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_wrong_app%ROWTYPE;

2: /* $Header: IGSXI34B.pls 115.8 2003/07/30 10:41:04 ayedubat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_wrong_app%ROWTYPE;
6: new_references igs_uc_wrong_app%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 46: FROM IGS_UC_WRONG_APP

42: */
43:
44: CURSOR cur_old_ref_values IS
45: SELECT *
46: FROM IGS_UC_WRONG_APP
47: WHERE rowid = x_rowid;
48:
49: BEGIN
50:

Line 139: FROM igs_uc_wrong_app

135: || (reverse chronological order - newest change first)
136: */
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM igs_uc_wrong_app
140: WHERE app_no = x_app_no ;
141:
142: lv_rowid cur_rowid%RowType;
143:

Line 173: FROM igs_uc_wrong_app

169: || (reverse chronological order - newest change first)
170: */
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM igs_uc_wrong_app
174: WHERE wrong_app_id = x_wrong_app_id
175: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
176:
177: lv_rowid cur_rowid%RowType;

Line 323: FROM igs_uc_wrong_app

319: || (reverse chronological order - newest change first)
320: */
321: CURSOR c IS
322: SELECT rowid
323: FROM igs_uc_wrong_app
324: WHERE app_no = x_app_no;
325:
326: x_last_update_date DATE;
327: x_last_updated_by NUMBER;

Line 351: SELECT igs_uc_wrong_app_s.NEXTVAL

347: igs_ge_msg_stack.add;
348: app_exception.raise_exception;
349: END IF;
350:
351: SELECT igs_uc_wrong_app_s.NEXTVAL
352: INTO x_wrong_app_id
353: FROM dual;
354:
355: before_dml(

Line 382: INSERT INTO igs_uc_wrong_app (

378: x_choice6_lost => x_choice6_lost ,
379: x_choice7_lost => x_choice7_lost
380: );
381:
382: INSERT INTO igs_uc_wrong_app (
383: wrong_app_id,
384: app_no,
385: miscoded,
386: cancelled,

Line 488: FROM igs_uc_wrong_app

484: choice4_lost ,
485: choice5_lost ,
486: choice6_lost ,
487: choice7_lost
488: FROM igs_uc_wrong_app
489: WHERE rowid = x_rowid
490: FOR UPDATE NOWAIT;
491:
492: tlinfo c1%ROWTYPE;

Line 619: UPDATE igs_uc_wrong_app

615: x_choice6_lost => x_choice6_lost ,
616: x_choice7_lost => x_choice7_lost
617: );
618:
619: UPDATE igs_uc_wrong_app
620: SET
621: wrong_app_id = new_references.wrong_app_id,
622: miscoded = new_references.miscoded,
623: cancelled = new_references.cancelled,

Line 681: FROM igs_uc_wrong_app

677: || (reverse chronological order - newest change first)
678: */
679: CURSOR c1 IS
680: SELECT rowid
681: FROM igs_uc_wrong_app
682: WHERE app_no = x_app_no;
683:
684: BEGIN
685:

Line 760: DELETE FROM igs_uc_wrong_app

756: p_action => 'DELETE',
757: x_rowid => x_rowid
758: );
759:
760: DELETE FROM igs_uc_wrong_app
761: WHERE rowid = x_rowid;
762:
763: IF (SQL%NOTFOUND) THEN
764: RAISE NO_DATA_FOUND;

Line 770: END igs_uc_wrong_app_pkg;

766:
767: END delete_row;
768:
769:
770: END igs_uc_wrong_app_pkg;