[Home] [Help]
PACKAGE: APPS.OKL_AM_CONTRACT_PRTFL_PUB
Source
1 PACKAGE OKL_AM_CONTRACT_PRTFL_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPPTFS.pls 115.2 2002/07/11 19:32:56 sechawla noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL CONSTANTS
6 ---------------------------------------------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_CONTRACT_PRTFL_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13
14
15
16 PROCEDURE create_cntrct_prtfl(
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2,
22 p_contract_id IN NUMBER);
23
24
25
26 -- wrapper for executing update_cntrct_prtfl procedure as a concurrent program
27 PROCEDURE batch_upd_cntrct_prtfl(
28 ERRBUF OUT NOCOPY VARCHAR2,
29 RETCODE OUT NOCOPY VARCHAR2 ,
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
32 p_contract_id IN NUMBER DEFAULT NULL ) ;
33
34 PROCEDURE update_cntrct_prtfl(
35 p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_contract_id IN NUMBER DEFAULT NULL,
41 x_total_count OUT NOCOPY NUMBER,
42 x_processed_count OUT NOCOPY NUMBER,
43 x_error_count OUT NOCOPY NUMBER);
44
45 PROCEDURE batch_exe_cntrct_prtfl(
46 ERRBUF OUT NOCOPY VARCHAR2,
47 RETCODE OUT NOCOPY VARCHAR2 ,
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE) ;
50
51 PROCEDURE execute_cntrct_prtfl(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 x_total_count OUT NOCOPY NUMBER,
58 x_processed_count OUT NOCOPY NUMBER,
59 x_error_count OUT NOCOPY NUMBER);
60
61
62
63 END OKL_AM_CONTRACT_PRTFL_PUB;