eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on WMS_SEARCH_ORDER_GLOBALS_PVT

Line 1: Package Body WMS_SEARCH_ORDER_GLOBALS_PVT AS

1: Package Body WMS_SEARCH_ORDER_GLOBALS_PVT AS
2: /* $Header: WMSSOGBB.pls 120.2 2005/07/18 05:22:17 ajohnson noship $ */
3:
4:
5: -- File : WMSSOGBB.pls

Line 6: -- Content : WMS_SEARCH_ORDER_GLOBALS_PVT package body

2: /* $Header: WMSSOGBB.pls 120.2 2005/07/18 05:22:17 ajohnson noship $ */
3:
4:
5: -- File : WMSSOGBB.pls
6: -- Content : WMS_SEARCH_ORDER_GLOBALS_PVT package body
7: -- Description : This API is created to store Rules Engine Process flow
8: -- Variabls. This API Gobal Variable will be updated by
9: --- WMS_RULES_ENGINE_PVT and to be refrenced by WMSRLSIM.fmb
10:

Line 17: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

13: -- --------- ------ ------------------------------------------
14:
15: --Procedures for logging messages
16: PROCEDURE log_event(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
17: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
18: l_module VARCHAR2(255);
19:
20: BEGIN
21: --l_progress := l_progress + 10;

Line 27: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

23: inv_log_util.trace(p_message, l_module, 9);
24: END log_event;
25:
26: PROCEDURE log_error(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
27: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
28: l_module VARCHAR2(255);
29:
30: BEGIN
31: l_module:= 'wms.plsql.'||g_pkg_name || '.' || p_api_name || '.' || p_label;

Line 36: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

32: inv_log_util.trace(p_message, l_module, 9);
33: END log_error;
34:
35: PROCEDURE log_error_msg(p_api_name VARCHAR2, p_label VARCHAR2) IS
36: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
37: l_module VARCHAR2(255);
38: BEGIN
39: l_module:= 'wms.plsql.'|| g_pkg_name ||'.' || p_api_name || '.' || p_label;
40: inv_log_util.trace(p_label, l_module, 9);

Line 45: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

41: END log_error_msg;
42:
43: PROCEDURE log_procedure(p_api_name VARCHAR2, p_label VARCHAR2,
44: p_message VARCHAR2) IS
45: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
46: l_module VARCHAR2(255);
47: BEGIN
48:
49: l_module:= 'wms.plsql.'||g_pkg_name || '.' || p_api_name || '.' || p_label;

Line 54: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

50: inv_log_util.trace(p_message, l_module, 9);
51: END log_procedure;
52:
53: PROCEDURE log_statement(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
54: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
55: l_module VARCHAR2(255);
56: BEGIN
57:
58: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;

Line 70: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

66: RETURN VARCHAR2 is
67: l_object_type VARCHAR2(80) := NULL;
68: l_object_type_id NUMBER := NULL;
69: l_engine_type VARCHAR2(20) := NULL;
70: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
71: l_api_name constant VARCHAR2(30) := 'get_object_type';
72:
73: BEGIN
74: l_engine_type := engine_type;

Line 123: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

119: l_pk3_value VARCHAR2(150);
120: l_pk4_value VARCHAR2(150);
121: l_pk5_value VARCHAR2(150);
122:
123: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
124: l_api_name constant VARCHAR2(30) := 'get_object_NAME';
125:
126: BEGIN
127:

Line 194: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

190: l_strategy VARCHAR2(80) := NULL;
191: l_strategy_id NUMBER ;
192: l_org_id NUMBER ;
193: l_engine_type VARCHAR2(20) := NULL;
194: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
195: l_api_name constant VARCHAR2(30) := 'get_strategy_name';
196: BEGIN
197: l_engine_type := engine_type;
198: l_org_id := org_id;

Line 242: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

238: l_rule VARCHAR2(80) := NULL;
239: l_rule_id NUMBER ;
240: l_org_id NUMBER ;
241: l_engine_type VARCHAR2(20) := NULL;
242: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
243: l_api_name constant VARCHAR2(30) := 'get_rule_name';
244: BEGIN
245: l_engine_type := engine_type;
246: l_org_id := org_id;

Line 286: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

282: l_costgroup VARCHAR2(80) := NULL;
283: l_costgroup_id NUMBER ;
284: l_org_id NUMBER ;
285: l_engine_type VARCHAR2(20) := NULL;
286: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
287: l_api_name constant VARCHAR2(30) := 'get_rule_name';
288: BEGIN
289: l_engine_type := engine_type;
290: l_org_id := org_id;

Line 323: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

319: l_costgroup_desc VARCHAR2(80) := NULL;
320: l_costgroup_id NUMBER ;
321: l_org_id NUMBER ;
322: l_engine_type VARCHAR2(20) := NULL;
323: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
324: l_api_name constant VARCHAR2(30) := 'get_rule_name';
325: BEGIN
326: l_engine_type := engine_type;
327: l_org_id := org_id;

Line 431: log_procedure('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Simulate Rule', 'Start Simulate Rules');

427:
428: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
429: --
430: If l_debug = 1 THEN
431: log_procedure('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Simulate Rule', 'Start Simulate Rules');
432: log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'init_global_variables', 'Populate Item details in Suggestion Block');
433: log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Delete', 'Deleteting all records from WTT');
434: End if;
435: --- Populate Item details in Suggestion Block ---

Line 432: log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'init_global_variables', 'Populate Item details in Suggestion Block');

428: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
429: --
430: If l_debug = 1 THEN
431: log_procedure('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Simulate Rule', 'Start Simulate Rules');
432: log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'init_global_variables', 'Populate Item details in Suggestion Block');
433: log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Delete', 'Deleteting all records from WTT');
434: End if;
435: --- Populate Item details in Suggestion Block ---
436: l_line_id := p_mo_line_id;

