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
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
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
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
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
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
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
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
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
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
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
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:
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;
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: ---------------------------------------------------------------------------