APPS.IGS_UC_APP_STATS_PKG dependencies on IGS_UC_APP_STATS

Line 1: PACKAGE BODY igs_uc_app_stats_pkg AS

1: PACKAGE BODY igs_uc_app_stats_pkg AS
2: /* $Header: IGSXI07B.pls 115.10 2003/06/11 10:29:43 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_stats%ROWTYPE;

Line 5: old_references igs_uc_app_stats%ROWTYPE;

1: PACKAGE BODY igs_uc_app_stats_pkg AS
2: /* $Header: IGSXI07B.pls 115.10 2003/06/11 10:29:43 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_stats%ROWTYPE;
6: new_references igs_uc_app_stats%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_app_stats%ROWTYPE;

2: /* $Header: IGSXI07B.pls 115.10 2003/06/11 10:29:43 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_stats%ROWTYPE;
6: new_references igs_uc_app_stats%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 56: FROM IGS_UC_APP_STATS

52: */
53:
54: CURSOR cur_old_ref_values IS
55: SELECT *
56: FROM IGS_UC_APP_STATS
57: WHERE rowid = x_rowid;
58:
59: BEGIN
60:

Line 182: FROM igs_uc_app_stats

178: || (reverse chronological order - newest change first)
179: */
180: CURSOR cur_rowid IS
181: SELECT rowid
182: FROM igs_uc_app_stats
183: WHERE app_stat_id = x_app_stat_id ;
184:
185: lv_rowid cur_rowid%RowType;
186:

Line 216: FROM igs_uc_app_stats

212: || (reverse chronological order - newest change first)
213: */
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM igs_uc_app_stats
217: WHERE app_no = x_app_no
218: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
219:
220: lv_rowid cur_rowid%RowType;

Line 251: FROM igs_uc_app_stats

247: || (reverse chronological order - newest change first)
248: */
249: CURSOR cur_rowid IS
250: SELECT rowid
251: FROM igs_uc_app_stats
252: WHERE ((app_id = x_app_id));
253:
254: lv_rowid cur_rowid%RowType;
255:

Line 430: FROM igs_uc_app_stats

426: || (reverse chronological order - newest change first)
427: */
428: CURSOR c IS
429: SELECT rowid
430: FROM igs_uc_app_stats
431: WHERE app_stat_id = x_app_stat_id;
432:
433: x_last_update_date DATE;
434: x_last_updated_by NUMBER;

Line 458: SELECT igs_uc_app_stats_s.NEXTVAL

454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:
458: SELECT igs_uc_app_stats_s.NEXTVAL
459: INTO x_app_stat_id
460: FROM dual;
461:
462: before_dml(

Line 496: INSERT INTO igs_uc_app_stats (

492: x_ivstarx_dependants => x_ivstarx_dependants,
493: x_ivstarx_married => x_ivstarx_married
494: );
495:
496: INSERT INTO igs_uc_app_stats (
497: app_stat_id,
498: app_id,
499: app_no,
500: starh_ethnic,

Line 633: FROM igs_uc_app_stats

629: ivstarh_married,
630: ivstarx_religion,
631: ivstarx_dependants,
632: ivstarx_married
633: FROM igs_uc_app_stats
634: WHERE rowid = x_rowid
635: FOR UPDATE NOWAIT;
636:
637: tlinfo c1%ROWTYPE;

Line 788: UPDATE igs_uc_app_stats

784: x_ivstarx_dependants => x_ivstarx_dependants,
785: x_ivstarx_married => x_ivstarx_married
786: );
787:
788: UPDATE igs_uc_app_stats
789: SET
790: app_id = new_references.app_id,
791: app_no = new_references.app_no,
792: starh_ethnic = new_references.starh_ethnic,

Line 868: FROM igs_uc_app_stats

864: || (reverse chronological order - newest change first)
865: */
866: CURSOR c1 IS
867: SELECT rowid
868: FROM igs_uc_app_stats
869: WHERE app_stat_id = x_app_stat_id;
870:
871: BEGIN
872:

Line 961: DELETE FROM igs_uc_app_stats

957: p_action => 'DELETE',
958: x_rowid => x_rowid
959: );
960:
961: DELETE FROM igs_uc_app_stats
962: WHERE rowid = x_rowid;
963:
964: IF (SQL%NOTFOUND) THEN
965: RAISE NO_DATA_FOUND;

Line 971: END igs_uc_app_stats_pkg;

967:
968: END delete_row;
969:
970:
971: END igs_uc_app_stats_pkg;