APPS.INV_LOT_APIS dependencies on MTL_PARAMETERS

Line 375: FROM mtl_parameters

371: /* Cursor definition to check if Lot UOM Conversion is needed */
372: CURSOR c_lot_uom_conv (cp_organization_id NUMBER) IS
373: SELECT copy_lot_attribute_flag,
374: lot_number_generation
375: FROM mtl_parameters
376: WHERE organization_id = cp_organization_id;
377:
378: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
379: l_copy_lot_attribute_flag Varchar2(10);

Line 387: -- Possible values for mtl_parameters.lot_number_generation are:

383: OPEN c_lot_uom_conv (p_organization_id) ;
384: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;
385:
386: IF c_lot_uom_conv%FOUND THEN
387: -- Possible values for mtl_parameters.lot_number_generation are:
388: -- 1 At organization level
389: -- 3 User defined
390: -- 2 At item level
391:

Line 1022: FROM mtl_parameters

1018: l_org_id := p_org_id;
1019: BEGIN
1020: SELECT create_lot_uom_conversion
1021: INTO l_create_lot_uom_conv
1022: FROM mtl_parameters
1023: WHERE organization_id = l_org_id;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: l_create_lot_uom_conv := 1;

Line 1243: FROM mtl_parameters

1239: /* Cursor definition to check if Lot UOM Conversion is needed */
1240: CURSOR c_lot_uom_conv IS
1241: SELECT copy_lot_attribute_flag,
1242: lot_number_generation
1243: FROM mtl_parameters
1244: WHERE organization_id = p_org_id;
1245:
1246: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
1247:

Line 1456: -- Possible values for mtl_parameters.lot_number_generation are:

1452: OPEN c_lot_uom_conv ;
1453: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;
1454:
1455: IF c_lot_uom_conv%FOUND THEN
1456: -- Possible values for mtl_parameters.lot_number_generation are:
1457: -- 1 At organization level
1458: -- 3 User defined
1459: -- 2 At item level
1460: -- Spr_Debug('7: ');

Line 1536: -- Possible values for mtl_parameters.lot_number_generation are:

1532: OPEN c_lot_uom_conv ;
1533: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;
1534:
1535: IF c_lot_uom_conv%FOUND THEN
1536: -- Possible values for mtl_parameters.lot_number_generation are:
1537: -- 1 At organization level
1538: -- 3 User defined
1539: -- 2 At item level
1540: -- Spr_Debug('7: ');

Line 1587: FROM mtl_parameters

1583: l_org_id := P_ORG_ID;
1584: BEGIN
1585: SELECT create_lot_uom_conversion
1586: INTO l_create_lot_uom_conv
1587: FROM mtl_parameters
1588: WHERE organization_id = l_org_id;
1589: EXCEPTION
1590: WHEN OTHERS THEN
1591: l_create_lot_uom_conv := 1;

Line 1823: FROM mtl_parameters

1819: l_copy_lot_attribute_flag Varchar2(1):='N';
1820: BEGIN
1821:
1822: SELECT NVL(copy_lot_attribute_flag,'N') INTO l_copy_lot_attribute_flag
1823: FROM mtl_parameters
1824: WHERE organization_id = p_organization_id;
1825:
1826:
1827: IF(l_copy_lot_attribute_flag ='N') THEN