Line 433: log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Delete', 'Deleteting all records from WTT');

429: --
430: If l_debug = 1 THEN
431: log_procedure('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Simulate Rule', 'Start Simulate Rules');
432: log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'init_global_variables', 'Populate Item details in Suggestion Block');
433: log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Delete', 'Deleteting all records from WTT');
434: End if;
435: --- Populate Item details in Suggestion Block ---
436: l_line_id := p_mo_line_id;
437: l_simulation_id := p_simulation_id;

Line 441: wms_search_order_globals_pvt.init_global_variables;

437: l_simulation_id := p_simulation_id;
438: l_simulation_mode := p_simulation_flag;
439:
440: ---- Initilizeing Search Order Global Variables
441: wms_search_order_globals_pvt.init_global_variables;
442:
443: rollback;
444: inv_quantity_tree_pvt.clear_quantity_cache;
445: --- Deleteting all records from WTT

Line 458: log_procedure('WMS_SEARCH_ORDER_GLOBALS_PVT', 'create_suggestions',

454: DELETE_TRACE_ROWS; --(l_line_id);
455: G_SIMULATION_MODE := 'Y' ;
456:
457: if l_debug = 1 then
458: log_procedure('WMS_SEARCH_ORDER_GLOBALS_PVT', 'create_suggestions',
459: 'Calling wms_engine_pvt.create_suggestions ');
460: log_statement('SEARCH_ORDER_GLOBALS', 'p_transaction_temp_id =>' ,to_char(l_line_id));
461: log_statement('', 'p_simulation_id =>' ,to_char(l_simulation_id));
462: log_statement('', 'p_simulation_mode =>' ,to_char(l_simulation_id));

Line 497: log_procedure('WMS_SEARCH_ORDER_GLOBALS_PVT', 'release_lock',

493: from mtl_txn_request_lines
494: where line_id = l_line_id;
495:
496: if l_debug = 1 then
497: log_procedure('WMS_SEARCH_ORDER_GLOBALS_PVT', 'release_lock',
498: 'Calling inv_quantity_tree_pvt.release_lock');
499: end if;
500:
501: inv_quantity_tree_pvt.release_lock(

Line 547: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

543: ,p_strategy_id in NUMBER
544: ) IS
545: -- API standard variables
546: l_api_version constant number := 1.0;
547: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
548: l_api_name constant varchar2(30) := ' insert_trace_header';
549: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
550: l_row_id VARCHAR2(20);
551: l_object_name VARCHAR2(4000);

Line 652: ---- Based on the rows im the WMS_SEARCH_ORDER_GLOBALS_PVT.pre_suggestions_record_tbl

648: ,p_data => x_msg_data );*/
649:
650: end insert_trace_header;
651: ------------------------------------------------------------------------------------
652: ---- Based on the rows im the WMS_SEARCH_ORDER_GLOBALS_PVT.pre_suggestions_record_tbl
653: ---- equal number of records are created in the trace lines table for each Header Id
654: --------------------------------------------------------------------------------------
655: procedure insert_trace_lines
656: (

Line 665: ,p_pre_suggestions in WMS_SEARCH_ORDER_GLOBALS_PVT.pre_suggestions_record_tbl

661: ,x_msg_count out NOCOPY number
662: ,x_msg_data out NOCOPY varchar2
663: ,p_header_id in NUMBER
664: ,p_rule_id in NUMBER
665: ,p_pre_suggestions in WMS_SEARCH_ORDER_GLOBALS_PVT.pre_suggestions_record_tbl
666: ) IS
667: -- API standard variables
668: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
669: l_api_version constant number := 1.0;

Line 668: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

664: ,p_rule_id in NUMBER
665: ,p_pre_suggestions in WMS_SEARCH_ORDER_GLOBALS_PVT.pre_suggestions_record_tbl
666: ) IS
667: -- API standard variables
668: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
669: l_api_version constant number := 1.0;
670: l_api_name constant varchar2(30) := 'insert_trace_lines';
671: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
672: l_date DATE;

