APPS.IGS_AD_LOCATION_PKG dependencies on IGS_AD_LOCATION_ALL

Line 5: old_references IGS_AD_LOCATION_ALL%RowType;

1: package body IGS_AD_LOCATION_PKG as
2: /* $Header: IGSAI46B.pls 115.21 2003/12/03 08:39:53 ijeddy ship $ */
3: --msrinivi 24-AUG-2001 Bug No. 1956374 .Repointed genp_val_prsn_id
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_LOCATION_ALL%RowType;
6: new_references IGS_AD_LOCATION_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_LOCATION_ALL%RowType;

2: /* $Header: IGSAI46B.pls 115.21 2003/12/03 08:39:53 ijeddy ship $ */
3: --msrinivi 24-AUG-2001 Bug No. 1956374 .Repointed genp_val_prsn_id
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_LOCATION_ALL%RowType;
6: new_references IGS_AD_LOCATION_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 58: FROM IGS_AD_LOCATION_ALL

54: msrinivi 17 Jul, 2001 Added new col : rev account cd
55: ***************************************************************/
56: CURSOR cur_old_ref_values IS
57: SELECT *
58: FROM IGS_AD_LOCATION_ALL
59: WHERE rowid = x_rowid;
60:
61: BEGIN
62:

Line 446: FROM IGS_AD_LOCATION_ALL

442: ***************************************************************/
443:
444: CURSOR cur_rowid IS
445: SELECT rowid
446: FROM IGS_AD_LOCATION_ALL
447: WHERE location_cd = x_location_cd AND
448: closed_ind = NVL(x_closed_ind,closed_ind);
449:
450: lv_rowid cur_rowid%RowType;

Line 480: FROM IGS_AD_LOCATION_ALL

476: (reverse chronological order - newest change first)
477: ***************************************************************/
478: CURSOR cur_rowid IS
479: SELECT rowid
480: FROM IGS_AD_LOCATION_ALL
481: WHERE location_type = x_location_type ;
482:
483: lv_rowid cur_rowid%RowType;
484:

Line 514: FROM IGS_AD_LOCATION_ALL

510: (reverse chronological order - newest change first)
511: ***************************************************************/
512: CURSOR cur_rowid IS
513: SELECT rowid
514: FROM IGS_AD_LOCATION_ALL
515: WHERE coord_person_id = x_person_id ;
516:
517: lv_rowid cur_rowid%RowType;
518:

Line 723: cursor C is select ROWID from IGS_AD_LOCATION_ALL

719: msrinivi 18 Jul,2001 Added new col :rev_account_cd
720: (reverse chronological order - newest change first)
721: ***************************************************************/
722:
723: cursor C is select ROWID from IGS_AD_LOCATION_ALL
724: where LOCATION_CD = X_LOCATION_CD;
725: X_LAST_UPDATE_DATE DATE;
726: X_LAST_UPDATED_BY NUMBER;
727: X_LAST_UPDATE_LOGIN NUMBER;

Line 787: insert into IGS_AD_LOCATION_ALL (

783: x_last_update_login => X_LAST_UPDATE_LOGIN,
784: x_rev_account_cd => x_rev_account_cd
785: );
786:
787: insert into IGS_AD_LOCATION_ALL (
788: LOCATION_CD,
789: DESCRIPTION,
790: LOCATION_TYPE,
791: MAIL_DLVRY_WRK_DAYS,

Line 941: from IGS_AD_LOCATION_ALL

937: , ATTRIBUTE19
938: , ATTRIBUTE20
939: , CLOSED_IND
940: , rev_account_cd
941: from IGS_AD_LOCATION_ALL
942: WHERE ROWID = X_ROWID for update nowait ;
943: tlinfo c1%rowtype;
944:
945: begin

Line 1144: update IGS_AD_LOCATION_ALL set

1140: x_last_updated_by => X_LAST_UPDATED_BY,
1141: x_last_update_login => X_LAST_UPDATE_LOGIN,
1142: x_rev_account_cd => x_rev_account_cd
1143: );
1144: update IGS_AD_LOCATION_ALL set
1145: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
1146: LOCATION_TYPE = NEW_REFERENCES.LOCATION_TYPE,
1147: MAIL_DLVRY_WRK_DAYS = NEW_REFERENCES.MAIL_DLVRY_WRK_DAYS,
1148: COORD_PERSON_ID = NEW_REFERENCES.COORD_PERSON_ID,

Line 1229: cursor c1 is select rowid from IGS_AD_LOCATION_ALL

1225: msrinivi 18 Jul,2001 Added new col :rev_account_cd
1226: (reverse chronological order - newest change first)
1227: ***************************************************************/
1228:
1229: cursor c1 is select rowid from IGS_AD_LOCATION_ALL
1230: where LOCATION_CD = X_LOCATION_CD ;
1231: Begin
1232: open c1;
1233: fetch c1 into X_ROWID;

Line 1322: delete from IGS_AD_LOCATION_ALL

1318: Before_DML (
1319: p_action => 'DELETE' ,
1320: x_rowid => X_ROWID
1321: );
1322: delete from IGS_AD_LOCATION_ALL
1323: where ROWID = X_ROWID;
1324: if (sql%notfound) then
1325: raise no_data_found;
1326: end if;