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_TRNS_ACC_DSTRS

Line 795: FROM OKL_TRNS_ACC_DSTRS

791:
792: CURSOR dist_csr(v_source_id NUMBER,
793: v_source_table VARCHAR2) IS
794: SELECT POSTED_YN
795: FROM OKL_TRNS_ACC_DSTRS
796: WHERE source_id = v_source_id
797: AND source_table = v_source_table;
798:
799:

Line 849: FROM OKL_TRNS_ACC_DSTRS

845: --Bug 6154785 - Start of Changes
846: CURSOR posted_yn_csr(v_source_id NUMBER,
847: v_source_table VARCHAR2) IS
848: SELECT POSTED_YN
849: FROM OKL_TRNS_ACC_DSTRS
850: WHERE source_id = v_source_id
851: AND source_table = v_source_table;
852: --Bug 6154785 - End of Changes
853:

Line 857: FROM OKL_TRNS_ACC_DSTRS dist,

853:
854: CURSOR dist_csr(v_source_id NUMBER,
855: v_source_table VARCHAR2) IS
856: SELECT distinct xle.event_status_code
857: FROM OKL_TRNS_ACC_DSTRS dist,
858: XLA_EVENTS xle
859: WHERE dist.SOURCE_ID = v_source_id
860: AND dist.SOURCE_TABLE = v_source_table
861: AND dist.accounting_event_id = xle.event_id;

Line 964: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

960: l_lowest_index_dr NUMBER := 0;
961: l_highest_index_cr NUMBER := 0;
962: l_highest_index_dr NUMBER := 0;
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;

Line 965: l_formula_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

961: l_highest_index_cr NUMBER := 0;
962: l_highest_index_dr NUMBER := 0;
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:

Line 966: l_passed_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

962: l_highest_index_dr NUMBER := 0;
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;

Line 1387: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS

1383:
1384:
1385: -- Create the distributions
1386:
1387: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1388: IF(IS_DEBUG_PROCEDURE_ON) THEN
1389: BEGIN
1390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1391: END;

Line 1390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');

1386:
1387: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1388: IF(IS_DEBUG_PROCEDURE_ON) THEN
1389: BEGIN
1390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1391: END;
1392: END IF;
1393: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');

Line 1424: Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS(p_api_version => l_api_version

1420: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SET_OF_BOOKS_ID :'||l_tabv_tbl(i).SET_OF_BOOKS_ID);
1421: END IF;
1422: END LOOP;
1423:
1424: Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS(p_api_version => l_api_version
1425: ,p_init_msg_list => l_init_msg_list
1426: ,x_return_status => l_return_status
1427: ,x_msg_count => l_msg_count
1428: ,x_msg_data => l_msg_data

Line 1432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);

1428: ,x_msg_data => l_msg_data
1429: ,p_tabv_tbl => l_tabv_tbl
1430: ,x_tabv_tbl => l_tabv_tbl_out);
1431: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
1433: END IF;
1434: IF(IS_DEBUG_PROCEDURE_ON) THEN
1435: BEGIN
1436: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');

Line 1436: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');

1432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
1433: END IF;
1434: IF(IS_DEBUG_PROCEDURE_ON) THEN
1435: BEGIN
1436: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1437: END;
1438: END IF;
1439: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1440:

Line 1439: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS

1435: BEGIN
1436: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1437: END;
1438: END IF;
1439: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1440:
1441: x_return_status := l_return_status;
1442: x_tabv_tbl := l_tabv_tbl_out;
1443:

Line 1491: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

1487: l_rate NUMBER := 0;
1488: l_currency_conversion_rate NUMBER := 0;
1489: l_amount NUMBER := p_amount;
1490:
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;

Line 1492: l_formula_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

1488: l_currency_conversion_rate NUMBER := 0;
1489: l_amount NUMBER := p_amount;
1490:
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;

Line 1493: l_passed_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

1489: l_amount NUMBER := p_amount;
1490:
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:

Line 1597: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS

1593: --Bug 6127326 dpsingh end
1594: -- pass the set_of_books_id to the tapi for MG uptake.
1595: l_tabv_tbl(i).set_of_books_id := l_set_of_books_id;
1596:
1597: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1598: IF(IS_DEBUG_PROCEDURE_ON) THEN
1599: BEGIN
1600: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1601: END;

Line 1600: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');

1596:
1597: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1598: IF(IS_DEBUG_PROCEDURE_ON) THEN
1599: BEGIN
1600: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1601: END;
1602: END IF;
1603: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');

Line 1634: Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS(p_api_version => l_api_version

1630: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).set_of_books_id :'||l_tabv_tbl(i).set_of_books_id);
1631: END IF;
1632: END LOOP;
1633:
1634: Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS(p_api_version => l_api_version
1635: ,p_init_msg_list => l_init_msg_list
1636: ,x_return_status => l_return_status
1637: ,x_msg_count => l_msg_count
1638: ,x_msg_data => l_msg_data

Line 1642: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);

