eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 79: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;

75: */
76: PROCEDURE gen_vat_for_inv( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
77:
78:
79: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
80: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
81: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
82: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
83: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;

Line 80: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;

76: PROCEDURE gen_vat_for_inv( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
77:
78:
79: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
80: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
81: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
82: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
83: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
84:

Line 81: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;

77:
78:
79: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
80: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
81: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
82: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
83: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
84:
85:

Line 83: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;

79: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
80: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
81: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
82: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
83: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
84:
85:
86: v_organization_id Number;
87: v_loc_id Number;

Line 133: from JAI_CMN_INVENTORY_ORGS

129: Procedure Generate_Tax_Invoice_no (p_organization_id Number , p_loc_id Number) is
130:
131: Cursor c_get_vat_reg_no is
132: select vat_reg_no
133: from JAI_CMN_INVENTORY_ORGS
134: where organization_id = p_organization_id
135: and location_id = p_loc_id;
136:
137: cursor c_get_vat_invoice_no is

Line 139: from JAI_CMN_INVENTORY_ORGS

135: and location_id = p_loc_id;
136:
137: cursor c_get_vat_invoice_no is
138: select current_number , jump_by , prefix
139: from JAI_CMN_INVENTORY_ORGS
140: where organization_id = p_organization_id
141: and location_id = p_loc_id;
142:
143: --Added by Zhiwei.hou for JAI Trigger elimination begin

Line 176: update JAI_CMN_INVENTORY_ORGS

172: end if;
173:
174:
175: -- lock the records
176: update JAI_CMN_INVENTORY_ORGS
177: set last_update_date = last_update_date
178: where vat_reg_no = v_vat_reg_no;
179:
180: Open c_get_vat_invoice_no;

Line 233: update JAI_CMN_INVENTORY_ORGS

229: end if;
230: ---------------------------------------------------------
231: --Added by Zhiwei for JAI Trigger elimination end
232:
233: update JAI_CMN_INVENTORY_ORGS
234: set current_number = NVL(v_vat_start_num,0) ,
235: prefix = v_vat_prefix,
236: jump_by = v_vat_jump_by
237: where vat_Reg_no = v_vat_reg_no;

Line 642: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

638: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
639: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
640: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
641:
642: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
643: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;
644:
645:
646: CURSOR complete_cur

Line 687: FROM JAI_CMN_INVENTORY_ORGS

683: WHERE customer_trx_id = v_customer_trx_id;
684:
685: CURSOR preference_reg_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
686: SELECT pref_rg23a , pref_rg23c , pref_pla
687: FROM JAI_CMN_INVENTORY_ORGS
688: WHERE organization_id = p_org_id AND
689: location_id = p_loc_id;
690:
691: CURSOR item_class_cur(P_ORG_ID IN NUMBER, P_Item_id IN NUMBER) IS

Line 758: FROM JAI_CMN_INVENTORY_ORGS

754: ORDER BY 1;
755:
756: CURSOR ssi_unit_flag_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
757: SELECT ssi_unit_flag, nvl(trading,'N')
758: FROM JAI_CMN_INVENTORY_ORGS
759: WHERE organization_id = p_org_id AND
760: location_id = p_loc_id;
761:
762: CURSOR transaction_type_cur IS

Line 812: FROM JAI_CMN_INVENTORY_ORGS

808:
809:
810: CURSOR for_modvat_percentage(v_org_id NUMBER, v_location_id NUMBER) IS
811: SELECT MODVAT_REVERSE_PERCENT
812: FROM JAI_CMN_INVENTORY_ORGS
813: WHERE organization_id = v_org_id
814: AND (location_id = v_location_id
815: OR
816: (location_id is NULL and v_location_id is NULL));

Line 836: FROM JAI_CMN_INVENTORY_ORGS A

832: v_set_of_books_id NUMBER;
833:
834: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
835: SELECT A.Organization_Id, A.Location_Id
836: FROM JAI_CMN_INVENTORY_ORGS A
837: WHERE A.Ec_Code IN (SELECT B.Ec_Code
838: FROM JAI_CMN_INVENTORY_ORGS B
839: WHERE B.Organization_Id = p_organization_id
840: AND B.Location_Id = p_location_id);

Line 838: FROM JAI_CMN_INVENTORY_ORGS B

834: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
835: SELECT A.Organization_Id, A.Location_Id
836: FROM JAI_CMN_INVENTORY_ORGS A
837: WHERE A.Ec_Code IN (SELECT B.Ec_Code
838: FROM JAI_CMN_INVENTORY_ORGS B
839: WHERE B.Organization_Id = p_organization_id
840: AND B.Location_Id = p_location_id);
841:
842: