[Home] [Help]
PACKAGE: APPS.IGS_OR_INST_ADDR_PKG
Source
1 package IGS_OR_INST_ADDR_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSOI03S.pls 115.4 2002/02/12 17:08:09 pkm ship $ */
3
4 FUNCTION Get_PK_For_Validation (
5 x_institution_cd IN VARCHAR2,
6 x_addr_type IN VARCHAR2,
7 x_start_dt IN DATE
8 ) RETURN BOOLEAN ;
9
10 PROCEDURE GET_FK_IGS_CO_ADDR_TYPE (
11 x_addr_type IN VARCHAR2
12 );
13
14 PROCEDURE GET_FK_IGS_OR_INSTITUTION (
15 x_institution_cd IN VARCHAR2
16 );
17 PROCEDURE GET_FK_IGS_PE_SUBURB_POSTCD (
18 x_postcode IN VARCHAR2
19 );
20 end IGS_OR_INST_ADDR_PKG;