eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_SUBURB_POSTCD_PKG dependencies on IGS_PE_SUBURB_POSTCD

Line 1: package body IGS_PE_SUBURB_POSTCD_PKG AS

1: package body IGS_PE_SUBURB_POSTCD_PKG AS
2: /* $Header: IGSNI36B.pls 115.4 2002/11/29 01:23:06 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_SUBURB_POSTCD%RowType;

Line 5: old_references IGS_PE_SUBURB_POSTCD%RowType;

1: package body IGS_PE_SUBURB_POSTCD_PKG AS
2: /* $Header: IGSNI36B.pls 115.4 2002/11/29 01:23:06 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_SUBURB_POSTCD%RowType;
6: new_references IGS_PE_SUBURB_POSTCD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PE_SUBURB_POSTCD%RowType;

2: /* $Header: IGSNI36B.pls 115.4 2002/11/29 01:23:06 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_SUBURB_POSTCD%RowType;
6: new_references IGS_PE_SUBURB_POSTCD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_PE_SUBURB_POSTCD

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_PE_SUBURB_POSTCD
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 63: -- ON IGS_PE_SUBURB_POSTCD

59:
60: -- Trigger description :-
61: -- "OSS_TST".trg_sp_br_d
62: -- BEFORE DELETE
63: -- ON IGS_PE_SUBURB_POSTCD
64: -- FOR EACH ROW
65:
66: PROCEDURE BeforeRowDelete1(
67: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 127: /* IGS_OR_INST_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

123: NULL;
124: /* The call to the Child tables has been intentionally commented because the
125: column Postcode has been removed from all these forms */
126:
127: /* IGS_OR_INST_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
128: old_references.postcode
129: );
130:
131: IGS_AD_LOCATION_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

Line 131: IGS_AD_LOCATION_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

127: /* IGS_OR_INST_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
128: old_references.postcode
129: );
130:
131: IGS_AD_LOCATION_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
132: old_references.postcode
133: );
134:
135: IGS_OR_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

Line 135: IGS_OR_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

131: IGS_AD_LOCATION_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
132: old_references.postcode
133: );
134:
135: IGS_OR_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
136: old_references.postcode
137: );
138:
139: IGS_PE_PERSON_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

Line 139: IGS_PE_PERSON_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

135: IGS_OR_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
136: old_references.postcode
137: );
138:
139: IGS_PE_PERSON_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
140: old_references.postcode
141: );
142:
143: IGS_GR_VENUE_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

Line 143: IGS_GR_VENUE_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (

139: IGS_PE_PERSON_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
140: old_references.postcode
141: );
142:
143: IGS_GR_VENUE_ADDR_PKG.GET_FK_IGS_PE_SUBURB_POSTCD (
144: old_references.postcode
145: ); */
146:
147: END Check_Child_Existance;

Line 155: FROM IGS_PE_SUBURB_POSTCD

151: ) RETURN BOOLEAN AS
152:
153: CURSOR cur_rowid IS
154: SELECT rowid
155: FROM IGS_PE_SUBURB_POSTCD
156: WHERE postcode = x_postcode
157: FOR UPDATE NOWAIT;
158:
159: lv_rowid cur_rowid%RowType;

Line 272: cursor C is select ROWID from IGS_PE_SUBURB_POSTCD

268: X_SUBURBS in VARCHAR2,
269: X_CLOSED_IND in VARCHAR2,
270: X_MODE in VARCHAR2 default 'R'
271: ) AS
272: cursor C is select ROWID from IGS_PE_SUBURB_POSTCD
273: where POSTCODE = X_POSTCODE;
274: X_LAST_UPDATE_DATE DATE;
275: X_LAST_UPDATED_BY NUMBER;
276: X_LAST_UPDATE_LOGIN NUMBER;

Line 310: insert into IGS_PE_SUBURB_POSTCD (

306: x_last_updated_by=>X_LAST_UPDATED_BY,
307: x_last_update_login=>X_LAST_UPDATE_LOGIN
308: );
309: --
310: insert into IGS_PE_SUBURB_POSTCD (
311: POSTCODE,
312: SUBURBS,
313: CLOSED_IND,
314: CREATION_DATE,

Line 354: from IGS_PE_SUBURB_POSTCD

350: ) AS
351: cursor c1 is select
352: SUBURBS,
353: CLOSED_IND
354: from IGS_PE_SUBURB_POSTCD
355: where ROWID = X_ROWID
356: for update nowait;
357: tlinfo c1%rowtype;
358:

Line 425: update IGS_PE_SUBURB_POSTCD set

421: x_last_updated_by=>X_LAST_UPDATED_BY,
422: x_last_update_login=>X_LAST_UPDATE_LOGIN
423: );
424: --
425: update IGS_PE_SUBURB_POSTCD set
426: SUBURBS = NEW_REFERENCES.SUBURBS,
427: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
428: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
429: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 451: cursor c1 is select rowid from IGS_PE_SUBURB_POSTCD

447: X_SUBURBS in VARCHAR2,
448: X_CLOSED_IND in VARCHAR2,
449: X_MODE in VARCHAR2 default 'R'
450: ) AS
451: cursor c1 is select rowid from IGS_PE_SUBURB_POSTCD
452: where POSTCODE = X_POSTCODE
453: ;
454:
455: begin

Line 487: delete from IGS_PE_SUBURB_POSTCD

483: p_action => 'DELETE',
484: x_rowid => X_ROWID
485: );
486: --
487: delete from IGS_PE_SUBURB_POSTCD
488: where ROWID = X_ROWID;
489: if (sql%notfound) then
490: raise no_data_found;
491: end if;

Line 500: end IGS_PE_SUBURB_POSTCD_PKG;

496: );
497: --
498: end DELETE_ROW;
499:
500: end IGS_PE_SUBURB_POSTCD_PKG;