APPS.INV_RCV_COMMON_APIS dependencies on INV_MATERIAL_STATUS_GRP

Line 3118: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id

3114: FROM mtl_item_sub_inventories mis
3115: WHERE mis.organization_id = p_organization_id
3116: AND mis.inventory_item_id = p_item_id
3117: AND mis.secondary_inventory = l_sub
3118: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id
3119: , p_item_id, l_sub, NULL, NULL, NULL, 'Z') = 'Y');
3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: x_return_status := fnd_api.g_ret_sts_error;

Line 3141: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id

3137: FROM mtl_secondary_inventories msi
3138: WHERE msi.organization_id = p_organization_id
3139: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3140: AND msi.secondary_inventory_name = l_sub
3141: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id
3142: , p_item_id, l_sub, NULL, NULL, NULL, 'Z') = 'Y');
3143: EXCEPTION
3144: WHEN OTHERS THEN
3145: x_return_status := fnd_api.g_ret_sts_error;

Line 3171: AND inv_material_status_grp.is_status_applicable(

3167: WHERE msl.organization_id = p_organization_id
3168: AND msl.inventory_item_id = p_item_id
3169: AND msl.subinventory_code = l_sub
3170: AND msl.secondary_locator = l_locator_id
3171: AND inv_material_status_grp.is_status_applicable(
3172: 'TRUE'
3173: , NULL
3174: , l_transaction_type
3175: , NULL

Line 3207: AND inv_material_status_grp.is_status_applicable(

3203: WHERE mil.organization_id = p_organization_id
3204: AND mil.subinventory_code = l_sub
3205: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3206: AND mil.inventory_location_id = l_locator_id
3207: AND inv_material_status_grp.is_status_applicable(
3208: 'TRUE'
3209: , NULL
3210: , l_transaction_type
3211: , NULL

Line 5363: inv_material_status_grp.update_status(

5359: AND(p_update_status = 'TRUE'))
5360: OR (p_transfer_organization_id IS NOT NULL AND
5361: l_exists = 'FALSE' AND l_status_enabled = 'Y' AND l_dest_status_enabled = 'Y')) THEN --Added OR condition for bug 3853202, Added l_status_enabled bug3998321
5362: --Added l_dest_status_enabled = 'Y' bug4035918
5363: inv_material_status_grp.update_status(
5364: p_api_version_number => p_api_version
5365: , p_init_msg_lst => NULL
5366: , x_return_status => x_return_status
5367: , x_msg_count => x_msg_count

Line 5547: inv_material_status_grp.update_status(

5543: IF (l_inv_po_j_higher = FALSE) THEN
5544:
5545: IF p_update_serial_status = 'TRUE' THEN
5546: l_progress := '40';
5547: inv_material_status_grp.update_status(
5548: p_api_version_number => p_api_version
5549: , p_init_msg_lst => NULL
5550: , x_return_status => x_return_status
5551: , x_msg_count => x_msg_count

Line 5821: inv_material_status_grp.update_status(

5817: l_progress := '60';
5818:
5819: IF p_update_serial_status = 'TRUE' THEN
5820: l_progress := '70';
5821: inv_material_status_grp.update_status(
5822: p_api_version_number => p_api_version
5823: , p_init_msg_lst => NULL
5824: , x_return_status => x_return_status
5825: , x_msg_count => x_msg_count