[Home] [Help]
PACKAGE: APPS.OKL_EXPENSE_STREAMS_PVT
Source
1 PACKAGE OKL_EXPENSE_STREAMS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSGES.pls 120.2 2008/01/25 14:18:41 gboomina ship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE SPECIFIC CONSTANTS
6 -----------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_EXPENSE_STREAMS_PVT';
8
9 -----------------------------------------------------------------------------
10 -- APPLICATION GLOBAL CONSTANTS
11 -----------------------------------------------------------------------------
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13 G_API_VERSION CONSTANT NUMBER := 1;
14 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
16 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
17 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
18 G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
23
24 ---------------------------------------------------------------------------
25 -- PROGRAM UNITS
26 ---------------------------------------------------------------------------
27 PROCEDURE generate_idc( p_khr_id IN NUMBER,
28 p_purpose_code IN VARCHAR2,
29 p_currency_code IN VARCHAR2,
30 p_start_date IN DATE,
31 p_end_date IN DATE,
32 p_deal_type IN VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2);
34
35 PROCEDURE generate_expense_streams( p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2,
37 p_khr_id IN NUMBER,
38 p_purpose_code IN VARCHAR2,
39 p_deal_type IN VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2);
43 -- gboomina Bug 6763287 - Start
44 PROCEDURE generate_rec_exp( p_khr_id IN NUMBER,
45 p_deal_type IN VARCHAR2,
46 p_purpose_code IN VARCHAR2,
47 p_currency_code IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2);
49 -- gboomina Bug 6763287 - End
50
51 END OKL_EXPENSE_STREAMS_PVT;