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:
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_CASH_APPL_RULES';
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;
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15:
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CASH_APPL_RULES';
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;
15:
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CASH_APPL_RULES';
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;
33: l_xcav_tbl Okl_Xca_Pvt.xcav_tbl_type;
34: l_initialize Okl_Xca_Pvt.xcav_tbl_type;
35:
36: TYPE rcpt_rec_type IS RECORD (
37: CASH_RECEIPT_ID NUMBER := OKL_API.G_MISS_NUM,
38: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
39: CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
34: l_initialize Okl_Xca_Pvt.xcav_tbl_type;
35:
36: TYPE rcpt_rec_type IS RECORD (
37: CASH_RECEIPT_ID NUMBER := OKL_API.G_MISS_NUM,
38: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
39: CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
35:
36: TYPE rcpt_rec_type IS RECORD (
37: CASH_RECEIPT_ID NUMBER := OKL_API.G_MISS_NUM,
38: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
39: CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
36: TYPE rcpt_rec_type IS RECORD (
37: CASH_RECEIPT_ID NUMBER := OKL_API.G_MISS_NUM,
38: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
39: CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
37: CASH_RECEIPT_ID NUMBER := OKL_API.G_MISS_NUM,
38: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
39: CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
38: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
39: CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
39: CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
50: PAYMENT_TRX_EXTENSION_ID ar_cash_receipts.payment_trxn_extension_id%TYPE,
43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
50: PAYMENT_TRX_EXTENSION_ID ar_cash_receipts.payment_trxn_extension_id%TYPE,
51: RECEIPT_METHOD_ID NUMBER := OKL_API.G_MISS_NUM,
44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
50: PAYMENT_TRX_EXTENSION_ID ar_cash_receipts.payment_trxn_extension_id%TYPE,
51: RECEIPT_METHOD_ID NUMBER := OKL_API.G_MISS_NUM,
52: ORG_ID NUMBER := OKL_API.G_MISS_NUM,
45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
50: PAYMENT_TRX_EXTENSION_ID ar_cash_receipts.payment_trxn_extension_id%TYPE,
51: RECEIPT_METHOD_ID NUMBER := OKL_API.G_MISS_NUM,
52: ORG_ID NUMBER := OKL_API.G_MISS_NUM,
53: GL_DATE DATE := OKL_API.G_MISS_DATE,
47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
50: PAYMENT_TRX_EXTENSION_ID ar_cash_receipts.payment_trxn_extension_id%TYPE,
51: RECEIPT_METHOD_ID NUMBER := OKL_API.G_MISS_NUM,
52: ORG_ID NUMBER := OKL_API.G_MISS_NUM,
53: GL_DATE DATE := OKL_API.G_MISS_DATE,
54: DFF_ATTRIBUTE_CATEGORY AR_CASH_RECEIPTS.ATTRIBUTE_CATEGORY%TYPE,
55: DFF_ATTRIBUTE1 AR_CASH_RECEIPTS.ATTRIBUTE1%TYPE,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
50: PAYMENT_TRX_EXTENSION_ID ar_cash_receipts.payment_trxn_extension_id%TYPE,
51: RECEIPT_METHOD_ID NUMBER := OKL_API.G_MISS_NUM,
52: ORG_ID NUMBER := OKL_API.G_MISS_NUM,
53: GL_DATE DATE := OKL_API.G_MISS_DATE,
54: DFF_ATTRIBUTE_CATEGORY AR_CASH_RECEIPTS.ATTRIBUTE_CATEGORY%TYPE,
55: DFF_ATTRIBUTE1 AR_CASH_RECEIPTS.ATTRIBUTE1%TYPE,
56: DFF_ATTRIBUTE2 AR_CASH_RECEIPTS.ATTRIBUTE2%TYPE,
49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
50: PAYMENT_TRX_EXTENSION_ID ar_cash_receipts.payment_trxn_extension_id%TYPE,
51: RECEIPT_METHOD_ID NUMBER := OKL_API.G_MISS_NUM,
52: ORG_ID NUMBER := OKL_API.G_MISS_NUM,
53: GL_DATE DATE := OKL_API.G_MISS_DATE,
54: DFF_ATTRIBUTE_CATEGORY AR_CASH_RECEIPTS.ATTRIBUTE_CATEGORY%TYPE,
55: DFF_ATTRIBUTE1 AR_CASH_RECEIPTS.ATTRIBUTE1%TYPE,
56: DFF_ATTRIBUTE2 AR_CASH_RECEIPTS.ATTRIBUTE2%TYPE,
57: DFF_ATTRIBUTE3 AR_CASH_RECEIPTS.ATTRIBUTE3%TYPE,