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

Line 24: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,

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,

Line 25: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,

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,

Line 26: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,

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,

Line 27: ADVANCE_ARREARS OKL_AE_TEMPLATES.ADVANCE_ARREARS%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:

Line 28: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,

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

Line 29: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,

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,

Line 30: FACTORING_CODE OKL_AE_TEMPLATES.FAC_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,

Line 33: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%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

Line 34: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%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
38: -- for revenue recognition program Bug 3948354.

Line 35: PRIOR_YEAR_YN OKL_AE_TEMPLATES.PRIOR_YEAR_YN%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.
39: REV_REC_FLAG VARCHAR2(1) := 'N'

Line 44: (SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,

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,

Line 45: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%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,

Line 46: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,

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,

Line 47: GL_REVERSAL_FLAG OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%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

Line 48: POST_TO_GL OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKL_API.G_MISS_CHAR,

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,

Line 49: AMOUNT 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,
53: CURRENCY_CONVERSION_DATE OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_DATE%TYPE

Line 50: CURRENCY_CODE OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%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
54: := OKL_API.G_MISS_DATE,

Line 52: := 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,
55:
56: -- Santonyr Added on 18-Nov-2002

Line 54: := OKL_API.G_MISS_DATE,

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:

Line 59: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,

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:

Line 61: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,

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:

Line 62: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);

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

Line 274: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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:

Line 280: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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;

Line 281: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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';

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

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

Line 291: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,

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:

Line 292: AMOUNT NUMBER := Okl_Api.G_MISS_NUM,

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;

Line 293: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,

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:

Line 294: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM);

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

Line 301: (TEMPLATE_ID NUMBER := Okl_Api.G_MISS_NUM,

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);

Line 302: AMOUNT 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:

Line 303: FORMULA_USED VARCHAR2(3) := Okl_Api.G_MISS_CHAR,

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;

Line 304: STREAM_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,

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

Line 305: PARENT_INDEX_NUMBER NUMBER := Okl_Api.G_MISS_NUM);

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: