[Home] [Help]
PACKAGE: APPS.OKC_AR_INT_PUB
Source
1 PACKAGE okc_ar_int_pub AUTHID CURRENT_USER AS
2 /* $Header: OKCPARXS.pls 120.0 2005/05/25 23:09:40 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE contract_contingency_rec_type IS RECORD (
7 CONTINGENCY_TYPE VARCHAR2(30),
8 CONTINGENCY_PRESENT_YN VARCHAR2(1),
9 EXPIRATION_DATE DATE,
10 EXPIRATION_START_EVENT VARCHAR2(30) DEFAULT 'INVOICE',
11 EXPIRATION_DURATION NUMBER,
12 DURATION_UOM VARCHAR2(30));
13
14 TYPE contract_contingency_tbl_type IS TABLE OF contract_contingency_rec_type INDEX BY BINARY_INTEGER;
15
16 -- GLOBAL VARIABLES
17 ---------------------------------------------------------------------------
18 G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AR_INT_PUB';
20 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
21 G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
22 G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24 ---------------------------------------------------------------------------
25
26
27 PROCEDURE get_contract_contingencies
28 ( p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30 p_contract_id IN NUMBER,
31 p_contract_line_id IN NUMBER,
32 x_contract_contingencies_tbl OUT NOCOPY contract_contingency_tbl_type,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2
36 );
37
38 END okc_ar_int_pub;