1: PACKAGE BODY jai_cmn_setup_pkg AS
2: /* $Header: jai_cmn_setup.plb 120.20.12020000.4 2013/03/25 12:20:54 mmurtuza ship $ */
3:
4: PROCEDURE generate_excise_invoice_no
5: (
820: --
821: -- #########################################################################################*/
822:
823: /* Added by Ramananda for bug#4407165
824: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_setup_pkg.gen_opm_excise_invoice_no';
825:
826: Cursor C_Order_Type_code IS
827: Select Order_Type_code
828: from op_ordr_typ a , op_ordr_hdr b
1286: --Added by Eric Ma on 13-June-2011 for bug 12630041,begin
1287:
1288: -- Added by Xiao for Advanced Pricing on 10-Jun-2009, begin
1289: ------------------------------------------------------------------------------------------
1290: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_cmn_setup_pkg.get_po_assessable_value';
1291:
1292: -- add for record down the release version by Xiao on 24-Jul-2009
1293: lv_release_name VARCHAR2(30);
1294: lv_other_release_info VARCHAR2(30);
1486: --- Added by Xiao for Advanced Pricing on 10-Jun-2009, end
1487:
1488: END get_po_assessable_value;
1489:
1490: END jai_cmn_setup_pkg ;