eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CASH_APPL_RULES dependencies on OKL_API

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;

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:

Line 17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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;

Line 18: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;

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;

Line 19: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;

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;

Line 37: CASH_RECEIPT_ID NUMBER := OKL_API.G_MISS_NUM,

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,

Line 38: AMOUNT 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,

Line 39: CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%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,

Line 40: CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,

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,

Line 41: CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,

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,

Line 42: RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,

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,

Line 43: RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_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,

Line 44: EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%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,
48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,

Line 45: EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,

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,

Line 46: EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,

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,

Line 47: REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,

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,

Line 48: REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,

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,

Line 49: REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%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,
53: GL_DATE DATE := OKL_API.G_MISS_DATE,

Line 51: RECEIPT_METHOD_ID NUMBER := OKL_API.G_MISS_NUM,

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,

Line 52: ORG_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,
56: DFF_ATTRIBUTE2 AR_CASH_RECEIPTS.ATTRIBUTE2%TYPE,

Line 53: GL_DATE DATE := OKL_API.G_MISS_DATE,

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,