APPS.WMS_RULE_PVT dependencies on WMS_RULE_PICK_PKG1

Line 1152: ---- WMS_RULE_PICK_PKG, WMS_RULE_PICK_PKG1, WMS_RULE_PICK_PKG2

1148: --------------
1149: --- Build Rules List
1150: --- Generate all static rule list package for diffrent rule types.
1151: ---- Total of 15 packages will be generated
1152: ---- WMS_RULE_PICK_PKG, WMS_RULE_PICK_PKG1, WMS_RULE_PICK_PKG2
1153: PROCEDURE buildrulespkg(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER, x_return_status OUT NOCOPY VARCHAR2) IS
1154: l_return_status VARCHAR2(1);
1155: l_msg_count NUMBER;
1156: l_msg_data VARCHAR2(240);

Line 3630: wms_rule_pick_pkg1.execute_fetch_rule(

3626: END IF;
3627:
3628: IF (l_ctr = 1) THEN
3629:
3630: wms_rule_pick_pkg1.execute_fetch_rule(
3631: p_cursor
3632: , p_rule_id
3633: , x_revision
3634: , x_lot_number

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

3972:
3973: IF (l_ctr = 1) THEN
3974:
3975: IF l_debug = 1 THEN
3976: log_statement(l_api_name, ' wms_rule_pick_pkg1.execute_open_rule', l_ctr);
3977: END IF;
3978: wms_rule_pick_pkg1.execute_open_rule(
3979: p_cursor
3980: , p_rule_id

Line 3978: wms_rule_pick_pkg1.execute_open_rule(

3974:
3975: IF l_debug = 1 THEN
3976: log_statement(l_api_name, ' wms_rule_pick_pkg1.execute_open_rule', l_ctr);
3977: END IF;
3978: wms_rule_pick_pkg1.execute_open_rule(
3979: p_cursor
3980: , p_rule_id
3981: , p_organization_id
3982: , p_inventory_item_id

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

4366: l_list_pkg := 'wms_rule_pick_pkg' || l_ctr ;
4367: getpackagename(p_rule_id, l_package_name);
4368:
4369: IF (l_ctr = 1) THEN
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);

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

18999: -- open_curs opens the appropriate cursor for the rule;
19000: -- this call has to be dynamic because of the name of the rule package
19001: IF p_type_code = 2 THEN
19002: --pick_open_curs
19003: --inv_pp_debug.send_message_to_pipe('Calling **pick_open_curs ** wms_rule_pick_pkg1.execute');
19004: IF (l_revision IS NULL) THEN
19005: --gmi_reservation_util.println('l_revision is null');
19006: l_revision := '-99';
19007: END IF;

Line 19172: wms_rule_pick_pkg1.execute_fetch_available_inv(

19168: --log_statement(l_package_name, 'p_cursor ', p_cursor);
19169:
19170: IF (l_ctr = 1) THEN
19171:
19172: wms_rule_pick_pkg1.execute_fetch_available_inv(
19173: p_cursor
19174: , p_rule_id
19175: , x_return_status
19176: );