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_SYS_ACCT_OPTS

Line 24: FROM okl_sys_acct_opts;

20: --Cursor to get the Account Derivation Option
21: CURSOR get_acct_derivation_csr
22: IS
23: SELECT ACCOUNT_DERIVATION
24: FROM okl_sys_acct_opts;
25:
26: -- new table to cache the representation attributes.
27: -- Added by racheruv for MG uptake
28: g_ledger_tbl ledger_tbl_type;

Line 39: FROM okl_sys_acct_opts o,

35: IS
36: select o.set_of_books_id ledger_id,
37: g.short_name rep_code,
38: 'PRIMARY' rep_type
39: FROM okl_sys_acct_opts o,
40: gl_ledgers g
41: WHERE o.set_of_books_id = g.ledger_id
42: UNION ALL
43: select o.set_of_books_id ledger_id,

Line 46: FROM okl_sys_acct_opts o,

42: UNION ALL
43: select o.set_of_books_id ledger_id,
44: g.short_name rep_code,
45: 'SECONDARY' rep_type
46: FROM okl_sys_acct_opts o,
47: okl_system_params_all s,
48: fa_book_controls f,
49: gl_ledgers g
50: WHERE o.org_id = s.org_id

Line 927: FROM OKL_SYS_ACCT_OPTS;

923: CURSOR sao_csr IS
924: SELECT rounding_ccid
925: ,cc_apply_rounding_difference
926: ,ael_apply_rounding_difference
927: FROM OKL_SYS_ACCT_OPTS;
928:
929: CURSOR sob_csr (v_set_of_books_id NUMBER) IS
930: SELECT ROUNDING_CCID rounding_code_combination_id
931: FROM GL_LEDGERS_PUBLIC_V

Line 967: l_cc_apply_rounding_diff OKL_SYS_ACCT_OPTS.CC_APPLY_ROUNDING_DIFFERENCE%TYPE;

963: l_rounding_ccid NUMBER := 0;
964: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
965: l_formula_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
966: l_passed_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
967: l_cc_apply_rounding_diff OKL_SYS_ACCT_OPTS.CC_APPLY_ROUNDING_DIFFERENCE%TYPE;
968: l_ael_apply_rounding_diff OKL_SYS_ACCT_OPTS.AEL_APPLY_ROUNDING_DIFFERENCE%TYPE;
969:
970: l_api_version NUMBER := 1.0;
971: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

Line 968: l_ael_apply_rounding_diff OKL_SYS_ACCT_OPTS.AEL_APPLY_ROUNDING_DIFFERENCE%TYPE;

964: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
965: l_formula_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
966: l_passed_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
967: l_cc_apply_rounding_diff OKL_SYS_ACCT_OPTS.CC_APPLY_ROUNDING_DIFFERENCE%TYPE;
968: l_ael_apply_rounding_diff OKL_SYS_ACCT_OPTS.AEL_APPLY_ROUNDING_DIFFERENCE%TYPE;
969:
970: l_api_version NUMBER := 1.0;
971: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
972: l_msg_count NUMBER := 0;

Line 1009: -- OKL_SYS_ACCT_OPTS table. Starts Here ****

1005: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1006: END IF;
1007:
1008: -- The following three lines of code to be removed once we start populating rounding CCID in
1009: -- OKL_SYS_ACCT_OPTS table. Starts Here ****
1010:
1011: OPEN sob_csr(l_set_of_books_id);
1012: FETCH sob_csr INTO l_rounding_ccid;
1013: CLOSE sob_csr;

Line 1477: FROM OKL_SYS_ACCT_OPTS;

1473: CURSOR sao_csr IS
1474: SELECT rounding_ccid
1475: ,cc_apply_rounding_difference
1476: ,ael_apply_rounding_difference
1477: FROM OKL_SYS_ACCT_OPTS;
1478:
1479: CURSOR sob_csr (v_set_of_books_id NUMBER) IS
1480: SELECT ROUNDING_CCID rounding_code_combination_id
1481: FROM GL_LEDGERS_PUBLIC_V

Line 1495: l_cc_apply_rounding_diff OKL_SYS_ACCT_OPTS.CC_APPLY_ROUNDING_DIFFERENCE%TYPE;

1491: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
1492: l_formula_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
1493: l_passed_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
1494: l_rounding_ccid NUMBER := 0;
1495: l_cc_apply_rounding_diff OKL_SYS_ACCT_OPTS.CC_APPLY_ROUNDING_DIFFERENCE%TYPE;
1496: l_ael_apply_rounding_diff OKL_SYS_ACCT_OPTS.AEL_APPLY_ROUNDING_DIFFERENCE%TYPE;
1497:
1498:
1499: l_api_version NUMBER := 1.0;

