DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_RE_COMMON_PVT

Line 9075: wms_re_common_pvt.initinputpointer;

9071: -- get the name of the rule package
9072: getpackagename(l_rule_id, l_package_name);
9073:
9074: -- Initialize the pointer to the first trx detail input line
9075: wms_re_common_pvt.initinputpointer;
9076:
9077: IF l_debug = 1 THEN
9078: log_statement(l_api_name, 'start_input_loop',
9079: 'Starting loop through input lines');

Line 9086: wms_re_common_pvt.getnextinputline(

9082: WHILE TRUE LOOP --{
9083: l_max_tolerance := 0;
9084: l_max_sec_tolerance := 0;
9085: -- Get the next trx detail input line
9086: wms_re_common_pvt.getnextinputline(
9087: l_pp_transaction_temp_id
9088: , l_revision
9089: , l_lot_number
9090: , l_lot_expiration_date

Line 13349: wms_re_common_pvt.updateinputline(l_needed_quantity,l_sec_needed_quantity);

13345: SET primary_quantity = l_needed_quantity
13346: , secondary_quantity = l_sec_needed_quantity
13347: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
13348:
13349: wms_re_common_pvt.updateinputline(l_needed_quantity,l_sec_needed_quantity);
13350: END IF;
13351: END IF;
13352: --}
13353: ELSE --{

Line 13367: wms_re_common_pvt.deleteinputline;

13363: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
13364:
13365: --
13366: -- and delete input record in PL/SQL table, too
13367: wms_re_common_pvt.deleteinputline;
13368:
13369: -- Bug 13496654 ---
13370: IF l_debug = 1 THEN
13371: log_statement(l_api_name, 'After deleting Wms_re_common_pvt.GetCountInputLines ',

Line 13371: log_statement(l_api_name, 'After deleting Wms_re_common_pvt.GetCountInputLines ',

13367: wms_re_common_pvt.deleteinputline;
13368:
13369: -- Bug 13496654 ---
13370: IF l_debug = 1 THEN
13371: log_statement(l_api_name, 'After deleting Wms_re_common_pvt.GetCountInputLines ',
13372: Wms_re_common_pvt.GetCountInputLines);
13373: END IF;
13374: IF p_type_code = 2 AND Wms_re_common_pvt.GetCountInputLines > 0 /*and l_consist_existsi */
13375: AND x_finished = fnd_api.g_true

Line 13372: Wms_re_common_pvt.GetCountInputLines);

13368:
13369: -- Bug 13496654 ---
13370: IF l_debug = 1 THEN
13371: log_statement(l_api_name, 'After deleting Wms_re_common_pvt.GetCountInputLines ',
13372: Wms_re_common_pvt.GetCountInputLines);
13373: END IF;
13374: IF p_type_code = 2 AND Wms_re_common_pvt.GetCountInputLines > 0 /*and l_consist_existsi */
13375: AND x_finished = fnd_api.g_true
13376: THEN

Line 13374: IF p_type_code = 2 AND Wms_re_common_pvt.GetCountInputLines > 0 /*and l_consist_existsi */

13370: IF l_debug = 1 THEN
13371: log_statement(l_api_name, 'After deleting Wms_re_common_pvt.GetCountInputLines ',
13372: Wms_re_common_pvt.GetCountInputLines);
13373: END IF;
13374: IF p_type_code = 2 AND Wms_re_common_pvt.GetCountInputLines > 0 /*and l_consist_existsi */
13375: AND x_finished = fnd_api.g_true
13376: THEN
13377: x_finished := fnd_api.g_false;
13378: IF l_debug = 1 THEN

Line 13381: ELSIF p_type_code = 2 AND Wms_re_common_pvt.GetCountInputLines = 0 AND x_finished = fnd_api.g_false

13377: x_finished := fnd_api.g_false;
13378: IF l_debug = 1 THEN
13379: log_statement(l_api_name, 'p_type_code 2: After x_finished :' , 'False' );
13380: END IF;
13381: ELSIF p_type_code = 2 AND Wms_re_common_pvt.GetCountInputLines = 0 AND x_finished = fnd_api.g_false
13382: THEN
13383: IF l_debug = 1 THEN
13384: log_statement(l_api_name, 'GetCountInputLines = 0 / x_finished :' , 'True' );
13385: END IF;

Line 13392: log_statement(l_api_name, 'Wms_re_common_pvt.GetCountInputLines ' , Wms_re_common_pvt.GetCountInputLines );

13388: ----------- end of bug fix 13496654
13389:
13390: -- start of 8744417
13391: IF l_debug = 1 THEN
13392: log_statement(l_api_name, 'Wms_re_common_pvt.GetCountInputLines ' , Wms_re_common_pvt.GetCountInputLines );
13393: END IF;
13394: IF p_type_code = 1 AND Wms_re_common_pvt.GetCountInputLines > 0
13395: AND x_finished = fnd_api.g_true
13396: THEN

Line 13394: IF p_type_code = 1 AND Wms_re_common_pvt.GetCountInputLines > 0

13390: -- start of 8744417
13391: IF l_debug = 1 THEN
13392: log_statement(l_api_name, 'Wms_re_common_pvt.GetCountInputLines ' , Wms_re_common_pvt.GetCountInputLines );
13393: END IF;
13394: IF p_type_code = 1 AND Wms_re_common_pvt.GetCountInputLines > 0
13395: AND x_finished = fnd_api.g_true
13396: THEN
13397: x_finished := fnd_api.g_false;
13398: IF l_debug = 1 THEN

Line 13401: ELSIF p_type_code = 1 AND Wms_re_common_pvt.GetCountInputLines = 0

13397: x_finished := fnd_api.g_false;
13398: IF l_debug = 1 THEN
13399: log_statement(l_api_name, 'After x_finished :' , 'False' );
13400: END IF;
13401: ELSIF p_type_code = 1 AND Wms_re_common_pvt.GetCountInputLines = 0
13402: AND x_finished = fnd_api.g_false
13403: THEN
13404: x_finished := fnd_api.g_true;
13405: IF l_debug = 1 THEN

Line 14134: wms_re_common_pvt.InitInputPointer;

14130: log_statement(l_api_name, 'input_task', 'Task: ' || p_task_id);
14131: End if;
14132:
14133: -- Initialize the pointer to the first trx detail input line
14134: wms_re_common_pvt.InitInputPointer;
14135: --
14136: If (l_debug = 1) then
14137: log_statement(l_api_name, 'start_input_loop',
14138: 'Starting loop through input lines');

Line 14151: 'calling wms_re_common_pvt.GetNextInputLine to get input line');

14147: use_supplied_loc := TRUE;
14148: WHILE use_supplied_loc LOOP
14149: If (l_debug = 1) then
14150: log_statement(l_api_name, 'getting input line',
14151: 'calling wms_re_common_pvt.GetNextInputLine to get input line');
14152: End if;
14153:
14154: --
14155: -- Get the next trx detail input line

Line 14156: wms_re_common_pvt.GetNextInputLine ( l_pp_transaction_temp_id

14152: End if;
14153:
14154: --
14155: -- Get the next trx detail input line
14156: wms_re_common_pvt.GetNextInputLine ( l_pp_transaction_temp_id
14157: ,l_revision
14158: ,l_lot_number
14159: ,l_lot_expiration_date
14160: ,l_from_subinventory_code

Line 14384: 'calling wms_re_common_pvt.GetNextInputLine to get input line');

14380: -- Loop through all the trx detail input lines
14381: WHILE use_supplied_loc LOOP
14382: If (l_debug = 1) then
14383: log_statement(l_api_name, 'getting input line',
14384: 'calling wms_re_common_pvt.GetNextInputLine to get input line');
14385: End if;
14386:
14387: --
14388: -- Get the next trx detail input line

Line 14389: wms_re_common_pvt.GetNextInputLine ( l_pp_transaction_temp_id

14385: End if;
14386:
14387: --
14388: -- Get the next trx detail input line
14389: wms_re_common_pvt.GetNextInputLine ( l_pp_transaction_temp_id
14390: ,l_revision
14391: ,l_lot_number
14392: ,l_lot_expiration_date
14393: ,l_from_subinventory_code

Line 14679: wms_re_common_pvt.DeleteInputLine;

14675: FROM WMS_TRANSACTIONS_TEMP
14676: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
14677: --
14678: -- and delete input record in PL/SQL table, too
14679: wms_re_common_pvt.DeleteInputLine;
14680: END IF;
14681: IF l_debug_on THEN
14682: wms_search_order_globals_pvt.insert_trace_lines(
14683: p_api_version => 1.0

Line 14772: -- Notes : calls API's of WMS_RE_Common_PVT

14768: --
14769: -- Version :
14770: -- Current version 1.0
14771: --
14772: -- Notes : calls API's of WMS_RE_Common_PVT
14773: --
14774: PROCEDURE checksyntax(
14775: p_api_version IN NUMBER
14776: , p_init_msg_list IN VARCHAR2

Line 14853: -- Notes : calls API's of WMS_RE_Common_PVT

14849:
14850: -- Version :
14851: -- Current version 1.0
14852: --
14853: -- Notes : calls API's of WMS_RE_Common_PVT
14854: --
14855: PROCEDURE find_rule(
14856: p_api_version IN NUMBER
14857: , p_init_msg_list IN VARCHAR2

Line 17935: wms_re_common_pvt.initinputpointer; -- Initialize the pointer

17931: ,x_default_lot_status_id => l_default_lot_status_id
17932: ,x_serial_status_enabled => l_serial_status_enabled
17933: ,x_default_serial_status_id => l_default_serial_status_id);
17934:
17935: wms_re_common_pvt.initinputpointer; -- Initialize the pointer
17936: -- to the first trx detail input line
17937:
17938: IF l_debug = 1 THEN
17939: log_statement(l_api_name, 'Quick Pick',

Line 17953: wms_re_common_pvt.getnextinputline(

17949: 'Get the next trx detail input line ');
17950: END IF;
17951:
17952: -- Get the next trx detail input line
17953: wms_re_common_pvt.getnextinputline(
17954: l_pp_transaction_temp_id
17955: , l_revision
17956: , l_lot_number
17957: , l_lot_expiration_date

Line 18859: wms_re_common_pvt.initinputpointer;

18855:
18856: --get the name of the rule package
18857: getpackagename(l_rule_id, l_package_name);
18858: -- Initialize the pointer to the first trx detail input line
18859: wms_re_common_pvt.initinputpointer;
18860: --
18861: IF l_debug = 1 THEN
18862: log_statement(l_api_name, 'get line ', 'get line input');
18863: END IF;

Line 18864: wms_re_common_pvt.getnextinputline(

18860: --
18861: IF l_debug = 1 THEN
18862: log_statement(l_api_name, 'get line ', 'get line input');
18863: END IF;
18864: wms_re_common_pvt.getnextinputline(
18865: l_pp_transaction_temp_id
18866: , l_revision
18867: , l_lot_number
18868: , l_lot_expiration_date