Line 677: l_pre_suggestions WMS_SEARCH_ORDER_GLOBALS_PVT.pre_suggestions_record ;

673: l_user_id NUMBER;
674: l_login_id NUMBER;
675: l_found BOOLEAN;
676: l_line_id NUMBER;
677: l_pre_suggestions WMS_SEARCH_ORDER_GLOBALS_PVT.pre_suggestions_record ;
678: l_header_id NUMBER;
679: l_rule_id NUMBER;
680: l_index BINARY_INTEGER;
681: begin

Line 997: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

993: l_return_status VARCHAR2(1) := 'N';
994: l_rule_id NUMBER;
995: l_line_id NUMBER;
996:
997: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
998: l_api_name constant VARCHAR2(30) := 'IS_object_Selected';
999:
1000: BEGIN
1001: l_engine_type := p_engine_type;

Line 1093: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

1089: l_line_id NUMBER;
1090: l_org_id NUMBER;
1091: l_g_object VARCHAR2(50); /* to Hold the G_PICK_OBJECT/ G_PUTAWAY_OBJECT /G_COSTGROUP_OBJECT value */
1092:
1093: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
1094: l_api_name constant VARCHAR2(30) := 'IS_BO_object_Selected';
1095:
1096:
1097: BEGIN

Line 1112: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT is not null ) then

1108: where line_id = l_line_id;
1109: end if;
1110:
1111: if (l_engine_type = 'PICK' ) then
1112: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT is not null ) then
1113: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1114: else
1115: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT := get_object_name(l_engine_type, l_org_id);
1116: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;

Line 1113: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;

1109: end if;
1110:
1111: if (l_engine_type = 'PICK' ) then
1112: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT is not null ) then
1113: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1114: else
1115: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT := get_object_name(l_engine_type, l_org_id);
1116: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1117: end if;

Line 1115: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT := get_object_name(l_engine_type, l_org_id);

