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_BTCH_CASH_APPLIC dependencies on OKL_API

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

5: ---------------------------------------------------------------------------
6: -- GLOBAL VARIABLES
7: ---------------------------------------------------------------------------
8:
9: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13:

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

11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13:
14: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BTCH_CASH_APPLIC';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
18: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13:
14: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BTCH_CASH_APPLIC';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
18: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

13:
14: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BTCH_CASH_APPLIC';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
18: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 27: id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

23: -- GLOBAL DATASTRUCTURES
24: ---------------------------------------------------------------------------
25:
26: TYPE okl_batch_dtls_rec_type IS RECORD (
27: id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
28: irm_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
29: btc_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
30: btc_status VARCHAR2(30),
31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,

Line 28: irm_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

24: ---------------------------------------------------------------------------
25:
26: TYPE okl_batch_dtls_rec_type IS RECORD (
27: id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
28: irm_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
29: btc_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
30: btc_status VARCHAR2(30),
31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,

Line 29: btc_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

25:
26: TYPE okl_batch_dtls_rec_type IS RECORD (
27: id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
28: irm_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
29: btc_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
30: btc_status VARCHAR2(30),
31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,
33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,

Line 31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,

27: id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
28: irm_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
29: btc_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
30: btc_status VARCHAR2(30),
31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,
33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,

Line 32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,

28: irm_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
29: btc_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
30: btc_status VARCHAR2(30),
31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,
33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

Line 33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,

29: btc_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
30: btc_status VARCHAR2(30),
31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,
33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

Line 34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,

30: btc_status VARCHAR2(30),
31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,
33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
38: khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

Line 35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,

31: consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,
33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
38: khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
39: contract_number VARCHAR2(120), --DEFAULT Okl_Api.G_MISS_CHAR,

Line 36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

32: currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,
33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
38: khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
39: contract_number VARCHAR2(120), --DEFAULT Okl_Api.G_MISS_CHAR,
40: --Added by nikshah as part of Receipts Project

Line 37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

33: check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
38: khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
39: contract_number VARCHAR2(120), --DEFAULT Okl_Api.G_MISS_CHAR,
40: --Added by nikshah as part of Receipts Project
41: ar_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

Line 38: khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

34: receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
38: khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
39: contract_number VARCHAR2(120), --DEFAULT Okl_Api.G_MISS_CHAR,
40: --Added by nikshah as part of Receipts Project
41: ar_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
42: customer_number VARCHAR2(90),

Line 39: contract_number VARCHAR2(120), --DEFAULT Okl_Api.G_MISS_CHAR,

35: amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36: ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
38: khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
39: contract_number VARCHAR2(120), --DEFAULT Okl_Api.G_MISS_CHAR,
40: --Added by nikshah as part of Receipts Project
41: ar_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
42: customer_number VARCHAR2(90),
43: -- Added by varangan for DFF in Batch Receipts

Line 41: ar_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,

37: consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
38: khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
39: contract_number VARCHAR2(120), --DEFAULT Okl_Api.G_MISS_CHAR,
40: --Added by nikshah as part of Receipts Project
41: ar_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
42: customer_number VARCHAR2(90),
43: -- Added by varangan for DFF in Batch Receipts
44: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
45: dff_attribute1 ar_cash_receipts.attribute1%TYPE,

Line 60: ); --DEFAULT Okl_Api.G_MISS_CHAR);

56: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
57: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
58: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
59: dff_attribute15 ar_cash_receipts.attribute15%TYPE
60: ); --DEFAULT Okl_Api.G_MISS_CHAR);
61:
62: TYPE okl_btch_dtls_tbl_type IS TABLE OF okl_batch_dtls_rec_type
63: INDEX BY BINARY_INTEGER;
64: