DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_RE_COMMON_PVT

Line 7181: wms_re_common_pvt.initinputpointer;

7177:
7178: --get the name of the rule package
7179: getpackagename(l_rule_id, l_package_name);
7180: -- Initialize the pointer to the first trx detail input line
7181: wms_re_common_pvt.initinputpointer;
7182: --
7183: IF l_debug = 1 THEN
7184: log_statement(l_api_name, 'start_input_loop',
7185: 'Starting loop through input lines');

Line 7192: wms_re_common_pvt.getnextinputline(

7188: WHILE TRUE LOOP
7189: --
7190: l_max_tolerance := 0;
7191: -- Get the next trx detail input line
7192: wms_re_common_pvt.getnextinputline(
7193: l_pp_transaction_temp_id
7194: , l_revision
7195: , l_lot_number
7196: , l_lot_expiration_date

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

10806: SET primary_quantity = l_needed_quantity
10807: , secondary_quantity = l_sec_needed_quantity
10808: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
10809:
10810: wms_re_common_pvt.updateinputline(l_needed_quantity,l_sec_needed_quantity);
10811: END IF;
10812: END IF;
10813: ELSE
10814: x_finished := fnd_api.g_true;

Line 10826: wms_re_common_pvt.deleteinputline;

10822: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
10823:
10824: --
10825: -- and delete input record in PL/SQL table, too
10826: wms_re_common_pvt.deleteinputline;
10827: END IF;
10828:
10829: IF l_debug_on THEN
10830: wms_search_order_globals_pvt.insert_trace_lines(

Line 11550: wms_re_common_pvt.InitInputPointer;

11546: log_statement(l_api_name, 'input_task', 'Task: ' || p_task_id);
11547: End if;
11548:
11549: -- Initialize the pointer to the first trx detail input line
11550: wms_re_common_pvt.InitInputPointer;
11551: --
11552: If (l_debug = 1) then
11553: log_statement(l_api_name, 'start_input_loop',
11554: 'Starting loop through input lines');

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

11563: use_supplied_loc := TRUE;
11564: WHILE use_supplied_loc LOOP
11565: If (l_debug = 1) then
11566: log_statement(l_api_name, 'getting input line',
11567: 'calling wms_re_common_pvt.GetNextInputLine to get input line');
11568: End if;
11569:
11570: --
11571: -- Get the next trx detail input line

Line 11572: wms_re_common_pvt.GetNextInputLine ( l_pp_transaction_temp_id

11568: End if;
11569:
11570: --
11571: -- Get the next trx detail input line
11572: wms_re_common_pvt.GetNextInputLine ( l_pp_transaction_temp_id
11573: ,l_revision
11574: ,l_lot_number
11575: ,l_lot_expiration_date
11576: ,l_from_subinventory_code

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

11787: -- Loop through all the trx detail input lines
11788: WHILE use_supplied_loc LOOP
11789: If (l_debug = 1) then
11790: log_statement(l_api_name, 'getting input line',
11791: 'calling wms_re_common_pvt.GetNextInputLine to get input line');
11792: End if;
11793:
11794: --
11795: -- Get the next trx detail input line

Line 11796: wms_re_common_pvt.GetNextInputLine ( l_pp_transaction_temp_id

11792: End if;
11793:
11794: --
11795: -- Get the next trx detail input line
11796: wms_re_common_pvt.GetNextInputLine ( l_pp_transaction_temp_id
11797: ,l_revision
11798: ,l_lot_number
11799: ,l_lot_expiration_date
11800: ,l_from_subinventory_code

Line 12078: wms_re_common_pvt.DeleteInputLine;

12074: FROM WMS_TRANSACTIONS_TEMP
12075: WHERE pp_transaction_temp_id = l_pp_transaction_temp_id;
12076: --
12077: -- and delete input record in PL/SQL table, too
12078: wms_re_common_pvt.DeleteInputLine;
12079: END IF;
12080: IF l_debug_on THEN
12081: wms_search_order_globals_pvt.insert_trace_lines(
12082: p_api_version => 1.0

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

12167: --
12168: -- Version :
12169: -- Current version 1.0
12170: --
12171: -- Notes : calls API's of WMS_RE_Common_PVT
12172: --
12173: PROCEDURE checksyntax(
12174: p_api_version IN NUMBER
12175: , p_init_msg_list IN VARCHAR2

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

12248:
12249: -- Version :
12250: -- Current version 1.0
12251: --
12252: -- Notes : calls API's of WMS_RE_Common_PVT
12253: --
12254: PROCEDURE find_rule(
12255: p_api_version IN NUMBER
12256: , p_init_msg_list IN VARCHAR2

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

15273: ,x_default_lot_status_id => l_default_lot_status_id
15274: ,x_serial_status_enabled => l_serial_status_enabled
15275: ,x_default_serial_status_id => l_default_serial_status_id);
15276:
15277: wms_re_common_pvt.initinputpointer; -- Initialize the pointer
15278: -- to the first trx detail input line
15279:
15280: IF l_debug = 1 THEN
15281: log_statement(l_api_name, 'Quick Pick',

Line 15295: wms_re_common_pvt.getnextinputline(

15291: 'Get the next trx detail input line ');
15292: END IF;
15293:
15294: -- Get the next trx detail input line
15295: wms_re_common_pvt.getnextinputline(
15296: l_pp_transaction_temp_id
15297: , l_revision
15298: , l_lot_number
15299: , l_lot_expiration_date

Line 16217: wms_re_common_pvt.initinputpointer;

16213:
16214: --get the name of the rule package
16215: getpackagename(l_rule_id, l_package_name);
16216: -- Initialize the pointer to the first trx detail input line
16217: wms_re_common_pvt.initinputpointer;
16218: --
16219: IF l_debug = 1 THEN
16220: log_statement(l_api_name, 'get line ', 'get line input');
16221: END IF;

Line 16222: wms_re_common_pvt.getnextinputline(

16218: --
16219: IF l_debug = 1 THEN
16220: log_statement(l_api_name, 'get line ', 'get line input');
16221: END IF;
16222: wms_re_common_pvt.getnextinputline(
16223: l_pp_transaction_temp_id
16224: , l_revision
16225: , l_lot_number
16226: , l_lot_expiration_date