[Home] [Help]
PACKAGE: APPS.OKL_K_LINE_FIN_EXT_PVT
Source
1 PACKAGE OKL_K_LINE_FIN_EXT_PVT AS
2 /* $Header: OKLRLFES.pls 120.0.12010000.5 2008/12/23 23:50:48 sechawla noship $ */
3
4 ------------------------------------------------------------------------------
5 -- Global Variables
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_K_LINE_FIN_EXT_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
11 --G_REQUEST_ID NUMBER;
12
13
14 ------------------------------------------------------------------------------
15 --Global Exception
16 ------------------------------------------------------------------------------
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 ------------------------------------------------------------------------------
19
20
21
22 -- Variables for Contract Financial Report XML Publisher Report input parameters
23 P_REPORT_DATE DATE;
24 P_OPERATING_UNIT OKC_K_HEADERS_ALL_B.AUTHORING_ORG_ID%TYPE;
25 P_START_DATE_FROM DATE;
26 P_START_DATE_TO DATE;
27
28 P_BOOK_CLASS OKL_K_HEADERS.DEAL_TYPE%TYPE;
29 P_LEASE_PRODUCT OKL_PRODUCTS.NAME%TYPE;
30 P_CONTRACT_NUMBER OKC_K_HEADERS_ALL_B.CONTRACT_NUMBER%TYPE;
31 P_CONTRACT_STATUS OKC_K_HEADERS_ALL_B.sts_code%TYPE; -- check
32 P_CONTRACT_LINE_STATUS OKC_K_LINES_B.sts_code%TYPE;
33 P_CONTRACT_LINE_TYPE OKC_LINE_STYLES_B.LTY_CODE%TYPE;
34 P_CUSTOMER_NAME HZ_PARTIES.party_name%TYPE;
35 P_CUSTOMER_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE;
36 P_VENDOR_NAME po_vendors.vendor_name%TYPE;
37 P_VENDOR_NUMBER po_vendors.segment1%TYPE;
38 P_TAX_BOOK FA_BOOK_CONTROLS.book_type_code%TYPE;
39 P_FA_INFO_YN VARCHAR2(5);
40 P_DELETE_DATA_YN VARCHAR2(5);
41 P_REQUEST_ID NUMBER;
42
43
44 ------------------------------------------------------------------------------
45 --Global Exception
46 ------------------------------------------------------------------------------
47 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
48 ------------------------------------------------------------------------------
49 PROCEDURE pull_extract_data_conc (
50 errbuf OUT NOCOPY VARCHAR2,
51 retcode OUT NOCOPY NUMBER,
52 P_OPERATING_UNIT IN NUMBER,
53 P_REPORT_DATE IN VARCHAR2,
54 P_START_DATE_FROM IN VARCHAR2,
55 P_START_DATE_TO IN VARCHAR2,
56 P_BOOK_CLASS IN VARCHAR2,
57 P_LEASE_PRODUCT IN VARCHAR2,
58 P_CONTRACT_NUMBER IN VARCHAR2,
59 P_CONTRACT_STATUS IN VARCHAR2,
60 P_CONTRACT_LINE_STATUS IN VARCHAR2,
61 P_CONTRACT_LINE_TYPE IN VARCHAR2,
62 P_CUSTOMER_NAME IN VARCHAR2,
63 P_CUSTOMER_NUMBER IN VARCHAR2,
64 P_VENDOR_NAME IN VARCHAR2,
65 P_VENDOR_NUMBER IN VARCHAR2,
66 P_FA_INFO_YN IN VARCHAR2,
67 P_TAX_BOOK IN VARCHAR2,
68 P_DELETE_DATA_YN IN VARCHAR2,
69 P_NUM_PROCESSES IN NUMBER,
70 P_ASSIGNED_PROCESS IN VARCHAR2
71 );
72
73 PROCEDURE pull_extract_data (
74 p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2,
79 x_row_count OUT NOCOPY VARCHAR2,
80 P_OPERATING_UNIT IN NUMBER,
81 P_REPORT_DATE IN VARCHAR2,
82
83 P_START_DATE_FROM IN VARCHAR2,
84 P_START_DATE_TO IN VARCHAR2,
85 P_BOOK_CLASS IN VARCHAR2,
86 P_LEASE_PRODUCT IN VARCHAR2,
87 P_CONTRACT_NUMBER IN VARCHAR2,
88 P_CONTRACT_STATUS IN VARCHAR2,
89 P_CONTRACT_LINE_STATUS IN VARCHAR2,
90 P_CONTRACT_LINE_TYPE IN VARCHAR2,
91 P_CUSTOMER_NAME IN VARCHAR2,
92 P_CUSTOMER_NUMBER IN VARCHAR2,
93 P_VENDOR_NAME IN VARCHAR2,
94 P_VENDOR_NUMBER IN VARCHAR2,
95 P_FA_INFO_YN IN VARCHAR2,
96 P_TAX_BOOK IN VARCHAR2,
97 P_DELETE_DATA_YN IN VARCHAR2,
98 P_NUM_PROCESSES IN NUMBER,
99 P_ASSIGNED_PROCESS IN VARCHAR2
100 );
101
102
103 FUNCTION delete_report_data return BOOLEAN;
104
105
106 FUNCTION Contract_Active_YN (p_chr_id IN OKL_K_HEADERS.ID%TYPE,
107 p_deal_type IN OKL_K_HEADERS.DEAL_TYPE%TYPE,
108 p_sts_code IN okc_k_headers_all_b.STS_CODE%TYPE)
109 return VARCHAR2;
110
111
112 END OKL_K_LINE_FIN_EXT_PVT;