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_RCTA_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 305: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;

301: /*
302: start additions by sriram for VAT
303: */
304:
305: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
306: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
307: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
308: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
309: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;

Line 306: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;

302: start additions by sriram for VAT
303: */
304:
305: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
306: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
307: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
308: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
309: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
310:

Line 307: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;

303: */
304:
305: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
306: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
307: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
308: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
309: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
310:
311:

Line 309: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;

305: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
306: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
307: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
308: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
309: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
310:
311:
312: v_organization_id Number;
313: v_loc_id Number;

Line 358: from JAI_CMN_INVENTORY_ORGS

354: Procedure Generate_Tax_Invoice_no (p_organization_id Number , p_loc_id Number) is
355:
356: Cursor c_get_vat_reg_no is
357: select vat_reg_no
358: from JAI_CMN_INVENTORY_ORGS
359: where organization_id = p_organization_id
360: and location_id = p_loc_id;
361:
362: cursor c_get_vat_invoice_no is

Line 364: from JAI_CMN_INVENTORY_ORGS

360: and location_id = p_loc_id;
361:
362: cursor c_get_vat_invoice_no is
363: select current_number , jump_by , prefix
364: from JAI_CMN_INVENTORY_ORGS
365: where organization_id = p_organization_id
366: and location_id = p_loc_id;
367:
368:

Line 383: update JAI_CMN_INVENTORY_ORGS

379: end if;
380:
381:
382: -- lock the records
383: update JAI_CMN_INVENTORY_ORGS
384: set last_update_date = last_update_date
385: where vat_reg_no = v_vat_reg_no;
386:
387: Open c_get_vat_invoice_no;

Line 403: update JAI_CMN_INVENTORY_ORGS

399: update JAI_AR_TRXS
400: set tax_invoice_no = v_vat_invoice_no
401: where customer_trx_id = pr_new.customer_trx_id;
402:
403: update JAI_CMN_INVENTORY_ORGS
404: set current_number = NVL(v_vat_start_num,0) ,
405: prefix = v_vat_prefix,
406: jump_by = v_vat_jump_by
407: where vat_Reg_no = v_vat_reg_no;

Line 1033: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/Bug#4601570 bduvarag/

1029: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1030: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1031: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1032: -- added by sriram - bug # 3021588
1033: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/*Bug#4601570 bduvarag*/
1034: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;/*Bug#4601570 bduvarag*/
1035:
1036: /*
1037: || Start of bug 4101549

Line 1081: FROM JAI_CMN_INVENTORY_ORGS

1077: WHERE customer_trx_id = v_customer_trx_id;
1078:
1079: CURSOR preference_reg_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1080: SELECT pref_rg23a , pref_rg23c , pref_pla
1081: FROM JAI_CMN_INVENTORY_ORGS
1082: WHERE organization_id = p_org_id AND
1083: location_id = p_loc_id;
1084:
1085: CURSOR item_class_cur(P_ORG_ID IN NUMBER, P_Item_id IN NUMBER) IS

Line 1152: FROM JAI_CMN_INVENTORY_ORGS

1148: ORDER BY 1;
1149:
1150: CURSOR ssi_unit_flag_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1151: SELECT ssi_unit_flag, nvl(trading,'N')/*Bug#4601570 bduvarag*/
1152: FROM JAI_CMN_INVENTORY_ORGS
1153: WHERE organization_id = p_org_id AND
1154: location_id = p_loc_id;
1155:
1156: CURSOR transaction_type_cur IS

Line 1206: FROM JAI_CMN_INVENTORY_ORGS

1202:
1203: --added by GD
1204: CURSOR for_modvat_percentage(v_org_id NUMBER, v_location_id NUMBER) IS
1205: SELECT MODVAT_REVERSE_PERCENT
1206: FROM JAI_CMN_INVENTORY_ORGS
1207: WHERE organization_id = v_org_id
1208: AND (location_id = v_location_id
1209: OR
1210: (location_id is NULL and v_location_id is NULL)); /* Modified by Ramananda for removal of SQL LITERALs */

Line 1235: FROM JAI_CMN_INVENTORY_ORGS A

1231: */
1232: /* CODE ADDED TO INCORPORATE MASTER ORGANIZATION */
1233: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1234: SELECT A.Organization_Id, A.Location_Id
1235: FROM JAI_CMN_INVENTORY_ORGS A
1236: WHERE A.Ec_Code IN (SELECT B.Ec_Code
1237: FROM JAI_CMN_INVENTORY_ORGS B
1238: WHERE B.Organization_Id = p_organization_id
1239: AND B.Location_Id = p_location_id);

Line 1237: FROM JAI_CMN_INVENTORY_ORGS B

1233: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1234: SELECT A.Organization_Id, A.Location_Id
1235: FROM JAI_CMN_INVENTORY_ORGS A
1236: WHERE A.Ec_Code IN (SELECT B.Ec_Code
1237: FROM JAI_CMN_INVENTORY_ORGS B
1238: WHERE B.Organization_Id = p_organization_id
1239: AND B.Location_Id = p_location_id);
1240:
1241: --3661746