DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_RULE_PICK_PKG3

Line 3671: wms_rule_pick_pkg3.execute_fetch_rule(

3667: , x_order_by_string
3668: , x_rows
3669: );
3670: ELSIF (l_ctr = 3) THEN
3671: wms_rule_pick_pkg3.execute_fetch_rule(
3672: p_cursor
3673: , p_rule_id
3674: , x_revision
3675: , x_lot_number

Line 4032: log_statement(l_api_name, ' wms_rule_pick_pkg3.execute_open_rule', l_ctr);

4028: , x_result
4029: );
4030: ELSIF (l_ctr = 3) THEN
4031: IF l_debug = 1 THEN
4032: log_statement(l_api_name, ' wms_rule_pick_pkg3.execute_open_rule', l_ctr);
4033: END IF;
4034:
4035: wms_rule_pick_pkg3.execute_open_rule(
4036: p_cursor

Line 4035: wms_rule_pick_pkg3.execute_open_rule(

4031: IF l_debug = 1 THEN
4032: log_statement(l_api_name, ' wms_rule_pick_pkg3.execute_open_rule', l_ctr);
4033: END IF;
4034:
4035: wms_rule_pick_pkg3.execute_open_rule(
4036: p_cursor
4037: , p_rule_id
4038: , p_organization_id
4039: , p_inventory_item_id

Line 4374: wms_rule_pick_pkg3.execute_close_rule(p_rule_id, p_cursor);

4370: wms_rule_pick_pkg1.execute_close_rule(p_rule_id, p_cursor);
4371: ELSIF (l_ctr = 2) THEN
4372: wms_rule_pick_pkg2.execute_close_rule(p_rule_id, p_cursor);
4373: ELSIF (l_ctr = 3) THEN
4374: wms_rule_pick_pkg3.execute_close_rule(p_rule_id, p_cursor);
4375: END IF;
4376:
4377: EXCEPTION
4378: WHEN INVALID_PKG_STATE THEN

Line 19185: wms_rule_pick_pkg3.execute_fetch_available_inv(

19181: , p_rule_id
19182: , x_return_status
19183: );
19184: ELSIF (l_ctr = 3) THEN
19185: wms_rule_pick_pkg3.execute_fetch_available_inv(
19186: p_cursor
19187: , p_rule_id
19188: , x_return_status
19189: );