APPS.JAI_JRG_23AC1_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

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

46: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;
47: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
48:
49: /*Bug 9122545*/
50: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,
51: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)
52: IS
53: SELECT nvl(allow_negative_rg_flag,'N')
54: FROM jai_cmn_inventory_orgs

Line 51: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)

47: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
48:
49: /*Bug 9122545*/
50: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,
51: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)
52: IS
53: SELECT nvl(allow_negative_rg_flag,'N')
54: FROM jai_cmn_inventory_orgs
55: WHERE organization_id = cp_organization_id

Line 54: FROM jai_cmn_inventory_orgs

50: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,
51: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)
52: IS
53: SELECT nvl(allow_negative_rg_flag,'N')
54: FROM jai_cmn_inventory_orgs
55: WHERE organization_id = cp_organization_id
56: AND location_id = cp_location_id;
57:
58: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;

Line 58: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;

54: FROM jai_cmn_inventory_orgs
55: WHERE organization_id = cp_organization_id
56: AND location_id = cp_location_id;
57:
58: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%TYPE;
59: /*end bug 9122545*/
60:
61: BEGIN
62: pv_return_code := jai_constants.successful ;