[Home] [Help]
PACKAGE: APPS.OKL_AM_VENDOR_RES_SHARE_PVT
Source
1 PACKAGE OKL_AM_VENDOR_RES_SHARE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRVRSS.pls 120.2 2007/01/09 12:37:20 udhenuko noship $ */
3
4 -- Variables for XML Publisher Report input parameters
5 P_ASSET_NUMBER VARCHAR2(120);
6 P_DISP_DATE_FROM VARCHAR2(120);
7 P_DISP_DATE_TO VARCHAR2(120);
8 P_VPA_NUMBER VARCHAR2(120);
9 P_ASST_END_DT_FROM VARCHAR2(120);
10 P_ASST_END_DT_TO VARCHAR2(120);
11 P_CURRENCY VARCHAR2(120);
12 WHERE_CLAUSE VARCHAR2(4000);
13
14 ---------------------------------------------------------------------------
15 -- PROCEDURES
16 ---------------------------------------------------------------------------
17
18 -- This procedure is called by concurrent manager to do vendor residual sharing
19 PROCEDURE concurrent_vend_res_share_prg(
20 errbuf OUT NOCOPY VARCHAR2,
21 retcode OUT NOCOPY VARCHAR2,
22 p_api_version IN VARCHAR2,
23 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
24 p_kle_id IN VARCHAR2 DEFAULT NULL);
25
26 -- This procedure is called by concurrent manager to generate vendor residual sharing report
27 PROCEDURE concurrent_vend_res_share_rpt(
28 errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY VARCHAR2,
30 p_api_version IN VARCHAR2,
31 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
32 p_asset_number IN VARCHAR2 DEFAULT NULL,
33 p_disp_date_from IN VARCHAR2 DEFAULT NULL,
34 p_disp_date_to IN VARCHAR2 DEFAULT NULL,
35 p_vpa_number IN VARCHAR2 DEFAULT NULL,
36 p_asst_end_dt_from IN VARCHAR2 DEFAULT NULL,
37 p_asst_end_dt_to IN VARCHAR2 DEFAULT NULL,
38 p_currency IN VARCHAR2 DEFAULT NULL);
39
40 -- UDHENUKO Function to form the where clause for XML Publisher based on the input parameters
41 FUNCTION BEFORE_REPORT_INIT_WHRE_CLAUSE RETURN BOOLEAN;
42
43 END OKL_AM_VENDOR_RES_SHARE_PVT;