29: ---------------------------------------------------------------------------
30: -- Data Structures
31: ----------------------------------------------------------------------------
32: TYPE receipt_rec_type IS RECORD (
33: currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL,
34: currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL,
35: currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL,
36: currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL,
37: irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL,
30: -- Data Structures
31: ----------------------------------------------------------------------------
32: TYPE receipt_rec_type IS RECORD (
33: currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL,
34: currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL,
35: currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL,
36: currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL,
37: irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL,
38: rem_bank_acc_id okl_bpd_rcpt_mthds_uv.bank_account_id%TYPE DEFAULT NULL,
31: ----------------------------------------------------------------------------
32: TYPE receipt_rec_type IS RECORD (
33: currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL,
34: currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL,
35: currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL,
36: currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL,
37: irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL,
38: rem_bank_acc_id okl_bpd_rcpt_mthds_uv.bank_account_id%TYPE DEFAULT NULL,
39: contract_id OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL,
32: TYPE receipt_rec_type IS RECORD (
33: currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL,
34: currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL,
35: currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL,
36: currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL,
37: irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL,
38: rem_bank_acc_id okl_bpd_rcpt_mthds_uv.bank_account_id%TYPE DEFAULT NULL,
39: contract_id OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL,
40: contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL,
33: currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL,
34: currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL,
35: currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL,
36: currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL,
37: irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL,
38: rem_bank_acc_id okl_bpd_rcpt_mthds_uv.bank_account_id%TYPE DEFAULT NULL,
39: contract_id OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL,
40: contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL,
41: cust_acct_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL,
37: irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL,
38: rem_bank_acc_id okl_bpd_rcpt_mthds_uv.bank_account_id%TYPE DEFAULT NULL,
39: contract_id OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL,
40: contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL,
41: cust_acct_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL,
42: customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT NULL,
43: gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL,
44: payment_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(SYSDATE),
45: customer_site_use_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID%TYPE DEFAULT NULL,
39: contract_id OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL,
40: contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL,
41: cust_acct_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL,
42: customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT NULL,
43: gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL,
44: payment_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(SYSDATE),
45: customer_site_use_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID%TYPE DEFAULT NULL,
46: expiration_date DATE DEFAULT NULL,
47: payment_trxn_extension_id NUMBER
40: contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL,
41: cust_acct_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL,
42: customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT NULL,
43: gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL,
44: payment_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(SYSDATE),
45: customer_site_use_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID%TYPE DEFAULT NULL,
46: expiration_date DATE DEFAULT NULL,
47: payment_trxn_extension_id NUMBER
48: );