6: --Declare id for record and table type implementations
7:
8: TYPE bpd_acc_rec_type IS RECORD
9: (
10: id NUMBER := Okl_Api.G_MISS_NUM, -- Id of the table
11: source_table VARCHAR2(100) := Okl_Api.G_MISS_CHAR, -- Source Name
12: source_trx_id NUMBER := Okl_Api.G_MISS_NUM -- Id of Source Transaction
13: );
14:
7:
8: TYPE bpd_acc_rec_type IS RECORD
9: (
10: id NUMBER := Okl_Api.G_MISS_NUM, -- Id of the table
11: source_table VARCHAR2(100) := Okl_Api.G_MISS_CHAR, -- Source Name
12: source_trx_id NUMBER := Okl_Api.G_MISS_NUM -- Id of Source Transaction
13: );
14:
15: TYPE bpd_acc_tbl_type IS TABLE OF bpd_acc_rec_type
8: TYPE bpd_acc_rec_type IS RECORD
9: (
10: id NUMBER := Okl_Api.G_MISS_NUM, -- Id of the table
11: source_table VARCHAR2(100) := Okl_Api.G_MISS_CHAR, -- Source Name
12: source_trx_id NUMBER := Okl_Api.G_MISS_NUM -- Id of Source Transaction
13: );
14:
15: TYPE bpd_acc_tbl_type IS TABLE OF bpd_acc_rec_type
16: INDEX BY BINARY_INTEGER;
18: ------------------------------------------------------------------------------
19: -- Global Variables
20: ------------------------------------------------------------------------------
21:
22: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
23: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCOUNTING_CALL_PVT';
24: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
20: ------------------------------------------------------------------------------
21:
22: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
23: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCOUNTING_CALL_PVT';
24: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
28: ------------------------------------------------------------------------------