1111: if (l_engine_type = 'PICK' ) then
1112: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT is not null ) then
1113: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1114: else
1115: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT := get_object_name(l_engine_type, l_org_id);
1116: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1117: end if;
1118: elsif (l_engine_type = 'PUTAWAY') then
1119: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT is not null ) then

Line 1116: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;

1112: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT is not null ) then
1113: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1114: else
1115: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT := get_object_name(l_engine_type, l_org_id);
1116: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1117: end if;
1118: elsif (l_engine_type = 'PUTAWAY') then
1119: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT is not null ) then
1120: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;

Line 1119: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT is not null ) then

1115: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT := get_object_name(l_engine_type, l_org_id);
1116: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1117: end if;
1118: elsif (l_engine_type = 'PUTAWAY') then
1119: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT is not null ) then
1120: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1121: else
1122: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT := get_object_name(l_engine_type, l_org_id);
1123: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;

Line 1120: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;

1116: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PICK_OBJECT;
1117: end if;
1118: elsif (l_engine_type = 'PUTAWAY') then
1119: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT is not null ) then
1120: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1121: else
1122: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT := get_object_name(l_engine_type, l_org_id);
1123: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1124: end if;

Line 1122: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT := get_object_name(l_engine_type, l_org_id);

1118: elsif (l_engine_type = 'PUTAWAY') then
1119: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT is not null ) then
1120: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1121: else
1122: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT := get_object_name(l_engine_type, l_org_id);
1123: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1124: end if;
1125: elsif (l_engine_type = 'COSTGROUP') then
1126: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT is not null ) then

Line 1123: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;

1119: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT is not null ) then
1120: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1121: else
1122: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT := get_object_name(l_engine_type, l_org_id);
1123: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1124: end if;
1125: elsif (l_engine_type = 'COSTGROUP') then
1126: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT is not null ) then
1127: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;

Line 1126: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT is not null ) then

1122: WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT := get_object_name(l_engine_type, l_org_id);
1123: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1124: end if;
1125: elsif (l_engine_type = 'COSTGROUP') then
1126: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT is not null ) then
1127: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;
1128: else
1129: WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT := get_object_name(l_engine_type, l_org_id);
1130: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;

Line 1127: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;

1123: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_PUTAWAY_OBJECT;
1124: end if;
1125: elsif (l_engine_type = 'COSTGROUP') then
1126: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT is not null ) then
1127: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;
1128: else
1129: WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT := get_object_name(l_engine_type, l_org_id);
1130: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;
1131: end if;

Line 1129: WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT := get_object_name(l_engine_type, l_org_id);

1125: elsif (l_engine_type = 'COSTGROUP') then
1126: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT is not null ) then
1127: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;
1128: else
1129: WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT := get_object_name(l_engine_type, l_org_id);
1130: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;
1131: end if;
1132: end if;
1133: IF (l_g_object = l_object ) then

Line 1130: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;

1126: if (WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT is not null ) then
1127: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;
1128: else
1129: WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT := get_object_name(l_engine_type, l_org_id);
1130: l_g_object := WMS_SEARCH_ORDER_GLOBALS_PVT.G_COSTGROUP_OBJECT;
1131: end if;
1132: end if;
1133: IF (l_g_object = l_object ) then
1134: l_return_status := 'Y';

Line 1200: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';

1196: --- PRAGMA AUTONOMOUS_TRANSACTION;
1197:
1198: -- API standard variables
1199: l_api_version constant number := 1.0;
1200: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
1201: l_api_name constant varchar2(30) := 'insert_txn_trace_rows';
1202: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1203: l_txn_header_id number;
1204: l_insert_lot_flag number;

Line 2340: END; -- Package Body WMS_SEARCH_ORDER_GLOBALS_PVT

2336: END IF;
2337: RETURN l_seq_num;
2338: END get_seq_num;
2339: ---
2340: END; -- Package Body WMS_SEARCH_ORDER_GLOBALS_PVT