APPS.IGS_UC_COM_SCHSITES_PKG dependencies on IGS_UC_COM_SCHSITES

Line 1: PACKAGE BODY igs_uc_com_schsites_pkg AS

1: PACKAGE BODY igs_uc_com_schsites_pkg AS
2: /* $Header: IGSXI11B.pls 115.7 2003/06/11 10:34:08 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_com_schsites%ROWTYPE;

Line 5: old_references igs_uc_com_schsites%ROWTYPE;

1: PACKAGE BODY igs_uc_com_schsites_pkg AS
2: /* $Header: IGSXI11B.pls 115.7 2003/06/11 10:34:08 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_com_schsites%ROWTYPE;
6: new_references igs_uc_com_schsites%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_com_schsites%ROWTYPE;

2: /* $Header: IGSXI11B.pls 115.7 2003/06/11 10:34:08 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_com_schsites%ROWTYPE;
6: new_references igs_uc_com_schsites%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 42: FROM IGS_UC_COM_SCHSITES

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGS_UC_COM_SCHSITES
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 129: igs_uc_com_scsicnts_pkg.get_fk_igs_uc_com_schsites (

125: || (reverse chronological order - newest change first)
126: */
127: BEGIN
128:
129: igs_uc_com_scsicnts_pkg.get_fk_igs_uc_com_schsites (
130: old_references.school,
131: old_references.sitecode
132: );
133:

Line 152: FROM igs_uc_com_schsites

148: || (reverse chronological order - newest change first)
149: */
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM igs_uc_com_schsites
153: WHERE school = x_school
154: AND sitecode = x_sitecode ;
155:
156: lv_rowid cur_rowid%RowType;

Line 187: FROM igs_uc_com_schsites

183: || (reverse chronological order - newest change first)
184: */
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igs_uc_com_schsites
188: WHERE ((school = x_school));
189:
190: lv_rowid cur_rowid%RowType;
191:

Line 328: FROM igs_uc_com_schsites

324: || (reverse chronological order - newest change first)
325: */
326: CURSOR c IS
327: SELECT rowid
328: FROM igs_uc_com_schsites
329: WHERE school = x_school
330: AND sitecode = x_sitecode;
331:
332: x_last_update_date DATE;

Line 379: INSERT INTO igs_uc_com_schsites (

375: x_last_updated_by => x_last_updated_by,
376: x_last_update_login => x_last_update_login
377: );
378:
379: INSERT INTO igs_uc_com_schsites (
380: school,
381: sitecode,
382: address1,
383: address2,

Line 465: FROM igs_uc_com_schsites

461: town_key,
462: county_key,
463: country_code,
464: imported
465: FROM igs_uc_com_schsites
466: WHERE rowid = x_rowid
467: FOR UPDATE NOWAIT;
468:
469: tlinfo c1%ROWTYPE;

Line 581: UPDATE igs_uc_com_schsites

577: x_last_updated_by => x_last_updated_by,
578: x_last_update_login => x_last_update_login
579: );
580:
581: UPDATE igs_uc_com_schsites
582: SET
583: address1 = new_references.address1,
584: address2 = new_references.address2,
585: address3 = new_references.address3,

Line 633: FROM igs_uc_com_schsites

629: || (reverse chronological order - newest change first)
630: */
631: CURSOR c1 IS
632: SELECT rowid
633: FROM igs_uc_com_schsites
634: WHERE school = x_school
635: AND sitecode = x_sitecode;
636:
637: BEGIN

Line 703: DELETE FROM igs_uc_com_schsites

699: p_action => 'DELETE',
700: x_rowid => x_rowid
701: );
702:
703: DELETE FROM igs_uc_com_schsites
704: WHERE rowid = x_rowid;
705:
706: IF (SQL%NOTFOUND) THEN
707: RAISE NO_DATA_FOUND;

Line 713: END igs_uc_com_schsites_pkg;

709:
710: END delete_row;
711:
712:
713: END igs_uc_com_schsites_pkg;