DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on MTL_PARAMETERS

Line 1548: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;

1544: l_is_lot_control BOOLEAN := FALSE;
1545: l_is_serial_control BOOLEAN := FALSE;
1546: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
1547: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
1548: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
1549:
1550: l_api_version_number CONSTANT NUMBER := 1.0;
1551: l_api_name CONSTANT VARCHAR2(30) := 'Check_Looose_Quantity';
1552: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1568: FROM mtl_parameters

1564: l_cgcnt NUMBER;
1565:
1566: CURSOR c_org IS
1567: SELECT negative_inv_receipt_code
1568: FROM mtl_parameters
1569: WHERE organization_id = p_organization_id;
1570:
1571: CURSOR c_lot_exp IS
1572: SELECT expiration_date

Line 2826: l_inv_rcpt_code MTL_PARAMETERS.NEGATIVE_INV_RECEIPT_CODE%TYPE; -- Bug 13878269

2822: l_parent_lpn_id NUMBER;
2823: l_lpn_context NUMBER ;
2824: l_updt_qoh NUMBER;
2825: l_tree_mode INTEGER := INV_Quantity_Tree_PUB.g_transaction_mode;
2826: l_inv_rcpt_code MTL_PARAMETERS.NEGATIVE_INV_RECEIPT_CODE%TYPE; -- Bug 13878269
2827:
2828: TYPE l_rec IS RECORD (
2829: inventory_item_id NUMBER,
2830: parent_lpn_id NUMBER,

Line 4379: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;

4375: l_is_serial_control BOOLEAN := FALSE;
4376:
4377: l_cost_group_id mtl_material_transactions_temp.cost_group_id%type;
4378: l_primary_uom_code mtl_material_transactions_temp.item_primary_uom_code%type;
4379: l_inv_rcpt_code mtl_parameters.negative_inv_receipt_code%type;
4380:
4381: l_api_version_number CONSTANT NUMBER := 1.0;
4382: l_api_name CONSTANT VARCHAR2(30) := 'Check_Looose_and_packed_Qty';
4383: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 4398: FROM mtl_parameters

4394: l_suggested_loc_id NUMBER;
4395:
4396: CURSOR c_org IS
4397: SELECT negative_inv_receipt_code
4398: FROM mtl_parameters
4399: WHERE organization_id = p_organization_id;
4400:
4401: CURSOR c_lot_exp IS
4402: SELECT expiration_date