[Home] [Help]
PACKAGE: APPS.OKL_BPD_CAP_ADV_MON_PVT
Source
1 PACKAGE OKL_BPD_CAP_ADV_MON_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRAMSS.pls 120.2 2007/08/02 07:09:14 dcshanmu ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CASH_APPL_RULES';
11 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12 ---------------------------------------------------------------------------
13 -- Procedures and Functions
14 ---------------------------------------------------------------------------
15 ---------------------------------------------------------------------------
16 -- Record Type
17 ---------------------------------------------------------------------------
18 TYPE adv_rcpt_rec IS RECORD
19 (currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
20 ,currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
21 ,currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
22 ,currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
23 ,irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
24 ,check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
25 ,rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
26 ,contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
27 ,contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
28 ,customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
29 ,customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
30 ,gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
31 ,receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
32 ,comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
33 ,rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE DEFAULT NULL
34 ,xcr_id NUMBER DEFAULT NULL
35 ,icr_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
36 ,receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL
37 ,fully_applied_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE DEFAULT NULL
38 ,expired_flag OKL_TRX_CSH_RECEIPT_V.EXPIRED_FLAG%TYPE DEFAULT NULL
39 );
40
41 x_adv_rcpt_rec adv_rcpt_rec;
42 ---------------------------------------------------------------------------
43 -- GLOBAL DATASTRUCTURES
44 ---------------------------------------------------------------------------
45 l_xcav_tbl Okl_Xca_Pvt.xcav_tbl_type;
46
47 ---------------------------------------------------------------------------
48 -- PROCEDURE handle_advanced_manual_pay
49 ---------------------------------------------------------------------------
50 ---------------------------------------------------------------------------
51 -- Start of comments
52 --
53 -- Procedure Name : handle_advanced_manual_pay
54 -- Description : procedure for inserting the records in
55 -- table OKL_TRX_CSH_RECEIPT_B and OKL_EXT_CSH_RCPTS_B
56 -- Business Rules :
57 -- Parameters : p_api_version, p_init_msg_list, x_return_status,
58 -- x_msg_count, x_msg_data, p_adv_rcpt_rec, x_adv_rcpt_rec.
59 -- Version : 1.0
60 -- End of comments
61 ---------------------------------------------------------------------------
62 PROCEDURE handle_advanced_manual_pay ( p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,p_adv_rcpt_rec IN adv_rcpt_rec
68 ,x_adv_rcpt_rec OUT NOCOPY adv_rcpt_rec );
69 END okl_bpd_cap_adv_mon_pvt;