APPS.WMS_STRATEGY_PVT dependencies on WMS_RE_COMMON_PVT

Line 396: Wms_re_common_pvt.InitInputTable;

392: -- ER 7307189 changes end
393:
394: log_procedure(l_api_name,'start', 'tree mode '||x_tree_mode);
395: -- Initialize input line PL/SQL table
396: Wms_re_common_pvt.InitInputTable;
397:
398: -- Loop through txn detail line input parameters
399: open inpline;
400: while true loop

Line 423: Wms_re_common_pvt.InitInputLine ( l_pp_transaction_temp_id

419:
420: exit when inpline%notfound;
421:
422: -- create a new input line record in the input line table
423: Wms_re_common_pvt.InitInputLine ( l_pp_transaction_temp_id
424: ,l_revision
425: ,l_lot_number
426: ,l_lot_expiration_date
427: ,l_from_subinventory_code

Line 444: if Wms_re_common_pvt.GetCountInputLines = 0 then

440: end loop;
441: close inpline;
442:
443: /* --no need to raise error - no lines will be detailed
444: if Wms_re_common_pvt.GetCountInputLines = 0 then
445: raise no_data_found;
446: end if;
447:
448: --

Line 571: Wms_re_common_pvt.InitRulesTable;

567: -- Initialize local input line counter
568: l_rule_counter := 0;
569:
570: -- Initialize strategy members PL/SQL table
571: Wms_re_common_pvt.InitRulesTable;
572: -- 8809951 Added the IF condition.
573: l_rule_counter := wms_cache.get_Strategy_from_cache(p_strategy_id,
574: x_return_status => x_return_status,
575: x_msg_count => x_msg_count,

Line 594: Wms_re_common_pvt.InitRule (

590: ,g_tolerance_value;
591: exit when rules%notfound;
592:
593: -- create a new record in the rule table
594: Wms_re_common_pvt.InitRule (
595: l_rule_id
596: ,l_partial_success_allowed_flag
597: ,l_rule_counter
598: );

Line 872: Wms_re_common_pvt.InitInputTable;

868: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
869: END IF;
870: -- end of debugging section
871: -- */
872: Wms_re_common_pvt.InitInputTable;
873: Wms_re_common_pvt.InitRulesTable;
874: /* --
875: -- debugging portion
876: -- can be commented ut for final code

Line 873: Wms_re_common_pvt.InitRulesTable;

869: END IF;
870: -- end of debugging section
871: -- */
872: Wms_re_common_pvt.InitInputTable;
873: Wms_re_common_pvt.InitRulesTable;
874: /* --
875: -- debugging portion
876: -- can be commented ut for final code
877: IF inv_pp_debug.is_debug_mode THEN

Line 914: -- and API's of Wms_re_common_pvt

910: -- Previous version
911: --
912: -- Initial version 1.0
913: -- Notes : calls stub procedure WMS_re_Custom_PUB.SearchForStrategy
914: -- and API's of Wms_re_common_pvt
915: -- End of comments
916:
917: procedure Search (
918: p_api_version in number

Line 1382: --Wms_re_common_pvt.ShowSQL(l_stmt);

1378: If (g_debug = 1) then
1379: log_event(l_api_name, 'Dynamic SQL STMT for Stg Search Order', l_stmt);
1380: End if;
1381:
1382: --Wms_re_common_pvt.ShowSQL(l_stmt);
1383: inv_sql_binding_pvt.ShowBindVars;
1384:
1385: -- 2nd step: get a cursor and parse the SQL statement
1386: l_cursor := dbms_sql.open_cursor;

Line 1899: -- Notes : calls API's of Wms_re_common_pvt, WMS_Rule_PVT

1895: -- Changed ...
1896: -- Previous version
1897: --
1898: -- Initial version 1.0
1899: -- Notes : calls API's of Wms_re_common_pvt, WMS_Rule_PVT
1900: -- and INV_Quantity_Tree_PVT
1901: -- This API must be called internally by
1902: -- WMS_Engine_PVT.Create_Suggestions only !
1903: -- End of comments

Line 2253: log_event(l_api_name,'', 'getcountinputlines '||wms_re_common_pvt.getcountinputlines);

2249: log_event(l_api_name,'', 'after init strategyrules ');
2250:
2251: -- Loop through all the rules, until all input lines are satisfied
2252: if l_debug = 1 THEN
2253: log_event(l_api_name,'', 'getcountinputlines '||wms_re_common_pvt.getcountinputlines);
2254: END IF;
2255:
2256: --- [ Lot Indiv 3.1.6 Indivisible Lot support
2257: --- Getting the max and min tolerance for lot_indivisable items and storing in global vars

Line 2452: WHILE Wms_re_common_pvt.GetCountInputLines > 0 OR p_strategy_id IS NULL LOOP

2448: log_statement(l_api_name, 'WMS_RULE_PVT.g_over_allocation ', WMS_RULE_PVT.g_over_allocation);
2449: END IF;
2450: --- [ End get_tolerance() ]
2451: ---
2452: WHILE Wms_re_common_pvt.GetCountInputLines > 0 OR p_strategy_id IS NULL LOOP
2453: If l_debug = 1 THEN
2454: log_event(l_api_name,'', 'looping rules ');
2455: END IF;
2456:

Line 2463: wms_re_common_pvt.GetNextRule ( l_rule_id

2459: IF p_strategy_id IS NOT null AND
2460: l_simulation_mode NOT IN (2,4) THEN
2461:
2462: -- Get the next rule
2463: wms_re_common_pvt.GetNextRule ( l_rule_id
2464: ,l_partial_success_allowed_flag );
2465:
2466: If l_debug = 1 THEN
2467: log_event(l_api_name,'', 'get rule '||l_rule_id);