APPS.INV_ONHAND_BALANCE dependencies on WMS_DEPLOY

Line 35: l_wms_deployment_mode varchar2(1);

31:
32: l_msg_parameter_list WF_PARAMETER_LIST_T;
33: l_txn_hist_record INV_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
34:
35: l_wms_deployment_mode varchar2(1);
36:
37: invalid_event_name EXCEPTION;
38: update_history EXCEPTION;
39:

Line 69: l_wms_deployment_mode := WMS_DEPLOY.WMS_DEPLOYMENT_MODE;

65: inv_trx_util_pub.TRACE('l_transaction_code is '||l_transaction_code, 'INV_ONHAND_BALANCE', 9);
66: end if;
67:
68: l_Event_Key := l_txn_hist_record.Event_Key;
69: l_wms_deployment_mode := WMS_DEPLOY.WMS_DEPLOYMENT_MODE;
70:
71:
72: IF ( l_Transaction_Code in ('ONHAND') ) THEN --{
73: -- Generate the document number for outgoing documents.

Line 80: IF (l_wms_deployment_mode = 'L') THEN

76: if (g_debug = 1) then
77: inv_trx_util_pub.TRACE('trading_partner_id is '||P_txn_hist_record.trading_partner_id, 'INV_ONHAND_BALANCE', 9);
78: end if;
79:
80: IF (l_wms_deployment_mode = 'L') THEN
81:
82: SELECT trading_partner_site_id
83: INTO l_Party_Site_ID
84: FROM mtl_client_parameters

Line 113: IF ( l_wms_deployment_mode = 'L') then

109: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_SITE_ID',
110: p_value => l_Party_Site_ID,
111: p_parameterlist => l_msg_parameter_list);
112:
113: IF ( l_wms_deployment_mode = 'L') then
114:
115: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
116: p_value => 'C',
117: p_parameterlist => l_msg_parameter_list);

Line 177: IF ( l_wms_deployment_mode = 'L') then

173: inv_trx_util_pub.TRACE('Transaction Type is '|| 'INV', 'INV_ONHAND_BALANCE', 9);
174: end if;
175:
176:
177: IF ( l_wms_deployment_mode = 'L') then
178:
179: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
180: p_value => 'ONHAND',
181: p_parameterlist => l_msg_parameter_list);

Line 298: l_wms_deployment_mode VARCHAR2(1);

294:
295: l_orig_Event_Key VARCHAR2 (240);
296: l_curr_txn_hist_record inv_transactions_history_pkg.Txns_History_Record_Type;
297: l_Return_Status VARCHAR2 (1);
298: l_wms_deployment_mode VARCHAR2(1);
299: l_party_id NUMBER;
300: l_xml_document_id NUMBER;
301:
302: invalid_entity_type EXCEPTION;

Line 348: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;

344: l_curr_txn_hist_record.Action_Type := P_Action_Type;
345: l_curr_txn_hist_record.Transaction_Status := 'ST';
346: l_curr_txn_hist_record.Document_Number := l_xml_document_id; --P_Entity_ID;
347:
348: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;
349:
350: inv_trx_util_pub.TRACE('l_wms_deployment_mode ' || l_wms_deployment_mode, 'INV_ONHAND_BALANCE', 9);
351:
352: If (l_wms_deployment_mode = 'L') then

Line 350: inv_trx_util_pub.TRACE('l_wms_deployment_mode ' || l_wms_deployment_mode, 'INV_ONHAND_BALANCE', 9);

346: l_curr_txn_hist_record.Document_Number := l_xml_document_id; --P_Entity_ID;
347:
348: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;
349:
350: inv_trx_util_pub.TRACE('l_wms_deployment_mode ' || l_wms_deployment_mode, 'INV_ONHAND_BALANCE', 9);
351:
352: If (l_wms_deployment_mode = 'L') then
353:
354: l_curr_txn_hist_record.Client_Code := P_client_code;

Line 352: If (l_wms_deployment_mode = 'L') then

348: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;
349:
350: inv_trx_util_pub.TRACE('l_wms_deployment_mode ' || l_wms_deployment_mode, 'INV_ONHAND_BALANCE', 9);
351:
352: If (l_wms_deployment_mode = 'L') then
353:
354: l_curr_txn_hist_record.Client_Code := P_client_code;
355:
356: SELECT party_id

Line 561: l_where_stmt :=l_where_stmt||' and wms_deploy.get_client_code(item_id) ='''||p_client_code||''' ';

557: if p_warehouse_id is not null then
558: l_where_stmt :=l_where_stmt||' and WAREHOUSE_ID ='||p_warehouse_id;
559: end if;
560: if p_client_code is not null then
561: l_where_stmt :=l_where_stmt||' and wms_deploy.get_client_code(item_id) ='''||p_client_code||''' ';
562: end if;
563: if p_subinventory is not null then
564: l_where_stmt :=l_where_stmt||' and SUBINVENTORY = '''||p_subinventory||''' ';
565: end if;