APPS.IGS_AD_LOCATION_TYPE_PKG dependencies on IGS_AD_LOCATION_TYPE_ALL

Line 5: old_references igs_ad_location_type_all%RowType;

1: package body IGS_AD_LOCATION_TYPE_PKG as
2: /* $Header: IGSAI43B.pls 115.8 2003/10/30 13:12:54 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_location_type_all%RowType;
6: new_references igs_ad_location_type_all%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_location_type_all%RowType;

2: /* $Header: IGSAI43B.pls 115.8 2003/10/30 13:12:54 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_location_type_all%RowType;
6: new_references igs_ad_location_type_all%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM igs_ad_location_type_all

21: ) as
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM igs_ad_location_type_all
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 170: FROM igs_ad_location_type_all

166: )return BOOLEAN as
167:
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igs_ad_location_type_all
171: WHERE location_type = x_location_type AND
172: closed_ind = NVL(x_closed_ind,closed_ind)
173: FOR UPDATE NOWAIT;
174:

Line 197: FROM igs_ad_location_type_all

193: ) as
194:
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM igs_ad_location_type_all
198: WHERE s_location_type = x_s_location_type ;
199:
200: lv_rowid cur_rowid%RowType;
201:

Line 303: cursor C is select ROWID from igs_ad_location_type_all

299: X_S_LOCATION_TYPE in VARCHAR2,
300: X_CLOSED_IND in VARCHAR2,
301: X_MODE in VARCHAR2 default 'R'
302: ) as
303: cursor C is select ROWID from igs_ad_location_type_all
304: where LOCATION_TYPE = X_LOCATION_TYPE;
305: X_LAST_UPDATE_DATE DATE;
306: X_LAST_UPDATED_BY NUMBER;
307: X_LAST_UPDATE_LOGIN NUMBER;

Line 344: insert into igs_ad_location_type_all (

340: x_last_update_login=> X_LAST_UPDATE_LOGIN
341: );
342:
343:
344: insert into igs_ad_location_type_all (
345: LOCATION_TYPE,
346: DESCRIPTION,
347: S_LOCATION_TYPE,
348: CLOSED_IND,

Line 395: from igs_ad_location_type_all

391: cursor c1 is select
392: DESCRIPTION,
393: S_LOCATION_TYPE,
394: CLOSED_IND
395: from igs_ad_location_type_all
396: WHERE ROWID = X_ROWID for update nowait ;
397: tlinfo c1%rowtype;
398:
399: begin

Line 472: update igs_ad_location_type_all set

468: x_last_updated_by=>X_LAST_UPDATED_BY ,
469: x_last_update_login=> X_LAST_UPDATE_LOGIN
470: );
471:
472: update igs_ad_location_type_all set
473: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
474: S_LOCATION_TYPE = NEW_REFERENCES.S_LOCATION_TYPE,
475: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
476: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 501: cursor c1 is select rowid from igs_ad_location_type_all

497: X_S_LOCATION_TYPE in VARCHAR2,
498: X_CLOSED_IND in VARCHAR2,
499: X_MODE in VARCHAR2 default 'R'
500: ) as
501: cursor c1 is select rowid from igs_ad_location_type_all
502: where LOCATION_TYPE = X_LOCATION_TYPE
503: ;
504:
505: begin

Line 541: delete from igs_ad_location_type_all

537: x_rowid=> X_ROWID
538: );
539:
540:
541: delete from igs_ad_location_type_all
542: where ROWID = X_ROWID;
543: if (sql%notfound) then
544: raise no_data_found;
545: end if;