1: PACKAGE BODY jai_cmn_rgm_recording_pkg AS
2: /* $Header: jai_cmn_rgm_rec.plb 120.14 2008/01/25 14:46:28 rchandan ship $ */
3:
4: /*----------------------------------------------------------------------------------------------------------------------------
5: CHANGE HISTORY for FILENAME: jai_rgm_trx_recording_pkg_b.sql
667: p_organization_type => p_organization_type,
668: p_organization_id => ln_org_id , -- Date 07/06/2007 by sacsethi for bug 6109941 - changed organization_id to org_id ( ou_level )
669: p_location_id => null,
670: p_tax_type => null,
671: p_account_name => jai_cmn_rgm_recording_pkg.ap_discount_accnt
672: );
673:
674: IF ln_discount_ccid IS NULL THEN
675: lv_codepath := jai_general_pkg.plot_codepath(18, lv_codepath);
861: p_curr_conv_rate IN NUMBER DEFAULT NULL
862: ) IS
863:
864: /* Added by Ramananda for bug#4407165 */
865: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.post_accounting';
866:
867: lv_reference10 GL_INTERFACE.reference10%type;
868: lv_reference23 GL_INTERFACE.reference23%type;
869: lv_reference24 GL_INTERFACE.reference24%type;
1176:
1177: EXCEPTION
1178: WHEN OTHERS THEN
1179: p_process_flag := jai_constants.unexpected_error;
1180: p_process_message := 'jai_cmn_rgm_recording_pkg.insert_reference failed with error - '||SQLERRM;
1181: fnd_file.put_line( fnd_file.log, p_process_message);
1182: END insert_reference;
1183:
1184: FUNCTION get_account(
1190: p_account_name IN VARCHAR2
1191: ) RETURN NUMBER IS
1192:
1193: /* Added by Ramananda for bug#4407165 */
1194: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.get_account';
1195:
1196: CURSOR c_orgn_account(cp_organization_id IN NUMBER, cp_location_id IN NUMBER, cp_register_type IN VARCHAR2) IS
1197: SELECT decode(cp_register_type,
1198: jai_constants.register_type_a, modvat_rm_account_id,
1308:
1309: lv_excise_cess := 'EXCISE-CESS'; /* Added by Ramananda - bug# 4546114*/
1310:
1311: /* following code is used to get the Discount Account in case of Payables */
1312: IF p_account_name = jai_cmn_rgm_recording_pkg.ap_discount_accnt THEN
1313: OPEN c_ap_system_parameters(p_organization_id);
1314: FETCH c_ap_system_parameters INTO ln_code_combination_id;
1315: CLOSE c_ap_system_parameters;
1316:
1455: p_sob_id OUT NOCOPY NUMBER
1456: ) IS
1457:
1458: /* Added by Ramananda for bug#4407165 */
1459: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.get_period_name';
1460: /* Bug 5243532. Added by Lakshmi Gopalsami
1461: Removed the cursors c_ou_sob_id and c_io_sob_id
1462: which is referring to hr_operating_units
1463: and org_organization_definitions respectively.
1551: p_account_entry_type OUT NOCOPY VARCHAR2
1552: ) IS
1553:
1554: /* Added by Ramananda for bug#4407165 */
1555: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.get_accounting_dtls';
1556:
1557: BEGIN
1558:
1559: -- following IF - ELSIF is valid for Organization Type OU w.r.t account_name and entry_type
1632:
1633: EXCEPTION
1634: WHEN OTHERS THEN
1635: p_process_flag := jai_constants.unexpected_error;
1636: p_process_message := 'jai_cmn_rgm_recording_pkg.update_reference (Stmt'||lv_statement||') Error Occured:'||SQLERRM;
1637: END update_reference;
1638:
1639:
1640: /* following procedure added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
2005: RETURN lv_attribute_value;
2006:
2007: END get_rgm_attribute_value;
2008:
2009: END jai_cmn_rgm_recording_pkg;