[Home] [Help]
PACKAGE: APPS.OKL_UPDT_CASH_DTLS
Source
1 PACKAGE okl_updt_cash_dtls AUTHID CURRENT_USER AS
2 /* $Header: OKLRCUPS.pls 120.2 2007/08/02 16:01:14 dcshanmu ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15
16 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_UPDT_CASH_DTLS';
17 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
18 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
19 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
20 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
21 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24
25
26 TYPE okl_cash_dtls_rec_type IS RECORD (
27 customer_id Okl_cnsld_ar_hdrs_b.ixx_Id%TYPE := Okl_Api.G_MISS_NUM,
28 customer_name hz_Parties.Party_Name%TYPE := Okl_Api.G_MISS_CHAR,
29 customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,
30 consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31 consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32 contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
33 contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
34 contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,
35 receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
36 ext_cash_apps_id NUMBER,
37 xtl_cash_apps_id NUMBER,
38 receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
39 ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
40 asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.
41 asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42 asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43 lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44 stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
45 stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46 outstanding_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM,
47 applied_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM);
48
49 TYPE okl_cash_dtls_tbl_type IS TABLE OF okl_cash_dtls_rec_type
50 INDEX BY BINARY_INTEGER;
51
52 ---------------------------------------------------------------------------
53 -- Procedures and Functions
54 ---------------------------------------------------------------------------
55
56 PROCEDURE update_cash_details ( p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_strm_tbl IN okl_cash_dtls_tbl_type
62 ,x_strm_tbl OUT NOCOPY okl_cash_dtls_tbl_type
63 );
64
65 END Okl_Updt_Cash_Dtls;