DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on WMS_INSTALL

Line 3448: l_wms_installed BOOLEAN := FALSE;

3444: l_comingle_org NUMBER;
3445: l_comingle_cg NUMBER;
3446: label_status VARCHAR2(512);
3447: --l_call_tm BOOLEAN := FALSE;
3448: l_wms_installed BOOLEAN := FALSE;
3449: l_org NUMBER;
3450: l_containers NUMBER;
3451: l_is_cartonization NUMBER;
3452: l_prev_trx_batch_id NUMBER;

Line 3560: -- WMS_INSTALL.G_WMS_INSTALLATION_STATUS gets set properly.

3556:
3557:
3558:
3559: -- for bug 2726323 : Calling this funtion so as the variable
3560: -- WMS_INSTALL.G_WMS_INSTALLATION_STATUS gets set properly.
3561: l_return_status :=
3562: wms_install.check_install(x_return_status => ret_status, x_msg_count => ret_msgcnt, x_msg_data => ret_msgdata
3563: , p_organization_id => NULL);
3564:

Line 3562: wms_install.check_install(x_return_status => ret_status, x_msg_count => ret_msgcnt, x_msg_data => ret_msgdata

3558:
3559: -- for bug 2726323 : Calling this funtion so as the variable
3560: -- WMS_INSTALL.G_WMS_INSTALLATION_STATUS gets set properly.
3561: l_return_status :=
3562: wms_install.check_install(x_return_status => ret_status, x_msg_count => ret_msgcnt, x_msg_data => ret_msgdata
3563: , p_organization_id => NULL);
3564:
3565:
3566:

Line 3568: IF (wms_install.g_wms_installation_status = 'I') THEN

3564:
3565:
3566:
3567: -- Check if WMS is installed, if so check for cartonization transaction
3568: IF (wms_install.g_wms_installation_status = 'I') THEN
3569: BEGIN
3570: SELECT 1
3571: INTO l_is_cartonization
3572: FROM DUAL

Line 5955: wms_install.check_install(x_return_status => ret_status, x_msg_count => ret_msgcnt, x_msg_data => ret_msgdata

5951:
5952: IF (p_transaction_action_id <> inv_globals.g_action_costgroupxfr) THEN
5953: -- Check transfer org to see if it is wms enabled
5954: IF (
5955: wms_install.check_install(x_return_status => ret_status, x_msg_count => ret_msgcnt, x_msg_data => ret_msgdata
5956: , p_organization_id => v_xfr_org)
5957: ) THEN
5958: -- Get the LPN_CONTROLLED_FLAG status of the transfer subinventory
5959: SELECT lpn_controlled_flag