APPS.WMS_RULE_PVT dependencies on WMS_RULE_PICK_PKG1

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 3277: wms_rule_pick_pkg1.execute_fetch_rule(

3273: END IF;
3274:
3275: IF (l_ctr = 1) THEN
3276:
3277: wms_rule_pick_pkg1.execute_fetch_rule(
3278: p_cursor
3279: , p_rule_id
3280: , x_revision
3281: , x_lot_number

Line 3623: log_statement(l_api_name, ' wms_rule_pick_pkg1.execute_open_rule', l_ctr);

3619:
3620: IF (l_ctr = 1) THEN
3621:
3622: IF l_debug = 1 THEN
3623: log_statement(l_api_name, ' wms_rule_pick_pkg1.execute_open_rule', l_ctr);
3624: END IF;
3625: wms_rule_pick_pkg1.execute_open_rule(
3626: p_cursor
3627: , p_rule_id

Line 3625: wms_rule_pick_pkg1.execute_open_rule(

3621:
3622: IF l_debug = 1 THEN
3623: log_statement(l_api_name, ' wms_rule_pick_pkg1.execute_open_rule', l_ctr);
3624: END IF;
3625: wms_rule_pick_pkg1.execute_open_rule(
3626: p_cursor
3627: , p_rule_id
3628: , p_organization_id
3629: , p_inventory_item_id

Line 4017: wms_rule_pick_pkg1.execute_close_rule(p_rule_id, p_cursor);

4013: l_list_pkg := 'wms_rule_pick_pkg' || l_ctr ;
4014: getpackagename(p_rule_id, l_package_name);
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);

Line 16361: --inv_pp_debug.send_message_to_pipe('Calling **pick_open_curs ** wms_rule_pick_pkg1.execute');

16357: -- open_curs opens the appropriate cursor for the rule;
16358: -- this call has to be dynamic because of the name of the rule package
16359: IF p_type_code = 2 THEN
16360: --pick_open_curs
16361: --inv_pp_debug.send_message_to_pipe('Calling **pick_open_curs ** wms_rule_pick_pkg1.execute');
16362: IF (l_revision IS NULL) THEN
16363: --gmi_reservation_util.println('l_revision is null');
16364: l_revision := '-99';
16365: END IF;

Line 16530: wms_rule_pick_pkg1.execute_fetch_available_inv(

16526: --log_statement(l_package_name, 'p_cursor ', p_cursor);
16527:
16528: IF (l_ctr = 1) THEN
16529:
16530: wms_rule_pick_pkg1.execute_fetch_available_inv(
16531: p_cursor
16532: , p_rule_id
16533: , x_return_status
16534: );