APPS.WMS_RULE_PVT dependencies on WMS_RULE_PICK_PKG2

Line 1069: ---- WMS_RULE_PICK_PKG, WMS_RULE_PICK_PKG1, WMS_RULE_PICK_PKG2

1065: --------------
1066: --- Build Rules List
1067: --- Generate all static rule list package for diffrent rule types.
1068: ---- Total of 15 packages will be generated
1069: ---- WMS_RULE_PICK_PKG, WMS_RULE_PICK_PKG1, WMS_RULE_PICK_PKG2
1070: PROCEDURE buildrulespkg(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER, x_return_status OUT NOCOPY VARCHAR2) IS
1071: l_return_status VARCHAR2(1);
1072: l_msg_count NUMBER;
1073: l_msg_data VARCHAR2(240);

Line 3298: wms_rule_pick_pkg2.execute_fetch_rule(

3294: , x_rows
3295: );
3296: ELSIF (l_ctr = 2) THEN
3297:
3298: wms_rule_pick_pkg2.execute_fetch_rule(
3299: p_cursor
3300: , p_rule_id
3301: , x_revision
3302: , x_lot_number

Line 3651: log_statement(l_api_name, ' wms_rule_pick_pkg2.execute_open_rule', l_ctr);

3647: );
3648: ELSIF (l_ctr = 2) THEN
3649:
3650: IF l_debug = 1 THEN
3651: log_statement(l_api_name, ' wms_rule_pick_pkg2.execute_open_rule', l_ctr);
3652: END IF;
3653:
3654: wms_rule_pick_pkg2.execute_open_rule(
3655: p_cursor

Line 3654: wms_rule_pick_pkg2.execute_open_rule(

3650: IF l_debug = 1 THEN
3651: log_statement(l_api_name, ' wms_rule_pick_pkg2.execute_open_rule', l_ctr);
3652: END IF;
3653:
3654: wms_rule_pick_pkg2.execute_open_rule(
3655: p_cursor
3656: , p_rule_id
3657: , p_organization_id
3658: , p_inventory_item_id

Line 4019: wms_rule_pick_pkg2.execute_close_rule(p_rule_id, p_cursor);

4015:
4016: IF (l_ctr = 1) THEN
4017: wms_rule_pick_pkg1.execute_close_rule(p_rule_id, p_cursor);
4018: ELSIF (l_ctr = 2) THEN
4019: wms_rule_pick_pkg2.execute_close_rule(p_rule_id, p_cursor);
4020: ELSIF (l_ctr = 3) THEN
4021: wms_rule_pick_pkg3.execute_close_rule(p_rule_id, p_cursor);
4022: END IF;
4023:

Line 16537: wms_rule_pick_pkg2.execute_fetch_available_inv(

16533: , x_return_status
16534: );
16535: ELSIF (l_ctr = 2) THEN
16536:
16537: wms_rule_pick_pkg2.execute_fetch_available_inv(
16538: p_cursor
16539: , p_rule_id
16540: , x_return_status
16541: );