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.INV_UI_ITEM_SUB_LOC_LOVS dependencies on INV_UI_ITEM_SUB_LOC_LOVS

Line 1: PACKAGE BODY inv_ui_item_sub_loc_lovs AS

1: PACKAGE BODY inv_ui_item_sub_loc_lovs AS
2: /* $Header: INVITPSB.pls 120.34.12020000.9 2013/01/30 10:51:31 dazhong ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_UI_ITEM_SUB_LOC_LOVS';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_UI_ITEM_SUB_LOC_LOVS';

1: PACKAGE BODY inv_ui_item_sub_loc_lovs AS
2: /* $Header: INVITPSB.pls 120.34.12020000.9 2013/01/30 10:51:31 dazhong ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_UI_ITEM_SUB_LOC_LOVS';
5:
6: PROCEDURE debug(p_msg VARCHAR2) IS
7:
8: BEGIN

Line 2069: , inv_ui_item_sub_loc_lovs.check_loc_existence(p_organization_id, secondary_inventory_name)

2065: BEGIN
2066: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2067: OPEN x_zones FOR
2068: SELECT secondary_inventory_name
2069: , inv_ui_item_sub_loc_lovs.check_loc_existence(p_organization_id, secondary_inventory_name)
2070: , msi.description
2071: , asset_inventory
2072: , mmsv.status_id
2073: , status_code

Line 3182: AND inv_ui_item_sub_loc_lovs.vaildate_to_lpn_sub(p_lpn_id, secondary_inventory_name, l_org, p_from_sub_asset_inventory, p_wms_installed, p_transaction_type_id) = 'Y'

3178: , enable_locator_alias
3179: FROM mtl_secondary_inventories
3180: WHERE organization_id = l_org
3181: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3182: AND inv_ui_item_sub_loc_lovs.vaildate_to_lpn_sub(p_lpn_id, secondary_inventory_name, l_org, p_from_sub_asset_inventory, p_wms_installed, p_transaction_type_id) = 'Y'
3183: AND secondary_inventory_name LIKE (p_secondary_inventory_name);
3184: ELSE
3185: OPEN x_to_sub FOR
3186: SELECT secondary_inventory_name

Line 3195: AND inv_ui_item_sub_loc_lovs.vaildate_to_lpn_sub(p_lpn_id, secondary_inventory_name, l_org, p_from_sub_asset_inventory, p_wms_installed, p_transaction_type_id) = 'Y'

3191: , enable_locator_alias
3192: FROM mtl_secondary_inventories
3193: WHERE organization_id = l_org
3194: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3195: AND inv_ui_item_sub_loc_lovs.vaildate_to_lpn_sub(p_lpn_id, secondary_inventory_name, l_org, p_from_sub_asset_inventory, p_wms_installed, p_transaction_type_id) = 'Y'
3196: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
3197: AND reservable_type = 1
3198: AND lpn_controlled_flag = 1;
3199: END IF;

Line 3437: AND inv_ui_item_sub_loc_lovs.vaildate_lpn_toloc(p_lpn_id, p_subinventory_code, p_organization_id, inventory_location_id, p_wms_installed, p_transaction_type_id) = 'Y';

3433: FROM wms_item_locations_kfv
3434: WHERE organization_id = p_organization_id
3435: AND subinventory_code = p_subinventory_code
3436: AND concatenated_segments LIKE (p_concatenated_segments)
3437: AND inv_ui_item_sub_loc_lovs.vaildate_lpn_toloc(p_lpn_id, p_subinventory_code, p_organization_id, inventory_location_id, p_wms_installed, p_transaction_type_id) = 'Y';
3438: END get_lpnloc_lov;
3439:
3440: FUNCTION validate_sub_loc_status(p_lpn IN VARCHAR2, p_org_id IN NUMBER, p_sub IN VARCHAR2, p_loc_id IN NUMBER, p_not_lpn_id IN VARCHAR2 := NULL, p_parent_lpn_id IN VARCHAR2 := '0', p_txn_type_id IN NUMBER)
3441: RETURN VARCHAR2 IS

Line 4416: debug('Inside INV_UI_ITEM_SUB_LOC_LOVS.get_valid_prj_to_locs');

4412: l_org NUMBER;
4413: l_restrict_locators_code NUMBER;
4414: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4415: BEGIN
4416: debug('Inside INV_UI_ITEM_SUB_LOC_LOVS.get_valid_prj_to_locs');
4417: debug('p_alias : '|| p_alias);
4418: IF p_alias IS NULL THEN
4419: get_valid_prj_to_locs(
4420: x_locators => x_locators

Line 4483: debug('Inside INV_UI_ITEM_SUB_LOC_LOVS.get_valid_prj_to_locs :Overloaded');

4479: l_org NUMBER;
4480: l_restrict_locators_code NUMBER;
4481: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4482: BEGIN
4483: debug('Inside INV_UI_ITEM_SUB_LOC_LOVS.get_valid_prj_to_locs :Overloaded');
4484: debug('p_transaction_action_id : '|| p_transaction_action_id);
4485: debug('p_to_organization_id : '|| p_to_organization_id);
4486: debug('p_organization_id : '|| p_organization_id);
4487: debug('p_subinventory_code : '|| p_subinventory_code);

Line 4566: AND inv_ui_item_sub_loc_lovs.vaildate_lpn_toloc(p_lpn_id, p_subinventory_code, p_organization_id, inventory_location_id, p_wms_installed, p_transaction_type_id) = 'Y';

4562: AND subinventory_code = p_subinventory_code
4563: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4564: AND concatenated_segments LIKE (p_concatenated_segments)
4565: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)
4566: AND inv_ui_item_sub_loc_lovs.vaildate_lpn_toloc(p_lpn_id, p_subinventory_code, p_organization_id, inventory_location_id, p_wms_installed, p_transaction_type_id) = 'Y';
4567: END get_prj_lpnloc_lov;
4568: PROCEDURE get_prj_lpnloc_lov(
4569: x_locators OUT NOCOPY t_genref
4570: , p_organization_id IN NUMBER

Line 4609: AND inv_ui_item_sub_loc_lovs.vaildate_lpn_toloc(p_lpn_id, p_subinventory_code, p_organization_id, inventory_location_id, p_wms_installed, p_transaction_type_id) = 'Y';

4605: AND subinventory_code = p_subinventory_code
4606: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4607: AND alias = p_alias
4608: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)
4609: AND inv_ui_item_sub_loc_lovs.vaildate_lpn_toloc(p_lpn_id, p_subinventory_code, p_organization_id, inventory_location_id, p_wms_installed, p_transaction_type_id) = 'Y';
4610: END get_prj_lpnloc_lov;
4611:
4612:
4613: -- This procedure is used for user directed putaway

Line 4648: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

4644: FROM mtl_secondary_inventories
4645: WHERE organization_id = p_organization_id
4646: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4647: AND secondary_inventory_name LIKE (p_subinventory_code)
4648: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,
4649: secondary_inventory_name,
4650: p_lpn_id) = 'Y'
4651: UNION ALL
4652: SELECT msub.secondary_inventory_name

Line 4701: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

4697: WHERE organization_id = p_organization_id
4698: AND Nvl(subinventory_type,1) = 1
4699: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4700: AND secondary_inventory_name LIKE (p_subinventory_code)
4701: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,
4702: secondary_inventory_name,
4703: p_lpn_id) = 'Y';
4704: ELSIF (p_rcv_sub_only = 4) THEN
4705: -- SO XDOCK

Line 4723: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

4719: AND lpn_controlled_flag = 1
4720: AND reservable_type = 1
4721: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4722: AND secondary_inventory_name LIKE (p_subinventory_code)
4723: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,
4724: secondary_inventory_name,
4725: p_lpn_id) = 'Y';
4726: ELSIF (p_rcv_sub_only = 5) THEN
4727: -- Only include INV Subs that are non-reservable and non-LPN-Controlled

Line 4744: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

4740: AND lpn_controlled_flag = 2
4741: AND reservable_type = 2
4742: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4743: AND secondary_inventory_name LIKE (p_subinventory_code)
4744: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,
4745: secondary_inventory_name,
4746: p_lpn_id) = 'Y';
4747:
4748: ELSIF (p_rcv_sub_only = 6) THEN

Line 4766: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

4762: AND lpn_controlled_flag = 1
4763: AND reservable_type = 1
4764: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4765: AND secondary_inventory_name LIKE (p_subinventory_code)
4766: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,
4767: secondary_inventory_name,
4768: p_lpn_id) = 'Y'
4769: UNION ALL
4770: SELECT msub.secondary_inventory_name

Line 4803: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

4799: AND lpn_controlled_flag = 2
4800: AND reservable_type = 2
4801: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4802: AND secondary_inventory_name LIKE (p_subinventory_code)
4803: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,
4804: secondary_inventory_name,
4805: p_lpn_id) = 'Y'
4806: UNION ALL
4807: SELECT msub.secondary_inventory_name

Line 4838: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

4834: FROM mtl_secondary_inventories
4835: WHERE organization_id = p_organization_id
4836: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4837: AND secondary_inventory_name LIKE (p_subinventory_code)
4838: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,
4839: secondary_inventory_name,
4840: p_lpn_id) = 'Y'
4841: ORDER BY UPPER(secondary_inventory_name);
4842: END IF;

Line 4850: -- get_userput_subs in this package: INV_UI_ITEM_SUB_LOC_LOVS

4846:
4847: -- This function will validate the LPN for item/sub restrictions
4848: -- and also for sub material status for each move order line transaction.
4849: -- This function should only be called from the procedure
4850: -- get_userput_subs in this package: INV_UI_ITEM_SUB_LOC_LOVS
4851: FUNCTION validate_lpn_sub(
4852: p_organization_id IN NUMBER
4853: , p_subinventory_code IN VARCHAR2
4854: , p_lpn_id IN NUMBER)

Line 4990: AND inv_ui_item_sub_loc_lovs.validate_lpn_loc(p_organization_id,

4986: AND subinventory_code = p_subinventory_code
4987: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4988: AND alias = p_alias
4989: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)
4990: AND inv_ui_item_sub_loc_lovs.validate_lpn_loc(p_organization_id,
4991: p_subinventory_code,
4992: inventory_location_id,
4993: p_lpn_id) = 'Y'
4994: ORDER BY 2;

Line 5020: AND inv_ui_item_sub_loc_lovs.validate_lpn_loc(p_organization_id,

5016: AND subinventory_code = p_subinventory_code
5017: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5018: AND concatenated_segments LIKE (p_concatenated_segments)
5019: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)
5020: AND inv_ui_item_sub_loc_lovs.validate_lpn_loc(p_organization_id,
5021: p_subinventory_code,
5022: inventory_location_id,
5023: p_lpn_id) = 'Y'
5024: ORDER BY 2;

Line 5031: -- get_userput_locs in this package: INV_UI_ITEM_SUB_LOC_LOVS

5027:
5028: -- This function will validate the LPN for item/sub/loc restrictions
5029: -- and also for locator material status for each move order line transaction.
5030: -- This function should only be called from the procedure
5031: -- get_userput_locs in this package: INV_UI_ITEM_SUB_LOC_LOVS
5032: FUNCTION validate_lpn_loc(p_organization_id IN NUMBER ,
5033: p_subinventory_code IN VARCHAR2 ,
5034: p_locator_id IN NUMBER ,
5035: p_lpn_id IN NUMBER)

Line 6687: DEBUG('INV_UI_ITEM_SUB_LOC_LOVS.GET_PICKLOAD_LOC_DETAILS');

6683: , x_return_status OUT NOCOPY VARCHAR2 ) IS
6684: BEGIN
6685: x_loc_exists := 'Y';
6686: BEGIN
6687: DEBUG('INV_UI_ITEM_SUB_LOC_LOVS.GET_PICKLOAD_LOC_DETAILS');
6688: DEBUG('p_inventory_location_id -> '||p_inventory_location_id);
6689: DEBUG('p_organization_id -> '||p_organization_id);
6690: SELECT subinventory_code
6691: , CONCATENATED_SEGMENTS

Line 6921: debug('Inside INV_UI_ITEM_SUB_LOC_LOVS.get_prj_to_loc_lov');

6917: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6918: l_ispjm_org VARCHAR2(1);
6919: l_sub_type NUMBER;
6920: BEGIN
6921: debug('Inside INV_UI_ITEM_SUB_LOC_LOVS.get_prj_to_loc_lov');
6922: debug('p_organization_id : ' || p_organization_id);
6923: debug('p_subinventory_code : ' || p_subinventory_code);
6924: debug('p_restrict_locators_code : ' || p_restrict_locators_code);
6925: debug('p_inventory_item_id : ' || p_inventory_item_id);

Line 7173: END inv_ui_item_sub_loc_lovs;

7169:
7170:
7171: END LOC_EXISTS_PROC;
7172:
7173: END inv_ui_item_sub_loc_lovs;