[Home] [Help]
877: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE
878: AND REGIME_CODE = CP_REGIME_CODE
879: AND JSPT.DELIVERY_DETAIL_ID = CP_DELIVERY_DETAIL_ID;
880:
881: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
882:
883:
884: BEGIN
885: pv_return_code := jai_constants.successful ;
934: /*
935: The trigger should be bypassed in case the functional currency code is NON INR.
936: */
937: IF pr_new.org_id IS NOT NULL THEN
938: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
939: (p_org_id => pr_new.org_id);
940: v_currency_code := l_func_curr_det.currency_code;
941: v_set_of_books_id := l_func_curr_det.ledger_id;
942: END IF;
2104: lv_reference_25 varchar2(100) := 'delivery_id';
2105: lv_regime_code VARCHAR2(100) := 'EXCISE';
2106: lv_source_table VARCHAR2(100) := 'wsh_delivery_details';
2107:
2108: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
2109:
2110: BEGIN
2111:
2112: OPEN c_get_il_setup;
2113: FETCH c_get_il_setup
2114: INTO r_il_setup;
2115: CLOSE c_get_il_setup;
2116:
2117: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => pr_trig_row.organization_id);
2118: v_set_of_books_id := l_func_curr_det.ledger_id;
2119: v_currency_code := l_func_curr_det.currency_code;
2120: IF Nvl(r_il_setup.trading, 'N') = 'Y' AND
2121: Nvl(r_il_setup.excise_in_rg23d, 'N') = 'Y' /*reversing to be done only if this setup is present. not necessary otherwise*/
2924: v_source_line_id NUMBER;
2925: v_source_header_id NUMBER;
2926: lv_process_message VARCHAR2 (1000);
2927:
2928: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
2929:
2930: CURSOR get_conv_detail_cur
2931: IS
2932: SELECT
2954: v_source_header_id :=pr_new.Source_Header_Id;
2955: v_source_line_id :=pr_new.Source_Line_Id;
2956:
2957: IF pr_new.org_id IS NOT NULL THEN
2958: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
2959: (p_org_id => pr_new.org_id);
2960: v_currency_code := l_func_curr_det.currency_code;
2961: v_set_of_books_id := l_func_curr_det.ledger_id;
2962: END IF;