APPS.JAI_CMN_RG_I_TRXS_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 37: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,

33: v_quantity NUMBER ; -- := NVL(p_quantity, 0) File.Sql.35 by Brathod
34: v_manufactured_qty NUMBER;
35:
36: /*bug 9122545*/
37: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
38: cp_location_id jai_cmn_inventory_orgs.location_id%type)
39: IS
40: SELECT nvl(allow_negative_rg_flag,'N')
41: FROM jai_cmn_inventory_orgs

Line 38: cp_location_id jai_cmn_inventory_orgs.location_id%type)

34: v_manufactured_qty NUMBER;
35:
36: /*bug 9122545*/
37: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
38: cp_location_id jai_cmn_inventory_orgs.location_id%type)
39: IS
40: SELECT nvl(allow_negative_rg_flag,'N')
41: FROM jai_cmn_inventory_orgs
42: WHERE organization_id = cp_organization_id

Line 41: FROM jai_cmn_inventory_orgs

37: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
38: cp_location_id jai_cmn_inventory_orgs.location_id%type)
39: IS
40: SELECT nvl(allow_negative_rg_flag,'N')
41: FROM jai_cmn_inventory_orgs
42: WHERE organization_id = cp_organization_id
43: AND location_id = cp_location_id;
44:
45: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;

Line 45: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;

41: FROM jai_cmn_inventory_orgs
42: WHERE organization_id = cp_organization_id
43: AND location_id = cp_location_id;
44:
45: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;
46: /*end bug 9122545*/
47:
48:
49: BEGIN

Line 351: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,

347: v_other_purpose_pay_ed_qty NUMBER;
348: v_other_purpose_pay_ed_val NUMBER;
349:
350: /*bug 9122545*/
351: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
352: cp_location_id jai_cmn_inventory_orgs.location_id%type)
353: IS
354: SELECT nvl(allow_negative_rg_flag,'N')
355: FROM jai_cmn_inventory_orgs

Line 352: cp_location_id jai_cmn_inventory_orgs.location_id%type)

348: v_other_purpose_pay_ed_val NUMBER;
349:
350: /*bug 9122545*/
351: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
352: cp_location_id jai_cmn_inventory_orgs.location_id%type)
353: IS
354: SELECT nvl(allow_negative_rg_flag,'N')
355: FROM jai_cmn_inventory_orgs
356: WHERE organization_id = cp_organization_id

Line 355: FROM jai_cmn_inventory_orgs

351: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
352: cp_location_id jai_cmn_inventory_orgs.location_id%type)
353: IS
354: SELECT nvl(allow_negative_rg_flag,'N')
355: FROM jai_cmn_inventory_orgs
356: WHERE organization_id = cp_organization_id
357: AND location_id = cp_location_id;
358:
359: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;

Line 359: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;

355: FROM jai_cmn_inventory_orgs
356: WHERE organization_id = cp_organization_id
357: AND location_id = cp_location_id;
358:
359: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;
360: /*end bug 9122545*/
361:
362: BEGIN
363: v_quantity := NVL(p_quantity, 0); -- File.Sql.35 by Brathod