[Home] [Help]
PACKAGE: APPS.OKL_CNTRCT_FIN_EXT_MASTER_PVT
Source
1 PACKAGE OKL_CNTRCT_FIN_EXT_MASTER_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRFECS.pls 120.0.12010000.5 2009/09/25 22:04:44 sechawla noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CNTRCT_FIN_EXT_MASTER_PVT';
5 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
6
7 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(1000) := 'OKL_UNEXPECTED_ERROR';
9
10 ---------------------------------------------------------------------------
11 -- GLOBAL DEBUG VARIABLES
12 ---------------------------------------------------------------------------
13 G_DEBUG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14 G_DEBUG_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15 G_DEBUG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16 G_DEBUG_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17 ---------------------------------------------------------------------------
18
19
20
21 G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'NO_DATA_FOUND';
22 G_TOO_MANY_ROWS CONSTANT VARCHAR2(200) := 'TOO_MANY_ROWS';
23 G_OTHERS CONSTANT VARCHAR2(200) := 'OTHERS';
24
25
26 PROCEDURE Process_Spawner (
27
28 errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY NUMBER,
30 P_OPERATING_UNIT IN NUMBER,
31 --P_REPORT_DATE IN VARCHAR2, sechawla 25-sep-09 8890513
32 P_DATA_SOURCE_CODE IN VARCHAR2,
33 P_REPORT_TEMPLATE_NAME IN VARCHAR2,
34 P_REPORT_LANGUAGE IN VARCHAR2,
35 P_REPORT_FORMAT IN VARCHAR2,
36
37 P_START_DATE_FROM IN VARCHAR2,
38 P_START_DATE_TO IN VARCHAR2,
39 P_AR_INFO_YN IN VARCHAR2,
40 P_BOOK_CLASS IN VARCHAR2,
41 P_LEASE_PRODUCT IN VARCHAR2,
42 P_CONTRACT_STATUS IN VARCHAR2,
43 P_CUSTOMER_NUMBER IN VARCHAR2,
44 P_CUSTOMER_NAME IN VARCHAR2,
45 P_SIC_CODE IN VARCHAR2,
46 P_VENDOR_NUMBER IN VARCHAR2,
47 P_VENDOR_NAME IN VARCHAR2,
48 P_SALES_CHANNEL IN VARCHAR2,
49 P_GEN_ACCRUAL IN VARCHAR2,
50 P_END_DATE_FROM IN VARCHAR2,
51 P_END_DATE_TO IN VARCHAR2,
52 P_TERMINATE_DATE_FROM IN VARCHAR2,
53 P_TERMINATE_DATE_TO IN VARCHAR2,
54 P_DELETE_DATA_YN IN VARCHAR2,
55 p_num_processes IN NUMBER
56
57 );
58
59
60 END OKL_CNTRCT_FIN_EXT_MASTER_PVT;