APPS.IGS_UC_EXP_QUAL_SUM_PKG dependencies on IGS_UC_EXP_QUAL_SUM

Line 1: PACKAGE BODY igs_uc_exp_qual_sum_pkg AS

1: PACKAGE BODY igs_uc_exp_qual_sum_pkg AS
2: /* $Header: IGSXI36B.pls 115.6 2003/02/28 07:50:39 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_exp_qual_sum%ROWTYPE;

Line 5: old_references igs_uc_exp_qual_sum%ROWTYPE;

1: PACKAGE BODY igs_uc_exp_qual_sum_pkg AS
2: /* $Header: IGSXI36B.pls 115.6 2003/02/28 07:50:39 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_exp_qual_sum%ROWTYPE;
6: new_references igs_uc_exp_qual_sum%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_exp_qual_sum%ROWTYPE;

2: /* $Header: IGSXI36B.pls 115.6 2003/02/28 07:50:39 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_exp_qual_sum%ROWTYPE;
6: new_references igs_uc_exp_qual_sum%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 48: FROM IGS_UC_EXP_QUAL_SUM

44: */
45:
46: CURSOR cur_old_ref_values IS
47: SELECT *
48: FROM IGS_UC_EXP_QUAL_SUM
49: WHERE rowid = x_rowid;
50:
51: BEGIN
52:

Line 146: FROM igs_uc_exp_qual_sum

142: || (reverse chronological order - newest change first)
143: */
144: CURSOR cur_rowid IS
145: SELECT rowid
146: FROM igs_uc_exp_qual_sum
147: WHERE exp_qual_sum_id = x_exp_qual_sum_id ;
148:
149: lv_rowid cur_rowid%RowType;
150:

Line 182: FROM igs_uc_exp_qual_sum

178: || get_fk_igs_pe_person w.r.t. Bug 2541370.
179: */
180: CURSOR cur_rowid IS
181: SELECT rowid
182: FROM igs_uc_exp_qual_sum
183: WHERE ((person_id = x_person_id));
184:
185: lv_rowid cur_rowid%RowType;
186:

Line 335: FROM igs_uc_exp_qual_sum

331: || (reverse chronological order - newest change first)
332: */
333: CURSOR c IS
334: SELECT rowid
335: FROM igs_uc_exp_qual_sum
336: WHERE exp_qual_sum_id = x_exp_qual_sum_id;
337:
338: x_last_update_date DATE;
339: x_last_updated_by NUMBER;

Line 363: SELECT igs_uc_exp_qual_sum_s.NEXTVAL

359: igs_ge_msg_stack.add;
360: app_exception.raise_exception;
361: END IF;
362:
363: SELECT igs_uc_exp_qual_sum_s.NEXTVAL
364: INTO x_exp_qual_sum_id
365: FROM dual;
366:
367: before_dml(

Line 396: INSERT INTO igs_uc_exp_qual_sum (

392: x_last_updated_by => x_last_updated_by,
393: x_last_update_login => x_last_update_login
394: );
395:
396: INSERT INTO igs_uc_exp_qual_sum (
397: exp_qual_sum_id,
398: person_id,
399: exp_gce,
400: exp_vce,

Line 510: FROM igs_uc_exp_qual_sum

506: oeq,
507: prev_oeq,
508: vqi,
509: seq_updated_date
510: FROM igs_uc_exp_qual_sum
511: WHERE rowid = x_rowid
512: FOR UPDATE NOWAIT;
513:
514: tlinfo c1%ROWTYPE;

Line 647: UPDATE igs_uc_exp_qual_sum

643: x_last_updated_by => x_last_updated_by,
644: x_last_update_login => x_last_update_login
645: );
646:
647: UPDATE igs_uc_exp_qual_sum
648: SET
649: person_id = new_references.person_id,
650: exp_gce = new_references.exp_gce,
651: exp_vce = new_references.exp_vce,

Line 713: FROM igs_uc_exp_qual_sum

709: || (reverse chronological order - newest change first)
710: */
711: CURSOR c1 IS
712: SELECT rowid
713: FROM igs_uc_exp_qual_sum
714: WHERE exp_qual_sum_id = x_exp_qual_sum_id;
715:
716: BEGIN
717:

Line 796: DELETE FROM igs_uc_exp_qual_sum

792: p_action => 'DELETE',
793: x_rowid => x_rowid
794: );
795:
796: DELETE FROM igs_uc_exp_qual_sum
797: WHERE rowid = x_rowid;
798:
799: IF (SQL%NOTFOUND) THEN
800: RAISE NO_DATA_FOUND;

Line 806: END igs_uc_exp_qual_sum_pkg;

802:
803: END delete_row;
804:
805:
806: END igs_uc_exp_qual_sum_pkg;