DBA Data[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;