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 1241: FROM mtl_parameters

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

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

1446: OPEN c_lot_uom_conv ;
1447: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;
1448:
1449: IF c_lot_uom_conv%FOUND THEN
1450: -- Possible values for mtl_parameters.lot_number_generation are:
1451: -- 1 At organization level
1452: -- 3 User defined
1453: -- 2 At item level
1454: -- Spr_Debug('7: ');

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

1526: OPEN c_lot_uom_conv ;
1527: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;
1528:
1529: IF c_lot_uom_conv%FOUND THEN
1530: -- Possible values for mtl_parameters.lot_number_generation are:
1531: -- 1 At organization level
1532: -- 3 User defined
1533: -- 2 At item level
1534: -- Spr_Debug('7: ');

Line 1581: FROM mtl_parameters

1577: l_org_id := P_ORG_ID;
1578: BEGIN
1579: SELECT create_lot_uom_conversion
1580: INTO l_create_lot_uom_conv
1581: FROM mtl_parameters
1582: WHERE organization_id = l_org_id;
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: l_create_lot_uom_conv := 1;