APPS.INV_RULE_GEN_PVT dependencies on MTL_INV_PICKING_RULES

Line 42: From mtl_inv_picking_rules

38: l_parameter_id NUMBER;
39: l_is_new_rec NUMBER;
40: cursor check_exist(p_inv_rule_id IN NUMBER) is
41: Select 1
42: From mtl_inv_picking_rules
43: Where inv_rule_id = p_inv_rule_id;
44:
45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 145: select mtl_inv_picking_rules_s.nextval into l_inv_Rule_id from dual;

141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: l_inv_rule_id := p_mtl_picking_rule_rec.inv_rule_id;
143: debug('Procedure Save_to_mtl_picking_rules');
144: If l_inv_rule_id is null then
145: select mtl_inv_picking_rules_s.nextval into l_inv_Rule_id from dual;
146: debug('insert rule: rule_id '||l_inv_rule_id);
147: debug('insert rule: fnd_global.user_id '||fnd_global.user_id);
148: Insert into mtl_inv_picking_rules
149: (

Line 148: Insert into mtl_inv_picking_rules

144: If l_inv_rule_id is null then
145: select mtl_inv_picking_rules_s.nextval into l_inv_Rule_id from dual;
146: debug('insert rule: rule_id '||l_inv_rule_id);
147: debug('insert rule: fnd_global.user_id '||fnd_global.user_id);
148: Insert into mtl_inv_picking_rules
149: (
150: INV_RULE_ID
151: , SHELF_DAYS
152: , SINGLE_LOT

Line 205: update mtl_inv_picking_rules

201: );
202: p_mtl_picking_rule_rec.inv_rule_id := l_inv_rule_id;
203: debug('insert, inv_rule_id '||l_inv_rule_id);
204: else -- update
205: update mtl_inv_picking_rules
206: set
207: SHELF_DAYS = p_mtl_picking_rule_rec.shelf_days
208: , SINGLE_LOT = p_mtl_picking_rule_rec.single_lot
209: , PARTIAL_ALLOWED_FLAG = p_mtl_picking_rule_rec.partial_allowed_flag