APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 126: FROM JAI_CMN_INVENTORY_ORGS

122:
123: CURSOR range_division_cur (p_organization_id IN NUMBER, p_loc_id IN NUMBER)
124: IS
125: SELECT NVL (excise_duty_range, ' '), NVL (excise_duty_division, ' ')
126: FROM JAI_CMN_INVENTORY_ORGS
127: WHERE organization_id = p_organization_id AND location_id = p_loc_id;
128:
129: CURSOR srno_i_cur (
130: p_organization_id IN NUMBER,

Line 267: FROM JAI_CMN_INVENTORY_ORGS

263: /* -- cbabu 25/07/02 for Bug#2480524
264: CURSOR get_subinv_dtl_cur
265: IS
266: SELECT manufacturing, trading
267: FROM JAI_CMN_INVENTORY_ORGS
268: WHERE organization_id = pr_new.organization_id AND location_id = 0;
269: */
270: -- cbabu, to execute this trigger only for indian operating units
271: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%TYPE;

Line 296: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,

292: lv_qty_register_flag VARCHAR2(1);
293: --end additions for bug#8530264
294:
295: /*bug 9122545*/
296: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,
297: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)
298: IS
299: SELECT nvl(allow_negative_rg_flag,'N')
300: FROM jai_cmn_inventory_orgs

Line 297: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)

293: --end additions for bug#8530264
294:
295: /*bug 9122545*/
296: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,
297: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)
298: IS
299: SELECT nvl(allow_negative_rg_flag,'N')
300: FROM jai_cmn_inventory_orgs
301: WHERE organization_id = cp_organization_id

Line 300: FROM jai_cmn_inventory_orgs

296: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,
297: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)
298: IS
299: SELECT nvl(allow_negative_rg_flag,'N')
300: FROM jai_cmn_inventory_orgs
301: WHERE organization_id = cp_organization_id
302: AND location_id = cp_location_id;
303:
304: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;

Line 304: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;

300: FROM jai_cmn_inventory_orgs
301: WHERE organization_id = cp_organization_id
302: AND location_id = cp_location_id;
303:
304: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;
305: /*end bug 9122545*/
306: BEGIN
307: pv_return_code := jai_constants.successful ;
308: /*-------------------------------------------------------------------------------------------------------------------------