[Home] [Help]
PACKAGE: APPS.OKL_IN_TPP_PVT
Source
1 PACKAGE OKL_IN_TPP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRTPPS.pls 115.2 2002/12/18 12:51:47 kjinger noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
10 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
11 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
12 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
16 ---------------------------------------------------------------------------
17 -- GLOBAL VARIABLES
18 ---------------------------------------------------------------------------
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IN_TPP_PVT';
20 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
21 ---------------------------------------------------------------------------
22 -- GLOBAL EXCEPTION
23 ---------------------------------------------------------------------------
24 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
25 FUNCTION agency_address( p_isu_id IN NUMBER,
26 p_agency_site_id IN NUMBER,
27 x_agency_name OUT NOCOPY VARCHAR2,
28 x_agency_addrss1 OUT NOCOPY VARCHAR2,
29 x_agency_addrss2 OUT NOCOPY VARCHAR2,
30 x_agency_addrss3 OUT NOCOPY VARCHAR2,
31 x_agency_addrss4 OUT NOCOPY VARCHAR2,
32 x_agency_city OUT NOCOPY VARCHAR2,
33 x_agency_county OUT NOCOPY VARCHAR2,
34 x_agency_province OUT NOCOPY VARCHAR2,
35 x_agency_state OUT NOCOPY VARCHAR2,
36 x_agency_postalcode OUT NOCOPY VARCHAR2,
37 x_agency_country OUT NOCOPY VARCHAR2
38 ) RETURN VARCHAR2;
39 FUNCTION agent_address( p_int_id IN NUMBER,
40 p_agent_site_id IN NUMBER,
41 x_agent_name OUT NOCOPY VARCHAR2,
42 x_agent_addrss1 OUT NOCOPY VARCHAR2,
43 x_agent_addrss2 OUT NOCOPY VARCHAR2,
44 x_agent_addrss3 OUT NOCOPY VARCHAR2,
45 x_agent_addrss4 OUT NOCOPY VARCHAR2,
46 x_agent_city OUT NOCOPY VARCHAR2,
47 x_agent_county OUT NOCOPY VARCHAR2,
48 x_agent_province OUT NOCOPY VARCHAR2,
49 x_agent_state OUT NOCOPY VARCHAR2,
50 x_agent_postalcode OUT NOCOPY VARCHAR2,
51 x_agent_country OUT NOCOPY VARCHAR2
52 ) RETURN VARCHAR2;
53 END OKL_IN_TPP_PVT;