1638: ,x_msg_data => l_msg_data
1639: ,p_tabv_tbl => l_tabv_tbl
1640: ,x_tabv_tbl => l_tabv_tbl_out);
1641: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1642: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
1643: END IF;
1644: IF(IS_DEBUG_PROCEDURE_ON) THEN
1645: BEGIN
1646: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');

Line 1646: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');

1642: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
1643: END IF;
1644: IF(IS_DEBUG_PROCEDURE_ON) THEN
1645: BEGIN
1646: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1647: END;
1648: END IF;
1649: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1650:

Line 1649: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS

1645: BEGIN
1646: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1647: END;
1648: END IF;
1649: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1650:
1651: x_return_status := l_return_status;
1652: x_tabv_tbl := l_tabv_tbl_out;
1653:

Line 1690: FROM OKL_TRNS_ACC_DSTRS

1686:
1687:
1688: CURSOR dist_csr IS
1689: SELECT ID
1690: FROM OKL_TRNS_ACC_DSTRS
1691: WHERE source_id = p_source_id
1692: AND source_table = p_source_table;
1693:
1694: dist_rec dist_csr%ROWTYPE;

Line 1713: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs

1709: END LOOP;
1710:
1711: IF (l_tabv_tbl_in.COUNT > 0) THEN
1712:
1713: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs
1714: IF(L_DEBUG_ENABLED='Y') THEN
1715: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1716: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1717: END IF;

Line 1720: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');

1716: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1717: END IF;
1718: IF(IS_DEBUG_PROCEDURE_ON) THEN
1719: BEGIN
1720: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
1721: END;
1722: END IF;
1723: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => l_api_version,
1724: p_init_msg_list => p_init_msg_list,

Line 1723: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => l_api_version,

1719: BEGIN
1720: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
1721: END;
1722: END IF;
1723: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => l_api_version,
1724: p_init_msg_list => p_init_msg_list,
1725: x_return_status => x_return_status,
1726: x_msg_count => x_msg_count,
1727: x_msg_data => x_msg_data,

Line 1732: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');

1728: p_tabv_tbl => l_tabv_tbl_in,
1729: x_tabv_tbl => l_tabv_tbl_out);
1730: IF(IS_DEBUG_PROCEDURE_ON) THEN
1731: BEGIN
1732: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
1733: END;
1734: END IF;
1735: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs
1736: ELSE

Line 1735: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs

1731: BEGIN
1732: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
1733: END;
1734: END IF;
1735: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs
1736: ELSE
1737:
1738: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1739: p_msg_name => 'OKL_DIST_NOT_FOUND');

Line 1775: FROM OKL_TRNS_ACC_DSTRS

1771: IS
1772:
1773: CURSOR dist_csr(v_source_id NUMBER, v_source_table VARCHAR2) IS
1774: SELECT ID
1775: FROM OKL_TRNS_ACC_DSTRS
1776: WHERE source_id = v_source_id
1777: AND source_table = v_source_table;
1778:
1779:

Line 1806: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs

1802: END LOOP;
1803:
1804: CLOSE dist_csr;
1805:
1806: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
1807: IF(L_DEBUG_ENABLED='Y') THEN
1808: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1809: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1810: END IF;

Line 1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');

1809: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1810: END IF;
1811: IF(IS_DEBUG_PROCEDURE_ON) THEN
1812: BEGIN
1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
1814: END;
1815: END IF;
1816: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version
1817: ,p_init_msg_list => l_init_msg_list

Line 1816: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version

1812: BEGIN
1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
1814: END;
1815: END IF;
1816: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version
1817: ,p_init_msg_list => l_init_msg_list
1818: ,x_return_status => x_return_status
1819: ,x_msg_count => l_msg_count
1820: ,x_msg_data => l_msg_data

Line 1824: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');

1820: ,x_msg_data => l_msg_data
1821: ,p_tabv_tbl => l_dist_tbl);
1822: IF(IS_DEBUG_PROCEDURE_ON) THEN
1823: BEGIN
1824: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
1825: END;
1826: END IF;
1827: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
1828:

Line 1827: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs

1823: BEGIN
1824: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
1825: END;
1826: END IF;
1827: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
1828:
1829: END IF;
1830:
1831: END DELETE_DIST_AE;

Line 1847: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

1843: --FROM GL_LEDGERS_PUBLIC_V
1844: --WHERE LEDGER_ID = Okl_Accounting_Util.get_set_of_books_id;
1845:
1846: l_validate_holder VARCHAR2(1) := OKL_API.G_MISS_CHAR;
1847: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
1848: l_gl_date DATE;
1849:
1850:
1851: BEGIN

