APPS.IGS_OR_ORG_INST_TYPE_PKG dependencies on IGS_OR_ORG_INST_TYPE_ALL

Line 4: old_references igs_or_org_inst_type_all%RowType;

1: PACKAGE BODY igs_or_org_inst_type_pkg AS
2: /* $Header: IGSOI19B.pls 120.0 2005/06/01 16:49:51 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_inst_type_all%RowType;
5: new_references igs_or_org_inst_type_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_or_org_inst_type_all%RowType;

1: PACKAGE BODY igs_or_org_inst_type_pkg AS
2: /* $Header: IGSOI19B.pls 120.0 2005/06/01 16:49:51 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_or_org_inst_type_all%RowType;
5: new_references igs_or_org_inst_type_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM igs_or_org_inst_type_all

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

Line 153: FROM igs_or_org_inst_type_all

149: ***************************************************************/
150:
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igs_or_org_inst_type_all
154: WHERE institution_type = x_institution_type
155: FOR UPDATE NOWAIT;
156:
157: lv_rowid cur_rowid%RowType;

Line 303: cursor C is select ROWID from igs_or_org_inst_type_all

299:
300: (reverse chronological order - newest change first)
301: ***************************************************************/
302:
303: cursor C is select ROWID from igs_or_org_inst_type_all
304: where INSTITUTION_TYPE= X_INSTITUTION_TYPE
305: ;
306: X_LAST_UPDATE_DATE DATE ;
307: X_LAST_UPDATED_BY NUMBER ;

Line 342: insert into igs_or_org_inst_type_all (

338: x_last_updated_by=>X_LAST_UPDATED_BY,
339: x_last_update_login=>X_LAST_UPDATE_LOGIN,
340: x_org_id=>igs_ge_gen_003.get_org_id);
341:
342: insert into igs_or_org_inst_type_all (
343: INSTITUTION_TYPE
344: ,DESCRIPTION
345: ,SYSTEM_INST_TYPE
346: ,CLOSE_IND

Line 398: from igs_or_org_inst_type_all

394: cursor c1 is select
395: DESCRIPTION
396: , CLOSE_IND
397: , SYSTEM_INST_TYPE
398: from igs_or_org_inst_type_all
399: where ROWID = X_ROWID
400: for update nowait;
401: tlinfo c1%rowtype;
402: begin

Line 480: update igs_or_org_inst_type_all set

476: x_created_by=>X_LAST_UPDATED_BY,
477: x_last_update_date=>X_LAST_UPDATE_DATE,
478: x_last_updated_by=>X_LAST_UPDATED_BY,
479: x_last_update_login=>X_LAST_UPDATE_LOGIN);
480: update igs_or_org_inst_type_all set
481: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
482: SYSTEM_INST_TYPE = NEW_REFERENCES.SYSTEM_INST_TYPE,
483: CLOSE_IND = NEW_REFERENCES.CLOSE_IND,
484: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 519: cursor c1 is select ROWID from igs_or_org_inst_type_all

515:
516: (reverse chronological order - newest change first)
517: ***************************************************************/
518:
519: cursor c1 is select ROWID from igs_or_org_inst_type_all
520: where INSTITUTION_TYPE= X_INSTITUTION_TYPE
521: ;
522: begin
523: open c1;

Line 566: delete from igs_or_org_inst_type_all

562: Before_DML (
563: p_action => 'DELETE',
564: x_rowid => X_ROWID
565: );
566: delete from igs_or_org_inst_type_all
567: where ROWID = X_ROWID;
568: if (sql%notfound) then
569: raise no_data_found;
570: end if;