[Home] [Help]
1 PACKAGE okl_pay_invoices_cons_pub AS
2 /* $Header: OKLPPICS.pls 120.4 2007/05/07 23:04:22 ssiruvol ship $ */
3
4 ------------------------------------------------------------------------------
5 -- Global Variables
6 ------------------------------------------------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PAY_INVOICES_CONS_PVT';
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 -- Procedures and Functions
16 ---------------------------------------------------------------------------
17
18 PROCEDURE consolidation(p_api_version IN NUMBER
19 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 --start:| 24-APR-2007 cklee Disbursement changes for R12B |
24 ,p_contract_number IN VARCHAR2 DEFAULT NULL
25 ,p_vendor IN VARCHAR2 DEFAULT NULL
26 ,p_vendor_site IN VARCHAR2 DEFAULT NULL
27 ,p_vpa_number IN VARCHAR2 DEFAULT NULL
28 ,p_stream_type_purpose IN VARCHAR2 DEFAULT NULL
29 --end:| 24-APR-2007 cklee Disbursement changes for R12B |
30 ,p_from_date IN DATE DEFAULT NULL -- set p_from_date and p_to_date as not required
31 ,p_to_date IN DATE DEFAULT NULL); -- set p_from_date and p_to_date as not required
32
33 PROCEDURE consolidation_inv
34 ( errbuf OUT NOCOPY VARCHAR2
35 ,retcode OUT NOCOPY NUMBER
36 --start:| 24-APR-2007 cklee Disbursement changes for R12B |
37 ,p_contract_number IN VARCHAR2 DEFAULT NULL
38 ,p_vendor IN VARCHAR2 DEFAULT NULL
39 ,p_vendor_site IN VARCHAR2 DEFAULT NULL
40 ,p_vpa_number IN VARCHAR2 DEFAULT NULL
41 ,p_stream_type_purpose IN VARCHAR2 DEFAULT NULL
42 --end:| 24-APR-2007 cklee Disbursement changes for R12B |
43 ,p_from_date IN VARCHAR2 DEFAULT NULL -- set p_from_date and p_to_date as not required
44 ,p_to_date IN VARCHAR2 DEFAULT NULL); -- set p_from_date and p_to_date as not required
45
46
47 END;
|
|
|
|