APPS.IGS_AD_ADMDE_INT_PKG dependencies on IGS_AD_ADMDE_INT_ALL

Line 5: old_references igs_ad_admde_int_all%ROWTYPE;

1: PACKAGE BODY igs_ad_admde_int_pkg AS
2: /* $Header: IGSAIE9B.pls 115.10 2003/12/15 11:55:38 rboddu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_admde_int_all%ROWTYPE;
6: new_references igs_ad_admde_int_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_admde_int_all%ROWTYPE;

2: /* $Header: IGSAIE9B.pls 115.10 2003/12/15 11:55:38 rboddu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_admde_int_all%ROWTYPE;
6: new_references igs_ad_admde_int_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 48: FROM IGS_AD_ADMDE_INT_ALL

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

Line 109: FROM IGS_AD_ADMDE_INT_ALL

105: ) RETURN BOOLEAN AS
106:
107: CURSOR cur_rowid IS
108: SELECT rowid
109: FROM IGS_AD_ADMDE_INT_ALL
110: WHERE interface_mkdes_id = x_interface_mkdes_id
111: FOR UPDATE NOWAIT;
112: lv_rowid cur_rowid%RowType;
113:

Line 256: FROM igs_ad_admde_int_all

252: || (reverse chronological order - newest change first)
253: */
254: CURSOR c IS
255: SELECT rowid
256: FROM igs_ad_admde_int_all
257: WHERE interface_mkdes_id = x_interface_mkdes_id;
258:
259: x_last_update_date DATE;
260: x_last_updated_by NUMBER;

Line 332: INSERT INTO igs_ad_admde_int_all (

328: x_prpsd_commencement_date => x_prpsd_commencement_date,
329: x_error_text => x_error_text
330: );
331:
332: INSERT INTO igs_ad_admde_int_all (
333: interface_mkdes_id,
334: interface_run_id,
335: batch_id,
336: person_id,

Line 457: FROM igs_ad_admde_int_all

453: error_code,
454: reconsider_flag,
455: prpsd_commencement_date,
456: error_text
457: FROM igs_ad_admde_int_all
458: WHERE rowid = x_rowid
459: FOR UPDATE NOWAIT;
460:
461: tlinfo c1%ROWTYPE;

Line 613: UPDATE igs_ad_admde_int_all

609: x_program_update_date := SYSDATE;
610: END IF;
611: END IF;
612:
613: UPDATE igs_ad_admde_int_all
614: SET
615: interface_mkdes_id = new_references.interface_mkdes_id,
616: interface_run_id = new_references.interface_run_id,
617: batch_id = new_references.batch_id,

Line 684: FROM igs_ad_admde_int_all

680: || (reverse chronological order - newest change first)
681: */
682: CURSOR c1 IS
683: SELECT rowid
684: FROM igs_ad_admde_int_all
685: WHERE interface_mkdes_id= x_interface_mkdes_id;
686:
687: BEGIN
688:

Line 767: DELETE FROM igs_ad_admde_int_all

763: p_action => 'DELETE',
764: x_rowid => x_rowid
765: );
766:
767: DELETE FROM igs_ad_admde_int_all
768: WHERE rowid = x_rowid;
769:
770: IF (SQL%NOTFOUND) THEN
771: RAISE NO_DATA_FOUND;