APPS.IGS_AD_APCTR_RU_PKG dependencies on IGS_AD_APCTR_RU_ALL

Line 5: old_references igs_ad_apctr_ru_all%ROWTYPE;

1: PACKAGE BODY igs_ad_apctr_ru_pkg AS
2: /* $Header: IGSAIF0B.pls 115.8 2003/10/30 13:26:02 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_apctr_ru_all%ROWTYPE;
6: new_references igs_ad_apctr_ru_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_apctr_ru_all%ROWTYPE;

2: /* $Header: IGSAIF0B.pls 115.8 2003/10/30 13:26:02 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_apctr_ru_all%ROWTYPE;
6: new_references igs_ad_apctr_ru_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_AD_APCTR_RU_ALL

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_AD_APCTR_RU_ALL
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 141: FROM IGS_AD_APCTR_RU_ALL

137: ) as
138:
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM IGS_AD_APCTR_RU_ALL
142: WHERE admission_cat = x_admission_cat;
143:
144: lv_rowid cur_rowid%RowType;
145:

Line 167: FROM IGS_AD_APCTR_RU_ALL

163: ) as
164:
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM IGS_AD_APCTR_RU_ALL
168: WHERE rul_sequence_number = x_rul_sequence_number;
169:
170: lv_rowid cur_rowid%RowType;
171:

Line 201: FROM igs_ad_apctr_ru_all

197: || (reverse chronological order - newest change first)
198: */
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM igs_ad_apctr_ru_all
202: WHERE apc_trk_ru_id = x_apc_trk_ru_id
203: FOR UPDATE NOWAIT;
204:
205: lv_rowid cur_rowid%RowType;

Line 310: FROM igs_ad_apctr_ru_all

306: || (reverse chronological order - newest change first)
307: */
308: CURSOR c IS
309: SELECT rowid
310: FROM igs_ad_apctr_ru_all
311: WHERE apc_trk_ru_id = x_apc_trk_ru_id;
312:
313: x_last_update_date DATE;
314: x_last_updated_by NUMBER;

Line 356: INSERT INTO igs_ad_apctr_ru_all (

352: x_last_updated_by => x_last_updated_by,
353: x_last_update_login => x_last_update_login
354: );
355:
356: INSERT INTO igs_ad_apctr_ru_all (
357: apc_trk_ru_id,
358: admission_cat,
359: s_admission_process_type,
360: s_rule_call_cd,

Line 416: FROM igs_ad_apctr_ru_all

412: admission_cat,
413: s_admission_process_type,
414: s_rule_call_cd,
415: rul_sequence_number
416: FROM igs_ad_apctr_ru_all
417: WHERE rowid = x_rowid
418: FOR UPDATE NOWAIT;
419:
420: tlinfo c1%ROWTYPE;

Line 511: UPDATE igs_ad_apctr_ru_all

507: x_last_updated_by => x_last_updated_by,
508: x_last_update_login => x_last_update_login
509: );
510:
511: UPDATE igs_ad_apctr_ru_all
512: SET
513: admission_cat = new_references.admission_cat,
514: s_admission_process_type = new_references.s_admission_process_type,
515: s_rule_call_cd = new_references.s_rule_call_cd,

Line 549: FROM igs_ad_apctr_ru_all

545: || (reverse chronological order - newest change first)
546: */
547: CURSOR c1 IS
548: SELECT rowid
549: FROM igs_ad_apctr_ru_all
550: WHERE apc_trk_ru_id = x_apc_trk_ru_id;
551:
552: BEGIN
553:

Line 604: DELETE FROM igs_ad_apctr_ru_all

600: p_action => 'DELETE',
601: x_rowid => x_rowid
602: );
603:
604: DELETE FROM igs_ad_apctr_ru_all
605: WHERE rowid = x_rowid;
606:
607: IF (SQL%NOTFOUND) THEN
608: RAISE NO_DATA_FOUND;