APPS.IGS_AD_RECRT_PI_HDR_PKG dependencies on IGS_AD_RECRT_PI_HDR_ALL

Line 5: old_references igs_ad_recrt_pi_hdr_all%ROWTYPE;

1: PACKAGE BODY igs_ad_recrt_pi_hdr_pkg AS
2: /* $Header: IGSAIE7B.pls 115.5 2003/01/23 04:45:54 knag ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_recrt_pi_hdr_all%ROWTYPE;
6: new_references igs_ad_recrt_pi_hdr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_recrt_pi_hdr_all%ROWTYPE;

2: /* $Header: IGSAIE7B.pls 115.5 2003/01/23 04:45:54 knag ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_recrt_pi_hdr_all%ROWTYPE;
6: new_references igs_ad_recrt_pi_hdr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_AD_RECRT_PI_HDR_ALL

27: */
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_AD_RECRT_PI_HDR_ALL
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 84: FROM igs_ad_recrt_pi_hdr_all

80: || (reverse chronological order - newest change first)
81: */
82: CURSOR cur_rowid IS
83: SELECT rowid
84: FROM igs_ad_recrt_pi_hdr_all
85: WHERE prblty_val_batch_id = x_prblty_val_batch_id
86: FOR UPDATE NOWAIT;
87:
88: lv_rowid cur_rowid%RowType;

Line 182: FROM igs_ad_recrt_pi_hdr_all

178: || (reverse chronological order - newest change first)
179: */
180: CURSOR c IS
181: SELECT rowid
182: FROM igs_ad_recrt_pi_hdr_all
183: WHERE prblty_val_batch_id = x_prblty_val_batch_id;
184:
185: x_last_update_date DATE;
186: x_last_updated_by NUMBER;

Line 225: INSERT INTO igs_ad_recrt_pi_hdr_all (

221: x_last_updated_by => x_last_updated_by,
222: x_last_update_login => x_last_update_login
223: );
224:
225: INSERT INTO igs_ad_recrt_pi_hdr_all (
226: prblty_val_batch_id,
227: description,
228: org_id,
229: creation_date,

Line 273: FROM igs_ad_recrt_pi_hdr_all

269: */
270: CURSOR c1 IS
271: SELECT
272: description
273: FROM igs_ad_recrt_pi_hdr_all
274: WHERE rowid = x_rowid
275: FOR UPDATE NOWAIT;
276:
277: tlinfo c1%ROWTYPE;

Line 359: UPDATE igs_ad_recrt_pi_hdr_all

355: x_last_updated_by => x_last_updated_by,
356: x_last_update_login => x_last_update_login
357: );
358:
359: UPDATE igs_ad_recrt_pi_hdr_all
360: SET
361: description = new_references.description,
362: last_update_date = x_last_update_date,
363: last_updated_by = x_last_updated_by,

Line 391: FROM igs_ad_recrt_pi_hdr_all

387: || (reverse chronological order - newest change first)
388: */
389: CURSOR c1 IS
390: SELECT rowid
391: FROM igs_ad_recrt_pi_hdr_all
392: WHERE prblty_val_batch_id = x_prblty_val_batch_id;
393:
394: BEGIN
395:

Line 440: DELETE FROM igs_ad_recrt_pi_hdr_all

436: p_action => 'DELETE',
437: x_rowid => x_rowid
438: );
439:
440: DELETE FROM igs_ad_recrt_pi_hdr_all
441: WHERE rowid = x_rowid;
442:
443: IF (SQL%NOTFOUND) THEN
444: RAISE NO_DATA_FOUND;