[Home] [Help]
348: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
349: jctl.customer_trx_id = pn_customer_trx_id AND
350: jcttl.tax_id = jtc.tax_id AND
351: jtc.tax_type = jrttv.tax_type AND
352: regime_code = jai_constants.service_regime AND
353: jtc.org_id = pn_org_id ;
354:
355: CURSOR cur_jai_trx_header(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)
356: IS
685: close c_get_context;
686: --End bug#8232976
687: lv_projects_flag := is_this_projects_context(lv_invoice_context);
688: if lv_called_from = gv_projects_invoices
689: and lv_projects_flag = jai_constants.no
690: then
691: -- no need to process this customer trx
692: goto continue_with_next;
693:
691: -- no need to process this customer trx
692: goto continue_with_next;
693:
694: elsif lv_called_from <> gv_projects_invoices
695: and lv_projects_flag = jai_constants.yes
696: then
697: -- no need to process this customer trx
698: goto continue_with_next;
699: end if;
766: , xv_process_flag => lv_process_status
767: , xv_process_message => lv_process_message);
768: END IF;
769:
770: IF lv_process_status <> jai_constants.successful
771: THEN
772: RAISE error_from_called_unit;
773: END IF; -- lv_process_status <> 'SS'
774: -----------------------------------------------------------------------
812: /*Bug 11735678 - Populate VAT Invoice Number into Base AR Reference column only if it is imported from ORDER ENTRY
813: Projects Imported AR Invoices is not within the scope of VAT Invoice Number on AR Invoice ER*/
814: fnd_file.put_line(FND_FILE.LOG , 'lv_called_from ' || lv_called_from);
815: fnd_file.put_line(FND_FILE.LOG , 'lv_projects_flag ' || lv_projects_flag);
816: /*IF (lv_called_from <> gv_projects_invoices and lv_projects_flag = jai_constants.no)
817: THEN*/
818: --Commented by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
819: --For Porjects Invoices also need to generate service invoice and display on AR Workbench
820:
821: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 Begin*/
822: OPEN cur_st_taxes_exist(temp_rec.customer_trx_id,temp_rec.org_id);
823: FETCH cur_st_taxes_exist INTO ln_regime_id,lv_regime_code;
824: CLOSE cur_st_taxes_exist;
825: IF UPPER(NVL(lv_regime_code,'####')) = jai_constants.service_regime THEN
826: OPEN c_st_invoice_cur(temp_rec.customer_trx_id);
827: FETCH c_st_invoice_cur INTO lv_st_inv_number;
828: CLOSE c_st_invoice_cur;
829:
851: p_invoice_number => lv_st_inv_number ,
852: p_process_flag => lv_process_status ,
853: p_process_msg => lv_process_message
854: );
855: IF lv_process_status = jai_constants.successful THEN
856: IF lv_st_inv_number IS NOT NULL THEN
857: fnd_file.put_line(FND_FILE.LOG,
858: 'Service Tax Invoice Number has been successfully generated.lv_st_inv_number '||lv_st_inv_number);
859: update jai_ar_trxs set st_inv_number = lv_st_inv_number
882: -- Initial the invoice number
883: lv_excise_invoice_no := NULL;
884: lv_vat_invoice_no := NULL;
885:
886: IF (lv_called_from <> gv_projects_invoices and lv_projects_flag = jai_constants.no) THEN
887: OPEN c_delivery(temp_rec.customer_trx_id, v_org_id);
888: FETCH c_delivery
889: INTO ln_delivery_id, ln_order_line_id;
890: CLOSE c_delivery;
959: END IF; --lv_excise_invoice_no IS NOT NULL
960:
961: END IF;--nvl(var_error_invoice, 'N') <> 'Y'
962:
963: --END IF; /*IF (lv_called_from <> gv_projects_invoices and lv_projects_flag = jai_constants.no)*/
964: --Commented by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
965: --For Porjects Invoices also need to generate service invoice and display on AR Workbench
966:
967: END;
1036: SELECT cust_trx_line_gl_dist_id
1037: FROM ra_cust_trx_line_gl_dist_all
1038: WHERE customer_trx_id = cp_customer_trx_id
1039: AND account_class = lv_account_class_rec --'REC'
1040: AND latest_rec_flag = jai_constants.yes; --'Y';
1041:
1042: /* Ramananda for bug#5219225. */
1043: lv_object_name user_procedures.object_name%type ;
1044: lv_procedure_name user_procedures.procedure_name%type ;
1045: ln_exists NUMBER := 0 ;
1046: lv_sqlstmt VARCHAR2(2000) ;
1047:
1048: BEGIN
1049: p_process_status := jai_constants.successful;
1050: p_process_message := NULL;
1051:
1052: --get the cust_trx_line_gl_dist_id for the REC row from ra_cust_trx_line_gl_dist_all
1053: open cur_gl_dist(p_customer_trx_id);
1139: /* Ramananda for bug#5219225. END */
1140:
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: p_process_status := jai_constants.unexpected_error;
1144: p_process_message := SUBSTR(SQLERRM,1,300);
1145: END maintain_mrc;
1146: --=========================================================================================--
1147: --This procedure maintains the history of ar_receivable_applications_all in jai_ar_rec_appl_audits
1167: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1168: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1169:
1170: BEGIN
1171: p_process_status := jai_constants.successful;
1172: p_process_message := NULL;
1173:
1174: --set the values for WHO columns
1175: ln_last_updated_by := TO_NUMBER(fnd_profile.value('USER_ID'));
1251:
1252: END IF;
1253: EXCEPTION
1254: WHEN OTHERS THEN
1255: p_process_status := jai_constants.unexpected_error;
1256: p_process_message := SUBSTR(SQLERRM,1,300);
1257: END maintain_applications;
1258:
1259: --=========================================================================================--
1285: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1286: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1287: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1288: BEGIN
1289: p_process_status := jai_constants.successful;
1290: p_process_message := NULL;
1291:
1292: --set the values for WHO columns
1293: ln_last_updated_by := TO_NUMBER(fnd_profile.value('USER_ID'));
1404:
1405: END IF;
1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: p_process_status := jai_constants.unexpected_error;
1409: p_process_message := SUBSTR(SQLERRM,1,300);
1410: END maintain_schedules;
1411:
1412: PROCEDURE insert_trx_line_gl_dist(p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
1452: lv_sqlstmt VARCHAR2(2000);
1453:
1454: ln_cust_trx_line_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
1455: BEGIN
1456: p_process_status := jai_constants.successful;
1457: p_process_message := NULL;
1458:
1459: --get the value for cust_trx_line_gl_dist_id
1460: OPEN cur_gl_seq;
1526: /* Ramananda for bug#5219225. END */
1527:
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: p_process_status := jai_constants.unexpected_error;
1531: p_process_message := SUBSTR(SQLERRM,1,300);
1532: END insert_trx_line_gl_dist;
1533: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
1534: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
1553: p_process_status OUT NOCOPY VARCHAR2,
1554: p_process_message OUT NOCOPY VARCHAR2)
1555: IS
1556: BEGIN
1557: p_process_status := jai_constants.successful;
1558: p_process_message := NULL;
1559:
1560: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,
1561: taxable_amount,
1598: p_interface_line_attribute6,
1599: p_interface_line_attribute3);
1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: p_process_status := jai_constants.unexpected_error;
1603: p_process_message := SUBSTR(SQLERRM,1,300);
1604: END insert_trx_lines;
1605:
1606: /*added the following procedure for bug#8325824*/
1636: 'N',
1637: null);
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: p_process_status := jai_constants.unexpected_error;
1641: p_process_message := SUBSTR(SQLERRM,1,300);
1642: END insert_ar_dist_entries;
1643:
1644:
1687: WHERE object_name = cp_object_name
1688: AND procedure_name = cp_procedure_name ;
1689:
1690: BEGIN
1691: p_process_status := jai_constants.successful;
1692: p_process_message := NULL;
1693:
1694: /* Ramananda for bug#5219225. START */
1695: lv_object_name := 'AR_MRC_ENGINE' ;
1747: AND line_type IN ('TAX','FREIGHT');
1748:
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: p_process_status := jai_constants.unexpected_error;
1752: p_process_message := SUBSTR(SQLERRM,1,300);
1753: END delete_trx_data;
1754:
1755:
2114: start_date,
2115: end_date,
2116: closing_status
2117: FROM gl_period_statuses
2118: WHERE application_id = jai_constants.gl_application_id
2119: AND set_of_books_id = cp_sob_id
2120: AND closing_status IN('O', 'F')
2121: AND cp_accounting_date BETWEEN start_date
2122: AND end_date
2213: IF p_debug = 'Y' THEN
2214: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');
2215: END IF;
2216:
2217: IF lv_process_status <> jai_constants.successful THEN
2218: p_process_status := lv_process_status;
2219: p_process_message := lv_process_message;
2220: goto EXIT_POINT;
2221: END IF;
2263: IF p_debug = 'Y' THEN
2264: fnd_file.put_line(FND_FILE.LOG, 'After delete_trx_data');
2265: END IF;
2266:
2267: IF lv_process_status <> jai_constants.successful THEN
2268: p_process_status := lv_process_status;
2269: p_process_message := lv_process_message;
2270: goto EXIT_POINT;
2271: END IF;
2404: IF p_debug = 'Y' THEN
2405: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_lines');
2406: END IF;
2407:
2408: IF lv_process_status <> jai_constants.successful THEN
2409: p_process_status := lv_process_status;
2410: p_process_message := lv_process_message;
2411: goto EXIT_POINT;
2412: END IF;
2464: END IF;
2465:
2466:
2467:
2468: IF lv_process_status <> jai_constants.successful THEN
2469: p_process_status := lv_process_status;
2470: p_process_message := lv_process_message;
2471: goto EXIT_POINT;
2472: END IF;
2515: WHERE customer_trx_id = p_customer_trx_id
2516: AND account_class = lv_account_class_rec --'REC'
2517: AND latest_rec_flag = 'Y';
2518:
2519: IF lv_process_status <> jai_constants.successful THEN
2520:
2521: p_process_status := lv_process_status;
2522: p_process_message := lv_process_message;
2523: goto EXIT_POINT;
2594: start_date,
2595: end_date,
2596: closing_status
2597: FROM gl_period_statuses
2598: WHERE application_id = jai_constants.gl_application_id
2599: AND set_of_books_id = lt_sob_id_tab(ln_row_count)
2600: AND start_date > lt_gl_date(ln_row_count)
2601: AND adjustment_period_flag = 'N' -- mmurtuza for bug 16181417
2602: ORDER BY period_year,
2664: p_payment_audit_id => ln_payment_audit_id,
2665: p_process_status => lv_process_status,
2666: p_process_message => lv_process_message);
2667:
2668: IF lv_process_status <> jai_constants.successful THEN
2669: p_process_status := lv_process_status;
2670: p_process_message := lv_process_message;
2671: goto EXIT_POINT;
2672: END IF;
2694: p_payment_audit_id => ln_payment_audit_id,
2695: p_process_status => lv_process_status,
2696: p_process_message => lv_process_message);
2697:
2698: IF lv_process_status <> jai_constants.successful THEN
2699: p_process_status := lv_process_status;
2700: p_process_message := lv_process_message;
2701: goto EXIT_POINT;
2702: END IF;
2824: p_payment_audit_id => ln_payment_audit_id,
2825: p_process_status => lv_process_status,
2826: p_process_message => lv_process_message);
2827:
2828: IF lv_process_status <> jai_constants.successful THEN
2829: p_process_status := lv_process_status;
2830: p_process_message := lv_process_message;
2831: goto EXIT_POINT;
2832: END IF;
2873: p_payment_audit_id => ln_payment_audit_id,
2874: p_process_status => lv_process_status,
2875: p_process_message => lv_process_message);
2876:
2877: IF lv_process_status <> jai_constants.successful THEN
2878: p_process_status := lv_process_status;
2879: p_process_message := lv_process_message;
2880: goto EXIT_POINT;
2881: END IF;
2902: p_rec_appl_audit_id => ln_rec_appl_audit_id,
2903: p_process_status => lv_process_status,
2904: p_process_message => lv_process_message);
2905:
2906: IF lv_process_status <> jai_constants.successful THEN
2907: p_process_status := lv_process_status;
2908: p_process_message := lv_process_message;
2909: goto EXIT_POINT;
2910: END IF;
2950: p_rec_appl_audit_id => ln_rec_appl_audit_id,
2951: p_process_status => lv_process_status,
2952: p_process_message => lv_process_message);
2953:
2954: IF lv_process_status <> jai_constants.successful THEN
2955: p_process_status := lv_process_status;
2956: p_process_message := lv_process_message;
2957: goto EXIT_POINT;
2958: END IF;
2983: END IF;
2984:
2985: ELSE --over_application condition
2986: p_process_message := 'CM : Allow Over application on invoice is not allowed , hence not processing the taxes on the credit memo';
2987: p_process_status := jai_constants.expected_error;
2988:
2989: goto EXIT_POINT;
2990:
2991: END IF ;
3084: p_payment_audit_id => ln_payment_audit_id,
3085: p_process_status => lv_process_status,
3086: p_process_message => lv_process_message);
3087:
3088: IF lv_process_status <> jai_constants.successful THEN
3089: p_process_status := lv_process_status;
3090: p_process_message := lv_process_message;
3091: goto EXIT_POINT;
3092: END IF;
3137: p_process_message => lv_process_message);
3138:
3139: fnd_file.put_line(FND_FILE.LOG, 'Out ln_payment_audit_id '||ln_payment_audit_id);
3140:
3141: IF lv_process_status <> jai_constants.successful THEN
3142: p_process_status := lv_process_status;
3143: p_process_message := lv_process_message;
3144: goto EXIT_POINT;
3145: END IF;
3162: p_called_from => 7/13/2007,
3163: p_process_status => lv_process_status,
3164: p_process_message => lv_process_message);
3165:
3166: IF lv_process_status <> jai_constants.successful THEN
3167: p_process_status := lv_process_status;
3168: p_process_message := lv_process_message;
3169: goto EXIT_POINT;
3170: END IF;
3175: EXCEPTION
3176: WHEN resource_busy THEN
3177: fnd_file.put_line(FND_FILE.LOG,'Resource Busy,record '||p_customer_trx_id||' has been locked by another resource');
3178: p_process_message:= ' Resource Busy,record '||p_customer_trx_id||' has been locked by another resource ';
3179: p_process_status := jai_constants.unexpected_error;
3180:
3181: WHEN LOCALIZATION_TAX_NOT_DEFINED THEN
3182: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');
3183: p_process_message:= ' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ';
3180:
3181: WHEN LOCALIZATION_TAX_NOT_DEFINED THEN
3182: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');
3183: p_process_message:= ' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ';
3184: p_process_status := jai_constants.expected_error;
3185:
3186: WHEN ROUNDING_ACCOUNT_NOT_DEFINED THEN
3187: fnd_file.put_line(FND_FILE.LOG, lv_process_message );
3188: p_process_message := lv_process_message;
3189: p_process_status := lv_process_status;
3190:
3191: WHEN OTHERS THEN
3192: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
3193: p_process_status := jai_constants.unexpected_error;
3194: p_process_message :=SUBSTR(SQLERRM,1,120);
3195:
3196: UPDATE JAI_AR_TRX_INS_LINES_T
3197: SET error_flag = 'R',
3393: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
3394: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
3395: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
3396: Where a.tax_id = b.tax_id
3397: AND b.tax_type = jai_constants.tax_type_freight );
3398:
3399: --added 12-Mar-2002
3400: CURSOR tax_type IS SELECT b.tax_type t_type,a.customer_trx_line_id line_id
3401: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
3713: DELETE JAI_AR_TRX_INS_LINES_T
3714: WHERE customer_trx_id = P_CUSTOMER_TRX_ID
3715: and link_to_cust_trx_line_id = P_LINK_LINE_ID
3716: and customer_trx_line_id = tax_type_rec.line_id
3717: and tax_type_rec.t_type <> jai_constants.tax_type_freight;
3718: v_sql_num :=8;
3719: v_sql_count := SQL%ROWCOUNT;
3720: END IF;
3721: END LOOP;
4412: -- following function added for bug#6012570 (5876390) --> revoked the comments, 6012570
4413: function is_this_projects_context(pv_context in varchar2) return varchar2 is
4414: begin
4415: if jai_ar_rctla_trigger_pkg.is_this_projects_context(pv_context) then
4416: return jai_constants.yes;
4417: else
4418: return jai_constants.no;
4419: end if;
4420: end is_this_projects_context;
4414: begin
4415: if jai_ar_rctla_trigger_pkg.is_this_projects_context(pv_context) then
4416: return jai_constants.yes;
4417: else
4418: return jai_constants.no;
4419: end if;
4420: end is_this_projects_context;
4421: -- End commented by kunkumar for bug#6066813*/, revoked the comments, 6012570
4422:
4513: FROM
4514: jai_rgm_definitions rgm_def
4515: , jai_rgm_registrations tax_rgm
4516: , jai_rgm_registrations acc_rgm
4517: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
4518: AND tax_rgm.regime_id = rgm_def.regime_id
4519: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
4520: AND tax_rgm.attribute_code = pv_tax_type
4521: AND tax_rgm.regime_id = acc_rgm.regime_id
4515: , jai_rgm_registrations tax_rgm
4516: , jai_rgm_registrations acc_rgm
4517: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
4518: AND tax_rgm.regime_id = rgm_def.regime_id
4519: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
4520: AND tax_rgm.attribute_code = pv_tax_type
4521: AND tax_rgm.regime_id = acc_rgm.regime_id
4522: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
4523: --AND acc_rgm.attribute_code = jai_constants.recovery_interim -- --|oved by Jia for fixed bug#7205349 on 20-Apr-2009
4518: AND tax_rgm.regime_id = rgm_def.regime_id
4519: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
4520: AND tax_rgm.attribute_code = pv_tax_type
4521: AND tax_rgm.regime_id = acc_rgm.regime_id
4522: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
4523: --AND acc_rgm.attribute_code = jai_constants.recovery_interim -- --|oved by Jia for fixed bug#7205349 on 20-Apr-2009
4524: -- AND acc_rgm.attribute_code = jai_constants.liability -- Modified by Jia for fixed bug#8474445 on 30-Apr-2009, use liability account to replace liability interim account
4525:
4526: AND acc_rgm.attribute_code = jai_constants.liability_interim --Added by Bo Li for bug#9771955 on 2010-06-04
4519: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
4520: AND tax_rgm.attribute_code = pv_tax_type
4521: AND tax_rgm.regime_id = acc_rgm.regime_id
4522: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
4523: --AND acc_rgm.attribute_code = jai_constants.recovery_interim -- --|oved by Jia for fixed bug#7205349 on 20-Apr-2009
4524: -- AND acc_rgm.attribute_code = jai_constants.liability -- Modified by Jia for fixed bug#8474445 on 30-Apr-2009, use liability account to replace liability interim account
4525:
4526: AND acc_rgm.attribute_code = jai_constants.liability_interim --Added by Bo Li for bug#9771955 on 2010-06-04
4527: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
4520: AND tax_rgm.attribute_code = pv_tax_type
4521: AND tax_rgm.regime_id = acc_rgm.regime_id
4522: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
4523: --AND acc_rgm.attribute_code = jai_constants.recovery_interim -- --|oved by Jia for fixed bug#7205349 on 20-Apr-2009
4524: -- AND acc_rgm.attribute_code = jai_constants.liability -- Modified by Jia for fixed bug#8474445 on 30-Apr-2009, use liability account to replace liability interim account
4525:
4526: AND acc_rgm.attribute_code = jai_constants.liability_interim --Added by Bo Li for bug#9771955 on 2010-06-04
4527: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
4528:
4522: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
4523: --AND acc_rgm.attribute_code = jai_constants.recovery_interim -- --|oved by Jia for fixed bug#7205349 on 20-Apr-2009
4524: -- AND acc_rgm.attribute_code = jai_constants.liability -- Modified by Jia for fixed bug#8474445 on 30-Apr-2009, use liability account to replace liability interim account
4525:
4526: AND acc_rgm.attribute_code = jai_constants.liability_interim --Added by Bo Li for bug#9771955 on 2010-06-04
4527: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
4528:
4529: ln_tax_acc_id := ln_tax_rgm_acc_id;
4530: EXCEPTION
4807: cursor get_regime_id(cp_tax_type in varchar2)
4808: is
4809: select regime_id, regime_code /*Bug 11821537 - Added Regime Code*/
4810: from jai_regime_tax_types_v
4811: where regime_code in (jai_constants.service_regime,jai_constants.vat_regime)
4812: and tax_type=cp_tax_type;
4813:
4814: ln_regime_id number;
4815: ln_regime_code jai_rgm_definitions.regime_code%TYPE; /*Bug 11821537 - Added Regime Code*/
5016: FROM
5017: jai_rgm_definitions rgm_def
5018: , jai_rgm_registrations tax_rgm
5019: , jai_rgm_registrations acc_rgm
5020: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
5021: AND tax_rgm.regime_id = rgm_def.regime_id
5022: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
5023: AND tax_rgm.attribute_code = inclu_tax_csr.tax_type
5024: AND tax_rgm.regime_id = acc_rgm.regime_id
5018: , jai_rgm_registrations tax_rgm
5019: , jai_rgm_registrations acc_rgm
5020: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
5021: AND tax_rgm.regime_id = rgm_def.regime_id
5022: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
5023: AND tax_rgm.attribute_code = inclu_tax_csr.tax_type
5024: AND tax_rgm.regime_id = acc_rgm.regime_id
5025: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
5026: AND acc_rgm.attribute_code = jai_constants.recovery
5021: AND tax_rgm.regime_id = rgm_def.regime_id
5022: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
5023: AND tax_rgm.attribute_code = inclu_tax_csr.tax_type
5024: AND tax_rgm.regime_id = acc_rgm.regime_id
5025: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
5026: AND acc_rgm.attribute_code = jai_constants.recovery
5027: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
5028: */
5029: --start additions by vkaranam for bug#11652823
5022: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
5023: AND tax_rgm.attribute_code = inclu_tax_csr.tax_type
5024: AND tax_rgm.regime_id = acc_rgm.regime_id
5025: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
5026: AND acc_rgm.attribute_code = jai_constants.recovery
5027: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
5028: */
5029: --start additions by vkaranam for bug#11652823
5030: open get_regime_id( inclu_tax_csr.tax_type);
5036: p_organization_type =>'IO',
5037: p_organization_id => ln_inv_org_id,
5038: p_location_id =>ln_inv_loc_id,
5039: p_tax_type => inclu_tax_csr.tax_type,
5040: p_account_name => jai_constants.recovery
5041: );
5042: --end additions for bug#11652823
5043: /*Bug 11905163 - Start*/
5044: IF (ln_tax_account_id IS NULL) THEN
5229: p_organization_type => 'IO',
5230: p_organization_id => ln_inv_org_id,
5231: p_location_id => ln_inv_loc_id,
5232: p_tax_type => inclu_tax_csr.tax_type,
5233: p_account_name => jai_constants.liability
5234: );
5235: ELSE
5236: ln_tax_account_id := jai_cmn_rgm_Recording_pkg.get_account(
5237: p_regime_id => ln_regime_id,
5238: p_organization_type => 'IO',
5239: p_organization_id => ln_inv_org_id,
5240: p_location_id => ln_inv_loc_id,
5241: p_tax_type => inclu_tax_csr.tax_type,
5242: p_account_name => jai_constants.liability_interim
5243: );
5244: END IF;
5245:
5246:
5262: p_organization_type => 'IO',
5263: p_organization_id => ln_inv_org_id,
5264: p_location_id => ln_inv_loc_id,
5265: p_tax_type => inclu_tax_csr.tax_type,
5266: p_account_name => jai_constants.liability_interim
5267: );
5268: END IF;
5269: /*ER 11821537 - End*/
5270: /*Bug 11905163 - Start*/