APPS.WMS_STRATEGY_PVT dependencies on WMS_RE_COMMON_PVT

Line 387: Wms_re_common_pvt.InitInputTable;

383: -- ER 7307189 changes end
384:
385: log_procedure(l_api_name,'start', 'tree mode '||x_tree_mode);
386: -- Initialize input line PL/SQL table
387: Wms_re_common_pvt.InitInputTable;
388:
389: -- Loop through txn detail line input parameters
390: open inpline;
391: while true loop

Line 414: Wms_re_common_pvt.InitInputLine ( l_pp_transaction_temp_id

410:
411: exit when inpline%notfound;
412:
413: -- create a new input line record in the input line table
414: Wms_re_common_pvt.InitInputLine ( l_pp_transaction_temp_id
415: ,l_revision
416: ,l_lot_number
417: ,l_lot_expiration_date
418: ,l_from_subinventory_code

Line 435: if Wms_re_common_pvt.GetCountInputLines = 0 then

431: end loop;
432: close inpline;
433:
434: /* --no need to raise error - no lines will be detailed
435: if Wms_re_common_pvt.GetCountInputLines = 0 then
436: raise no_data_found;
437: end if;
438:
439: --

Line 559: Wms_re_common_pvt.InitRulesTable;

555: -- Initialize local input line counter
556: l_rule_counter := 0;
557:
558: -- Initialize strategy members PL/SQL table
559: Wms_re_common_pvt.InitRulesTable;
560:
561: -- Loop through strategy members
562: open rules;
563: while true loop

Line 571: Wms_re_common_pvt.InitRule (

567: ,g_tolerance_value;
568: exit when rules%notfound;
569:
570: -- create a new record in the rule table
571: Wms_re_common_pvt.InitRule (
572: l_rule_id
573: ,l_partial_success_allowed_flag
574: ,l_rule_counter
575: );

Line 834: Wms_re_common_pvt.InitInputTable;

830: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
831: END IF;
832: -- end of debugging section
833: -- */
834: Wms_re_common_pvt.InitInputTable;
835: Wms_re_common_pvt.InitRulesTable;
836: /* --
837: -- debugging portion
838: -- can be commented ut for final code

Line 835: Wms_re_common_pvt.InitRulesTable;

831: END IF;
832: -- end of debugging section
833: -- */
834: Wms_re_common_pvt.InitInputTable;
835: Wms_re_common_pvt.InitRulesTable;
836: /* --
837: -- debugging portion
838: -- can be commented ut for final code
839: IF inv_pp_debug.is_debug_mode THEN

Line 876: -- and API's of Wms_re_common_pvt

872: -- Previous version
873: --
874: -- Initial version 1.0
875: -- Notes : calls stub procedure WMS_re_Custom_PUB.SearchForStrategy
876: -- and API's of Wms_re_common_pvt
877: -- End of comments
878:
879: procedure Search (
880: p_api_version in number

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

1340: If (g_debug = 1) then
1341: log_event(l_api_name, 'Dynamic SQL STMT for Stg Search Order', l_stmt);
1342: End if;
1343:
1344: --Wms_re_common_pvt.ShowSQL(l_stmt);
1345: inv_sql_binding_pvt.ShowBindVars;
1346:
1347: -- 2nd step: get a cursor and parse the SQL statement
1348: l_cursor := dbms_sql.open_cursor;

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

1740: -- Changed ...
1741: -- Previous version
1742: --
1743: -- Initial version 1.0
1744: -- Notes : calls API's of Wms_re_common_pvt, WMS_Rule_PVT
1745: -- and INV_Quantity_Tree_PVT
1746: -- This API must be called internally by
1747: -- WMS_Engine_PVT.Create_Suggestions only !
1748: -- End of comments

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

2092: log_event(l_api_name,'', 'after init strategyrules ');
2093:
2094: -- Loop through all the rules, until all input lines are satisfied
2095: if l_debug = 1 THEN
2096: log_event(l_api_name,'', 'getcountinputlines '||wms_re_common_pvt.getcountinputlines);
2097: END IF;
2098:
2099: --- [ Lot Indiv 3.1.6 Indivisible Lot support
2100: --- Getting the max and min tolerance for lot_indivisable items and storing in global vars

Line 2226: while Wms_re_common_pvt.GetCountInputLines > 0 OR p_strategy_id IS NULL LOOP

2222: log_statement(l_api_name, 'WMS_RULE_PVT.g_over_allocation ', WMS_RULE_PVT.g_over_allocation);
2223: END IF;
2224: --- [ End get_tolerance() ]
2225: ---
2226: while Wms_re_common_pvt.GetCountInputLines > 0 OR p_strategy_id IS NULL LOOP
2227: If l_debug = 1 THEN
2228: log_event(l_api_name,'', 'looping rules ');
2229: END IF;
2230:

Line 2237: wms_re_common_pvt.GetNextRule ( l_rule_id

2233: IF p_strategy_id IS NOT null AND
2234: l_simulation_mode NOT IN (2,4) THEN
2235:
2236: -- Get the next rule
2237: wms_re_common_pvt.GetNextRule ( l_rule_id
2238: ,l_partial_success_allowed_flag );
2239:
2240: If l_debug = 1 THEN
2241: log_event(l_api_name,'', 'get rule '||l_rule_id);