[Home] [Help]
PACKAGE: APPS.OKL_K_LINE_FIN_EXT_MASTER_PVT
Source
1 PACKAGE OKL_K_LINE_FIN_EXT_MASTER_PVT AS
2 /* $Header: OKLRLEMS.pls 120.0.12010000.6 2008/12/23 23:48:11 sechawla noship $ */
3
4 ------------------------------------------------------------------------------
5 -- Global Variables
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_K_LINE_FIN_EXT_MASTER_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12 --G_REQUEST_ID NUMBER;
13
14 -- Variables for Contract Line Financial Report XML Publisher Report input parameters
15
16
17
18 ------------------------------------------------------------------------------
19 --Global Exception
20 ------------------------------------------------------------------------------
21 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
22 ------------------------------------------------------------------------------
23
24
25 ---------------------------------------------------------------------------
26 -- GLOBAL DEBUG VARIABLES
27 ---------------------------------------------------------------------------
28 G_DEBUG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
29 G_DEBUG_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30 G_DEBUG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
31 G_DEBUG_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32 ---------------------------------------------------------------------------
33
34
35
36 G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'NO_DATA_FOUND';
37 G_TOO_MANY_ROWS CONSTANT VARCHAR2(200) := 'TOO_MANY_ROWS';
38 G_OTHERS CONSTANT VARCHAR2(200) := 'OTHERS';
39
40
41 PROCEDURE Process_Spawner (
42 errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY NUMBER,
44 P_OPERATING_UNIT IN NUMBER,
45 P_REPORT_DATE IN VARCHAR2,
46 P_DATA_SOURCE_CODE IN VARCHAR2,
47 P_REPORT_TEMPLATE_NAME IN VARCHAR2,
48 --P_TEMPLATE_CODE IN VARCHAR2, --sechawla 7628766
49 P_REPORT_LANGUAGE IN VARCHAR2,
50 P_REPORT_FORMAT IN VARCHAR2,
51 P_START_DATE_FROM IN VARCHAR2,
52 P_START_DATE_TO IN VARCHAR2,
53 P_BOOK_CLASS IN VARCHAR2,
54 P_LEASE_PRODUCT IN VARCHAR2,
55 P_CONTRACT_NUMBER IN VARCHAR2,
56 P_CONTRACT_STATUS IN VARCHAR2,
57 P_CONTRACT_LINE_STATUS IN VARCHAR2,
58 P_CONTRACT_LINE_TYPE IN VARCHAR2,
59 P_CUSTOMER_NAME IN VARCHAR2,
60 P_CUSTOMER_NUMBER IN VARCHAR2,
61 P_VENDOR_NAME IN VARCHAR2,
62 P_VENDOR_NUMBER IN VARCHAR2,
63 P_FA_INFO_YN IN VARCHAR2,
64 P_TAX_BOOK IN VARCHAR2,
65 P_DELETE_DATA_YN IN VARCHAR2,
66 P_NUM_PROCESSES IN NUMBER
67
68 );
69
70
71 END OKL_K_LINE_FIN_EXT_MASTER_PVT;