Line 1496: l_ael_apply_rounding_diff OKL_SYS_ACCT_OPTS.AEL_APPLY_ROUNDING_DIFFERENCE%TYPE;

1492: l_formula_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
1493: l_passed_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
1494: l_rounding_ccid NUMBER := 0;
1495: l_cc_apply_rounding_diff OKL_SYS_ACCT_OPTS.CC_APPLY_ROUNDING_DIFFERENCE%TYPE;
1496: l_ael_apply_rounding_diff OKL_SYS_ACCT_OPTS.AEL_APPLY_ROUNDING_DIFFERENCE%TYPE;
1497:
1498:
1499: l_api_version NUMBER := 1.0;
1500: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

Line 1509: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;

1505:
1506:
1507: --Added by kthiruva on 06-Feb-2006 for SLA Uptake
1508: --Bug 5707866 - Start of Changes
1509: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
1510: --Bug 5707866 - End of Changes
1511:
1512:
1513: BEGIN

Line 1544: -- OKL_SYS_ACCT_OPTS table. Starts Here ****

1540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1541: END IF;
1542:
1543: -- The following three lines of code to be removed once we start populating rounding CCID in
1544: -- OKL_SYS_ACCT_OPTS table. Starts Here ****
1545:
1546: OPEN sob_csr(l_set_of_books_id);
1547: FETCH sob_csr INTO l_rounding_ccid;
1548: CLOSE sob_csr;

Line 2464: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;

2460: WHERE id = l_sty_type_id ;
2461:
2462: --Added by kthiruva on 06-Feb-2007 for SLA Uptake
2463: --Bug 5707866 - Start of Changes
2464: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
2465: l_tcn_id NUMBER;
2466: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
2467: l_msg_count NUMBER := 0;
2468: l_msg_data VARCHAR2(2000);

Line 2582: FROM OKL_SYS_ACCT_OPTS SAO,

2578:
2579: CURSOR get_gl_short_name_csr
2580: IS
2581: SELECT GL.SHORT_NAME
2582: FROM OKL_SYS_ACCT_OPTS SAO,
2583: GL_LEDGERS GL
2584: WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
2585:
2586: CURSOR get_trx_type(p_try_id NUMBER)

Line 3966: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;

3962: p_acc_gen_tbl_ret acc_gen_primary_key;
3963: l_tmp_amt_tbl_count NUMBER := 0;
3964: --Added by kthiruva on 06-Feb-2007 for SLA Uptake
3965: --Bug 5707866 - Start of Changes
3966: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
3967: l_tcn_id NUMBER;
3968: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
3969: l_msg_count NUMBER := 0;
3970: l_msg_data VARCHAR2(2000);

Line 3999: FROM OKL_SYS_ACCT_OPTS SAO,

3995:
3996: CURSOR get_gl_short_name_csr
3997: IS
3998: SELECT GL.SHORT_NAME
3999: FROM OKL_SYS_ACCT_OPTS SAO,
4000: GL_LEDGERS GL
4001: WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
4002: --Bug 5707866 - End of Changes
4003:

Line 4604: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;

4600: l_tmp_amt_tbl_count NUMBER := 0;
4601: --Added by kthiruva on 06-Feb-2007 for SLA Uptake
4602: --Bug 5707866 - Start of Changes
4603: l_ctxt_val_tbl CTXT_VAL_TBL_TYPE;
4604: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
4605: l_tcn_id NUMBER;
4606: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
4607: l_msg_count NUMBER := 0;
4608: l_msg_data VARCHAR2(2000);

Line 5080: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;

5076: WHERE id = l_sty_type_id ;
5077:
5078: --Added by kthiruva on 06-Feb-2007 for SLA Uptake
5079: --Bug 5707866 - Start of Changes
5080: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
5081: l_tcn_id NUMBER := p_trx_header_id;
5082: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5083: l_msg_count NUMBER := 0;
5084: l_msg_data VARCHAR2(2000);

Line 5143: FROM OKL_SYS_ACCT_OPTS SAO,

5139:
5140: CURSOR get_gl_short_name_csr
5141: IS
5142: SELECT GL.SHORT_NAME
5143: FROM OKL_SYS_ACCT_OPTS SAO,
5144: GL_LEDGERS GL
5145: WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
5146:
5147: CURSOR get_trx_type(p_try_id NUMBER)