20: SUBTYPE asev_tbl_type IS Okl_Acct_Sources_Pvt.asev_tbl_type;
21:
22:
23: TYPE TMPL_IDENTIFY_REC_TYPE IS RECORD
24: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
25: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
26: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
27: ADVANCE_ARREARS OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKL_API.G_MISS_CHAR,
28: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
21:
22:
23: TYPE TMPL_IDENTIFY_REC_TYPE IS RECORD
24: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
25: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
26: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
27: ADVANCE_ARREARS OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKL_API.G_MISS_CHAR,
28: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
29: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
22:
23: TYPE TMPL_IDENTIFY_REC_TYPE IS RECORD
24: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
25: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
26: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
27: ADVANCE_ARREARS OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKL_API.G_MISS_CHAR,
28: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
29: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
30: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
23: TYPE TMPL_IDENTIFY_REC_TYPE IS RECORD
24: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
25: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
26: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
27: ADVANCE_ARREARS OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKL_API.G_MISS_CHAR,
28: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
29: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
30: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
31:
24: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
25: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
26: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
27: ADVANCE_ARREARS OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKL_API.G_MISS_CHAR,
28: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
29: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
30: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
31:
32: -- Santonyr. Added to implement Securitization Chnages
25: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
26: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
27: ADVANCE_ARREARS OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKL_API.G_MISS_CHAR,
28: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
29: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
30: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
31:
32: -- Santonyr. Added to implement Securitization Chnages
33: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
26: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
27: ADVANCE_ARREARS OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKL_API.G_MISS_CHAR,
28: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
29: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
30: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
31:
32: -- Santonyr. Added to implement Securitization Chnages
33: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
29: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
30: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
31:
32: -- Santonyr. Added to implement Securitization Chnages
33: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
35: PRIOR_YEAR_YN OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKL_API.G_MISS_CHAR,
36:
37: -- 15-Oct-04 santonyr -- Added a new flag to template identification record
30: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
31:
32: -- Santonyr. Added to implement Securitization Chnages
33: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
35: PRIOR_YEAR_YN OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKL_API.G_MISS_CHAR,
36:
37: -- 15-Oct-04 santonyr -- Added a new flag to template identification record
38: -- for revenue recognition program Bug 3948354.
31:
32: -- Santonyr. Added to implement Securitization Chnages
33: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
35: PRIOR_YEAR_YN OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKL_API.G_MISS_CHAR,
36:
37: -- 15-Oct-04 santonyr -- Added a new flag to template identification record
38: -- for revenue recognition program Bug 3948354.
39: REV_REC_FLAG VARCHAR2(1) := 'N'
40:
41: );
42:
43: TYPE DIST_INFO_REC_TYPE IS RECORD
44: (SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
45: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
46: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
47: GL_REVERSAL_FLAG OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKL_API.G_MISS_CHAR,
48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,
41: );
42:
43: TYPE DIST_INFO_REC_TYPE IS RECORD
44: (SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
45: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
46: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
47: GL_REVERSAL_FLAG OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKL_API.G_MISS_CHAR,
48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,
49: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
42:
43: TYPE DIST_INFO_REC_TYPE IS RECORD
44: (SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
45: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
46: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
47: GL_REVERSAL_FLAG OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKL_API.G_MISS_CHAR,
48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,
49: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
50: CURRENCY_CODE OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
43: TYPE DIST_INFO_REC_TYPE IS RECORD
44: (SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
45: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
46: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
47: GL_REVERSAL_FLAG OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKL_API.G_MISS_CHAR,
48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,
49: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
50: CURRENCY_CODE OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
51: CURRENCY_CONVERSION_TYPE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_TYPE%TYPE
44: (SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
45: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
46: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
47: GL_REVERSAL_FLAG OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKL_API.G_MISS_CHAR,
48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,
49: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
50: CURRENCY_CODE OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
51: CURRENCY_CONVERSION_TYPE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_TYPE%TYPE
52: := OKL_API.G_MISS_CHAR,
45: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
46: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
47: GL_REVERSAL_FLAG OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKL_API.G_MISS_CHAR,
48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,
49: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
50: CURRENCY_CODE OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
51: CURRENCY_CONVERSION_TYPE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_TYPE%TYPE
52: := OKL_API.G_MISS_CHAR,
53: CURRENCY_CONVERSION_DATE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_DATE%TYPE
46: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
47: GL_REVERSAL_FLAG OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKL_API.G_MISS_CHAR,
48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,
49: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
50: CURRENCY_CODE OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
51: CURRENCY_CONVERSION_TYPE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_TYPE%TYPE
52: := OKL_API.G_MISS_CHAR,
53: CURRENCY_CONVERSION_DATE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_DATE%TYPE
54: := OKL_API.G_MISS_DATE,
48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,
49: AMOUNT NUMBER := OKL_API.G_MISS_NUM,
50: CURRENCY_CODE OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
51: CURRENCY_CONVERSION_TYPE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_TYPE%TYPE
52: := OKL_API.G_MISS_CHAR,
53: CURRENCY_CONVERSION_DATE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_DATE%TYPE
54: := OKL_API.G_MISS_DATE,
55:
56: -- Santonyr Added on 18-Nov-2002
50: CURRENCY_CODE OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
51: CURRENCY_CONVERSION_TYPE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_TYPE%TYPE
52: := OKL_API.G_MISS_CHAR,
53: CURRENCY_CONVERSION_DATE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_DATE%TYPE
54: := OKL_API.G_MISS_DATE,
55:
56: -- Santonyr Added on 18-Nov-2002
57: -- Multi Currency Changes
58:
55:
56: -- Santonyr Added on 18-Nov-2002
57: -- Multi Currency Changes
58:
59: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
60:
61: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
62: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
63:
57: -- Multi Currency Changes
58:
59: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
60:
61: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
62: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
63:
64: TYPE AMOUNT_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
65:
58:
59: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
60:
61: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
62: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
63:
64: TYPE AMOUNT_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
65:
66: --Added by gboomina for Accruals Performance
270: p_acct_date IN DATE);
271:
272:
273: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCOUNT_DIST_PVT' ;
274: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
275: g_sysdate DATE := TRUNC(SYSDATE);
276: G_gl_date DATE;
277:
278:
276: G_gl_date DATE;
277:
278:
279:
280: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
281: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
282: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
283: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
284: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
277:
278:
279:
280: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
281: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
282: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
283: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
284: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
285: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
280: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
281: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
282: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
283: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
284: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
285: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
286:
287:
288: -- Added by Santonyr on 26-Jul-2004 for the bug 3772490
287:
288: -- Added by Santonyr on 26-Jul-2004 for the bug 3772490
289:
290: TYPE template_amount_rec_type IS RECORD
291: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
292: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
293: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
294: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM);
295:
288: -- Added by Santonyr on 26-Jul-2004 for the bug 3772490
289:
290: TYPE template_amount_rec_type IS RECORD
291: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
292: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
293: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
294: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM);
295:
296: TYPE template_amount_tbl_type IS TABLE OF template_amount_rec_type INDEX BY BINARY_INTEGER;
289:
290: TYPE template_amount_rec_type IS RECORD
291: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
292: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
293: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
294: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM);
295:
296: TYPE template_amount_tbl_type IS TABLE OF template_amount_rec_type INDEX BY BINARY_INTEGER;
297:
290: TYPE template_amount_rec_type IS RECORD
291: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
292: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
293: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
294: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM);
295:
296: TYPE template_amount_tbl_type IS TABLE OF template_amount_rec_type INDEX BY BINARY_INTEGER;
297:
298: --Added by gboomina on 14-Oct-2005 for improving Accruals Performance
297:
298: --Added by gboomina on 14-Oct-2005 for improving Accruals Performance
299: --Bug 4662173 - Start of Changes
300: TYPE tmp_bulk_amount_rec_type IS RECORD
301: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
302: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
303: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
304: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
305: PARENT_INDEX_NUMBER NUMBER := Okl_Api.G_MISS_NUM);
298: --Added by gboomina on 14-Oct-2005 for improving Accruals Performance
299: --Bug 4662173 - Start of Changes
300: TYPE tmp_bulk_amount_rec_type IS RECORD
301: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
302: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
303: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
304: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
305: PARENT_INDEX_NUMBER NUMBER := Okl_Api.G_MISS_NUM);
306:
299: --Bug 4662173 - Start of Changes
300: TYPE tmp_bulk_amount_rec_type IS RECORD
301: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
302: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
303: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
304: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
305: PARENT_INDEX_NUMBER NUMBER := Okl_Api.G_MISS_NUM);
306:
307: TYPE tmp_bulk_amount_tbl_type IS TABLE OF tmp_bulk_amount_rec_type INDEX BY BINARY_INTEGER;
300: TYPE tmp_bulk_amount_rec_type IS RECORD
301: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
302: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
303: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
304: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
305: PARENT_INDEX_NUMBER NUMBER := Okl_Api.G_MISS_NUM);
306:
307: TYPE tmp_bulk_amount_tbl_type IS TABLE OF tmp_bulk_amount_rec_type INDEX BY BINARY_INTEGER;
308: --Bug 4662173 - End of Changes
301: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,
302: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,
303: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,
304: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
305: PARENT_INDEX_NUMBER NUMBER := Okl_Api.G_MISS_NUM);
306:
307: TYPE tmp_bulk_amount_tbl_type IS TABLE OF tmp_bulk_amount_rec_type INDEX BY BINARY_INTEGER;
308: --Bug 4662173 - End of Changes
309: