APPS.IGS_OR_ADDR_PKG dependencies on IGS_OR_ADDR

Line 1: package body IGS_OR_ADDR_PKG AS

1: package body IGS_OR_ADDR_PKG AS
2: /* $Header: IGSOI07B.pls 115.5 2002/02/12 17:08:20 pkm ship $ */
3: /*************************************************************
4: Changed By : smanglm
5: Date : 2000/08/25

Line 28: FROM IGS_OR_ADDR

24: x_start_dt IN DATE
25: )RETURN BOOLEAN AS
26: CURSOR cur_rowid is
27: SELECT rowid
28: FROM IGS_OR_ADDR
29: WHERE org_unit_cd = x_org_unit_cd
30: AND ou_start_dt = x_ou_start_dt
31: AND addr_type = x_addr_type
32: AND start_dt = x_start_dt

Line 52: FROM IGS_OR_ADDR

48: x_addr_type IN VARCHAR2
49: ) AS
50: CURSOR cur_rowid IS
51: SELECT rowid
52: FROM IGS_OR_ADDR
53: WHERE addr_type = x_addr_type ;
54: lv_rowid cur_rowid%RowType;
55: BEGIN
56: Open cur_rowid;

Line 74: FROM IGS_OR_ADDR

70: x_start_dt IN DATE
71: ) AS
72: CURSOR cur_rowid IS
73: SELECT rowid
74: FROM IGS_OR_ADDR
75: WHERE org_unit_cd = x_org_unit_cd
76: AND ou_start_dt = x_start_dt ;
77: lv_rowid cur_rowid%RowType;
78: BEGIN

Line 96: FROM IGS_OR_ADDR

92: x_postcode IN NUMBER
93: ) AS
94: CURSOR cur_rowid IS
95: SELECT rowid
96: FROM IGS_OR_ADDR
97: WHERE postal_code = x_postcode ;
98: lv_rowid cur_rowid%RowType;
99: BEGIN
100: Open cur_rowid;

Line 112: end IGS_OR_ADDR_PKG;

108: END IF;
109: Close cur_rowid;
110: END GET_FK_IGS_PE_SUBURB_POSTCD;
111:
112: end IGS_OR_ADDR_PKG;