[Home] [Help]
PACKAGE: APPS.OKL_CNTRCT_FIN_EXTRACT_PVT
Source
1 PACKAGE OKL_CNTRCT_FIN_EXTRACT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCFES.pls 120.2.12010000.6 2009/09/25 22:03:10 sechawla noship $ */
3
4 ------------------------------------------------------------------------------
5 -- Global Variables
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CNTRCT_FIN_EXTRACT_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 -- Variables for Contract Financial Report XML Publisher Report input parameters
14 --P_REPORT_DATE DATE; sechawla 25-sep-09 8890513
15 P_OPERATING_UNIT OKC_K_HEADERS_ALL_B.AUTHORING_ORG_ID%TYPE;
16 P_START_DATE_FROM DATE;
17 P_START_DATE_TO DATE;
18 P_AR_INFO_YN VARCHAR2(5);
19
20 P_BOOK_CLASS OKL_K_HEADERS.DEAL_TYPE%TYPE;
21 P_LEASE_PRODUCT OKL_PRODUCTS.NAME%TYPE;
22 P_CONTRACT_STATUS OKC_K_HEADERS_ALL_B.sts_code%TYPE; -- check
23 P_CUSTOMER_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE;
24 P_CUSTOMER_NAME HZ_PARTIES.party_name%TYPE;
25 P_SIC_CODE HZ_PARTIES.SIC_CODE%TYPE;
26 P_VENDOR_NUMBER po_vendors.segment1%TYPE;
27 P_VENDOR_NAME po_vendors.vendor_name%TYPE;
28 P_SALES_CHANNEL_CODE HZ_CUST_ACCOUNTS.SALES_CHANNEL_CODE%TYPE;
29 P_GEN_ACCRUAL varchar2(240);
30 P_SALES_TYPE_INDICATOR OKL_K_HEADERS.SALESTYPE_YN%TYPE;
31 P_END_DATE_FROM DATE;
32 P_END_DATE_TO DATE;
33 P_TERMINATE_DATE_FROM DATE;
34 P_TERMINATE_DATE_TO DATE;
35
36 P_DELETE_DATA_YN VARCHAR2(5);
37 L_REQUEST_ID NUMBER;
38 P_REQUEST_ID NUMBER;
39
40
41
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, sechawla 25-sep-09 8890513
54 P_START_DATE_FROM IN VARCHAR2,
55 P_START_DATE_TO IN VARCHAR2,
56 P_AR_INFO_YN IN VARCHAR2,
57 P_BOOK_CLASS IN VARCHAR2,
58 P_LEASE_PRODUCT IN VARCHAR2,
59 P_CONTRACT_STATUS IN VARCHAR2,
60 P_CUSTOMER_NUMBER IN VARCHAR2,
61 P_CUSTOMER_NAME IN VARCHAR2,
62 P_SIC_CODE IN VARCHAR2,
63 P_VENDOR_NUMBER IN VARCHAR2,
64 P_VENDOR_NAME IN VARCHAR2,
65 P_SALES_CHANNEL IN VARCHAR2,
66 P_GEN_ACCRUAL IN VARCHAR2,
67 P_END_DATE_FROM IN VARCHAR2,
68 P_END_DATE_TO IN VARCHAR2,
69 P_TERMINATE_DATE_FROM IN VARCHAR2,
70 P_TERMINATE_DATE_TO IN VARCHAR2,
71 P_DELETE_DATA_YN IN VARCHAR2,
72 p_num_processes IN NUMBER,
73 p_assigned_process IN VARCHAR2
74
75 );
76
77 PROCEDURE pull_extract_data (
78 p_api_version IN NUMBER
79 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2,
83 x_row_count OUT NOCOPY VARCHAR2,
84 P_OPERATING_UNIT IN NUMBER,
85 --P_REPORT_DATE IN VARCHAR2, sechawla 25-sep-09 8890513
86 P_START_DATE_FROM IN VARCHAR2,
87 P_START_DATE_TO IN VARCHAR2,
88 P_AR_INFO_YN IN VARCHAR2,
89 P_BOOK_CLASS IN VARCHAR2,
90 P_LEASE_PRODUCT IN VARCHAR2,
91 P_CONTRACT_STATUS IN VARCHAR2,
92 P_CUSTOMER_NUMBER IN VARCHAR2,
93 P_CUSTOMER_NAME IN VARCHAR2,
94 P_SIC_CODE IN VARCHAR2,
95 P_VENDOR_NUMBER IN VARCHAR2,
96 P_VENDOR_NAME IN VARCHAR2,
97 P_SALES_CHANNEL IN VARCHAR2,
98 P_GEN_ACCRUAL IN VARCHAR2,
99 P_END_DATE_FROM IN VARCHAR2,
100 P_END_DATE_TO IN VARCHAR2,
101 P_TERMINATE_DATE_FROM IN DATE,
102 P_TERMINATE_DATE_TO IN DATE,
103 P_DELETE_DATA_YN IN VARCHAR2,
104 p_num_processes IN NUMBER,
105 p_assigned_process IN VARCHAR2
106
107 );
108
109
110 FUNCTION AMOUNT_DUE_REMAINING(
111 p_CONTRACT_NUMBER IN VARCHAR2,
112 p_from_days IN number,
113 p_to_days IN number)
114 RETURN NUMBER;
115
116
117 FUNCTION accrual_status_yn (p_chr_id NUMBER) return VARCHAR2;
118 FUNCTION delete_report_data return BOOLEAN;
119 FUNCTION first_activation_date (p_chr_id NUMBER) return DATE;
120
121 END OKL_CNTRCT_FIN_EXTRACT_PVT;