[Home] [Help]
PACKAGE: APPS.OKL_AM_CONTRACT_PRTFL_PVT
Source
1 PACKAGE OKL_AM_CONTRACT_PRTFL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRPTFS.pls 115.3 2002/12/31 01:18:59 sechawla noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16
17 ---------------------------------------------------------------------------
18 -- GLOBAL VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_CONTRACT_PRTFL_PVT';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
22
23 ---------------------------------------------------------------------------
24 -- GLOBAL EXCEPTIONS
25 ---------------------------------------------------------------------------
26 G_EXCEPTION_INSURANCE_ERROR EXCEPTION;
27
28
29
30 ---------------------------------------------------------------------------
31 -- PROCEDURES
32 ---------------------------------------------------------------------------
33
34
35 PROCEDURE create_cntrct_prtfl(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_contract_id IN NUMBER);
42
43
44
45 -- wrapper for executing update_cntrct_prtfl procedure as a concurrent program
46 PROCEDURE batch_upd_cntrct_prtfl( 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 p_contract_id IN NUMBER DEFAULT NULL
51 ) ;
52
53 PROCEDURE update_cntrct_prtfl(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_contract_id IN NUMBER DEFAULT NULL,
60 x_total_count OUT NOCOPY NUMBER,
61 x_processed_count OUT NOCOPY NUMBER,
62 x_error_count OUT NOCOPY NUMBER);
63
64 -- wrapper for executing execute_cntrct_prtfl procedure as a concurrent program
65 PROCEDURE batch_exe_cntrct_prtfl( ERRBUF OUT NOCOPY VARCHAR2,
66 RETCODE OUT NOCOPY VARCHAR2 ,
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
69 ) ;
70
71 PROCEDURE execute_cntrct_prtfl(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 x_total_count OUT NOCOPY NUMBER,
78 x_processed_count OUT NOCOPY NUMBER,
79 x_error_count OUT NOCOPY NUMBER);
80
81
82 END OKL_AM_CONTRACT_PRTFL_PVT;