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