Line 1988: p_functional_curr IN OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE,

1984:
1985: --Added by gboomina on 14-Oct-2005
1986: --Bug 4662173 - Start of Changes
1987: PROCEDURE VALIDATE_PARAMS(p_dist_info_tbl IN DIST_INFO_TBL_TYPE,
1988: p_functional_curr IN OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE,
1989: x_return_status OUT NOCOPY VARCHAR2)
1990: IS
1991:
1992: l_validate_holder VARCHAR2(1) := OKL_API.G_MISS_CHAR;

Line 1993: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := p_functional_curr;

1989: x_return_status OUT NOCOPY VARCHAR2)
1990: IS
1991:
1992: l_validate_holder VARCHAR2(1) := OKL_API.G_MISS_CHAR;
1993: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := p_functional_curr;
1994: l_gl_date DATE;
1995: l_date DATE;
1996: l_first_rec CHAR := 'T';
1997: BEGIN

Line 2422: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

2418:
2419: tmpl_rec AVLV_REC_TYPE;
2420: l_tmpl_tbl avlv_tbl_type;
2421: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
2422: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
2423: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2424:
2425: l_api_name VARCHAR2(30) := 'CREATE_ACCOUNTING_DIST';
2426: l_api_version NUMBER := 1.0;

Line 2596: FROM OKL_TRNS_ACC_DSTRS_ALL

2592: CURSOR dist_exists_csr(p_source_id NUMBER,
2593: p_source_table VARCHAR2)
2594: IS
2595: SELECT 1
2596: FROM OKL_TRNS_ACC_DSTRS_ALL
2597: WHERE SOURCE_ID = p_source_id
2598: AND SOURCE_TABLE = p_source_table;
2599:
2600: CURSOR get_ext_hdr_csr(p_source_id NUMBER)

Line 3388: OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(p_api_version => l_api_version

3384: l_tabv_tbl(i).posted_yn := 'Y';
3385: END LOOP;
3386:
3387: --Update the distributions created with the Accounting Event Id
3388: OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(p_api_version => l_api_version
3389: ,p_init_msg_list => l_init_msg_list
3390: ,x_return_status => l_return_status
3391: ,x_msg_count => l_msg_count
3392: ,x_msg_data => l_msg_data

Line 3914: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

3910:
3911: tmpl_rec AVLV_REC_TYPE;
3912: l_tmpl_tbl avlv_tbl_type;
3913: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
3914: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
3915: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3916:
3917: l_api_name VARCHAR2(30) := 'CREATE_ACCOUNTING_DIST';
3918: l_api_version NUMBER := 1.0;

Line 4491: OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(p_api_version => l_api_version

4487: l_tabv_tbl_final(i).posted_yn := 'Y';
4488: END LOOP;
4489:
4490: --Update the accounting_event_id on the
4491: OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(p_api_version => l_api_version
4492: ,p_init_msg_list => l_init_msg_list
4493: ,x_return_status => l_return_status
4494: ,x_msg_count => l_msg_count
4495: ,x_msg_data => l_msg_data

Line 4557: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

4553:
4554: tmpl_rec AVLV_REC_TYPE;
4555: l_tmpl_tbl avlv_tbl_type;
4556: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
4557: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
4558: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4559:
4560: l_api_name VARCHAR2(30) := 'CREATE_ACCOUNTING_DIST';
4561: l_api_version NUMBER := 1.0;

Line 5039: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

5035:
5036: tmpl_rec AVLV_REC_TYPE;
5037: l_tmpl_tbl avlv_tbl_type;
5038: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
5039: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
5040: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5041:
5042: l_api_name VARCHAR2(30) := 'CREATE_ACCOUNTING_DIST';
5043: l_api_version NUMBER := 1.0;

Line 5156: FROM okl_trns_acc_dstrs_all dist,

5152:
5153: CURSOR get_acc_event_id(p_tcn_id IN NUMBER)
5154: IS
5155: SELECT distinct dist.accounting_event_id
5156: FROM okl_trns_acc_dstrs_all dist,
5157: okl_txl_cntrct_lns_all txl,
5158: okl_trx_contracts_all trx
5159: WHERE dist.source_id = txl.id
5160: AND txl.tcn_id = trx.id

Line 5417: OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(p_api_version => l_api_version

5413: l_tabv_tbl(i).posted_yn := 'Y';
5414: END LOOP;
5415:
5416: --Update the distributions created with the Accounting Event Id
5417: OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(p_api_version => l_api_version
5418: ,p_init_msg_list => l_init_msg_list
5419: ,x_return_status => l_return_status
5420: ,x_msg_count => l_msg_count
5421: ,x_msg_data => l_msg_data