APPS.IGS_OR_INST_ADDR_PKG dependencies on IGS_OR_INST_ADDR

Line 1: package body IGS_OR_INST_ADDR_PKG AS

1: package body IGS_OR_INST_ADDR_PKG AS
2: /* $Header: IGSOI03B.pls 115.4 2002/02/12 17:08:06 pkm ship $ */
3: /*************************************************************
4: Changed By : smanglm
5: Date : 2000/08/25

Line 39: FROM IGS_OR_INST_ADDR

35: (reverse chronological order - newest change first)
36: ***************************************************************/
37: CURSOR cur_rowid IS
38: SELECT rowid
39: FROM IGS_OR_INST_ADDR
40: WHERE institution_cd = x_institution_cd
41: AND addr_type = x_addr_type
42: AND start_dt = x_start_dt
43: FOR UPDATE NOWAIT;

Line 71: FROM IGS_OR_INST_ADDR

67: (reverse chronological order - newest change first)
68: ***************************************************************/
69: CURSOR cur_rowid IS
70: SELECT rowid
71: FROM IGS_OR_INST_ADDR
72: WHERE addr_type = x_addr_type ;
73: lv_rowid cur_rowid%RowType;
74: BEGIN
75: Open cur_rowid;

Line 102: FROM IGS_OR_INST_ADDR

98: (reverse chronological order - newest change first)
99: ***************************************************************/
100: CURSOR cur_rowid is
101: SELECT rowid
102: FROM IGS_OR_INST_ADDR
103: WHERE institution_cd = x_institution_cd ;
104: lv_rowid cur_rowid%RowType;
105: BEGIN
106: Open cur_rowid;

Line 123: FROM IGS_OR_INST_ADDR

119: x_postcode IN VARCHAR2
120: ) AS
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM IGS_OR_INST_ADDR
124: WHERE postal_code = x_postcode ;
125: lv_rowid cur_rowid%RowType;
126: BEGIN
127: Open cur_rowid;

Line 139: end IGS_OR_INST_ADDR_PKG;

135: END IF;
136: Close cur_rowid;
137: END GET_FK_IGS_PE_SUBURB_POSTCD;
138:
139: end IGS_OR_INST_ADDR_PKG;