[Home] [Help]
1: PACKAGE BODY jai_cmn_rgm_recording_pkg AS
2: /* $Header: jai_cmn_rgm_rec.plb 120.37.12020000.4 2013/01/24 05:02:51 zxin ship $ */
3:
4: /*----------------------------------------------------------------------------------------------------------------------------
5: CHANGE HISTORY for FILENAME: jai_rgm_trx_recording_pkg_b.sql
982: p_organization_type => p_organization_type,
983: p_organization_id => ln_org_id , -- Date 07/06/2007 by sacsethi for bug 6109941 - changed organization_id to org_id ( ou_level )
984: p_location_id => null,
985: p_tax_type => null,
986: p_account_name => jai_cmn_rgm_recording_pkg.ap_discount_accnt
987: );
988:
989: IF ln_discount_ccid IS NULL THEN
990: lv_codepath := jai_general_pkg.plot_codepath(18, lv_codepath);
1213: p_attribute2 IN VARCHAR2 DEFAULT NULL
1214: ) IS
1215:
1216: /* Added by Ramananda for bug#4407165 */
1217: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.post_accounting';
1218:
1219: lv_reference10 GL_INTERFACE.reference10%type;
1220: lv_reference23 GL_INTERFACE.reference23%type;
1221: lv_reference24 GL_INTERFACE.reference24%type;
1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: p_process_flag := jai_constants.unexpected_error;
1625: p_process_message := 'jai_cmn_rgm_recording_pkg.insert_reference failed with error - '||SQLERRM;
1626: fnd_file.put_line( fnd_file.log, p_process_message);
1627: END insert_reference;
1628:
1629: FUNCTION get_account(
1635: p_account_name IN VARCHAR2
1636: ) RETURN NUMBER IS
1637:
1638: /* Added by Ramananda for bug#4407165 */
1639: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.get_account';
1640:
1641: CURSOR c_orgn_account(cp_organization_id IN NUMBER, cp_location_id IN NUMBER, cp_register_type IN VARCHAR2) IS
1642: SELECT decode(cp_register_type,
1643: jai_constants.register_type_a, modvat_rm_account_id,
1753:
1754: lv_excise_cess := 'EXCISE-CESS'; /* Added by Ramananda - bug# 4546114*/
1755:
1756: /* following code is used to get the Discount Account in case of Payables */
1757: IF p_account_name = jai_cmn_rgm_recording_pkg.ap_discount_accnt THEN
1758: OPEN c_ap_system_parameters(p_organization_id);
1759: FETCH c_ap_system_parameters INTO ln_code_combination_id;
1760: CLOSE c_ap_system_parameters;
1761:
1905: p_sob_id OUT NOCOPY NUMBER
1906: ) IS
1907:
1908: /* Added by Ramananda for bug#4407165 */
1909: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.get_period_name';
1910: /* Bug 5243532. Added by Lakshmi Gopalsami
1911: Removed the cursors c_ou_sob_id and c_io_sob_id
1912: which is referring to hr_operating_units
1913: and org_organization_definitions respectively.
2003: p_account_entry_type OUT NOCOPY VARCHAR2
2004: ) IS
2005:
2006: /* Added by Ramananda for bug#4407165 */
2007: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.get_accounting_dtls';
2008:
2009: BEGIN
2010:
2011: -- following IF - ELSIF is valid for Organization Type OU w.r.t account_name and entry_type
2084:
2085: EXCEPTION
2086: WHEN OTHERS THEN
2087: p_process_flag := jai_constants.unexpected_error;
2088: p_process_message := 'jai_cmn_rgm_recording_pkg.update_reference (Stmt'||lv_statement||') Error Occured:'||SQLERRM;
2089: END update_reference;
2090:
2091:
2092: /* following procedure added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
2716: FND_FILE.put_line( fnd_file.log, 'End of jai_rgm_trx_recording_pkg.exc_gain_loss_accounting procedure');
2717:
2718: END exc_gain_loss_accounting;
2719:
2720: END jai_cmn_rgm_recording_pkg;